Sankaranarayanan Chellappa

Background

About Sankaranarayanan Chellappa

A technically experienced professional with around 14+ years of Information technology experience 2.9 years of experience in PL/SQL development 10+ years of experience in Data Warehousing Testing (ETL Testing & BI Testing) 2+ years of experience in could (AWS) migration testing projects Worked in Amazon Redshift and database as PostgreSQL Worked in different domains Retail, Life Sciences, Healthcare, and Banking Worked on Cloud migration projects like Oracle to AWS and SharePoint to AWS ingestions Box to AWS Performed data validation between SharePoint to AWS and Box to AWS data ingestions. Worked on loading and unloading data between Hive and Snowflake – Full/Incremental load Worked on Hive External and Managed tables – both Partitioned and Non-Partitioned Good working experience in various file formats like Parquet and Avro etc, Worked on Airflow scheduler to execute the jobs and performed end-to-end data flow validation Worked on pyspark utility to load data from S3 to Snowflake Used the existing spark utility that is developed using Python to load the data from AWS S3 to snowflake DB Validated data between On-premises and AWS Expertise in end-to-end system testing of active enterprise wide data warehouse Strong exposure to SDLC activities such as requirements gathering, Data Analysis, Test Plan documentation, Test Strategy documentation Worked closely with client management to identify and specify complex business requirements and processes Experience in end-to-end DW testing including creation of Test Plan & Test Strategy, preparation of Test Estimates, Test Approach, Defect tracking, Test Cases review and Metrics collections.Created Business & Functional Requirements in HP QC and map it with Test Cases. Strong at testing ETL process & BI Reports and ensuring data correctness & data quality as per the Business requirements. Experience in setting up QA best practices and making sure that team is following the set process Sound knowledge and experience in Test Design, Test Execution and Test Results Analysis QA Execution of DW tools like Informatica 9.x and Data stage 9.x and different BI tools like Cognos 10.2.2, Business Objects XI R2 and Micro Strategy Strong exposure in SQL involving activities such as business rules validation, referential integrity validation and ETL Audit process validation Hands on experience in writing complex SQL queries which includes joins and advance functions in Teradata, Oracle 11g, Netezza, SQL Server 2008, DB2 and SYBASE