Looks like you have JavaScript disabled. For the full Twine experience, you will need to re-enable it.

I am a seasoned ETL and data validation professional with over 13 years of experience, specializing in ETL testing, data warehouse validation, cloud data warehouse testing, and data integration across Pharmaceutical, Healthcare, Travel, and Financial domains. I excel at SQL-based data validation, complex queries, data reconciliation, and root cause analysis across staging, ODS, data marts, data warehouses, and BI reporting layers. I also bring strong Python-based ETL test automation, developing reusable scripts for data validation, source-to-target comparison, and automated data quality checks. I have hands-on experience with cloud data warehouses, On-Premises to Snowflake migrations, and AWS-based data pipelines (Redshift, S3, Glue). I’ve led QA teams as a QA Lead, coordinated large-scale enterprise data integration programs, and thrive in Agile environments with a focus on quality, efficiency, and clear communication.…I am a seasoned ETL and data validation professional with over 13 years of experience, specializing in ETL testing, data warehouse validation, cloud data warehouse testing, and data integration across Pharmaceutical, Healthcare, Travel, and Financial domains. I excel at SQL-based data validation, complex queries, data reconciliation, and root cause analysis across staging, ODS, data marts, data warehouses, and BI reporting layers. I also bring strong Python-based ETL test automation, developing reusable scripts for data validation, source-to-target comparison, and automated data quality checks. I have hands-on experience with cloud data warehouses, On-Premises to Snowflake migrations, and AWS-based data pipelines (Redshift, S3, Glue). I’ve led QA teams as a QA Lead, coordinated large-scale enterprise data integration programs, and thrive in Agile environments with a focus on quality, efficiency, and clear communication.

Kalyani Chava

QA Engineer, Data Scientist, Data Analyst, +2





I am a seasoned ETL and data validation professional with over 13 years of experience, specializing in ETL testing, data warehouse validation, cloud data warehouse testing, and data integration across Pharmaceutical, Healthcare, Travel, and Financial domains. I excel at SQL-based data validation, complex queries, data reconciliation, and root cause analysis across staging, ODS, data marts, data warehouses, and BI reporting layers. I also bring strong Python-based ETL test automation, developing reusable scripts for data validation, source-to-target comparison, and automated data quality checks. I have hands-on experience with cloud data warehouses, On-Premises to Snowflake migrations, and AWS-based data pipelines (Redshift, S3, Glue). I’ve led QA teams as a QA Lead, coordinated large-scale enterprise data integration programs, and thrive in Agile environments with a focus on quality, efficiency, and clear communication.…I am a seasoned ETL and data validation professional with over 13 years of experience, specializing in ETL testing, data warehouse validation, cloud data warehouse testing, and data integration across Pharmaceutical, Healthcare, Travel, and Financial domains. I excel at SQL-based data validation, complex queries, data reconciliation, and root cause analysis across staging, ODS, data marts, data warehouses, and BI reporting layers. I also bring strong Python-based ETL test automation, developing reusable scripts for data validation, source-to-target comparison, and automated data quality checks. I have hands-on experience with cloud data warehouses, On-Premises to Snowflake migrations, and AWS-based data pipelines (Redshift, S3, Glue). I’ve led QA teams as a QA Lead, coordinated large-scale enterprise data integration programs, and thrive in Agile environments with a focus on quality, efficiency, and clear communication.

Available to hire

I am a seasoned ETL and data validation professional with over 13 years of experience, specializing in ETL testing, data warehouse validation, cloud data warehouse testing, and data integration across Pharmaceutical, Healthcare, Travel, and Financial domains. I excel at SQL-based data validation, complex queries, data reconciliation, and root cause analysis across staging, ODS, data marts, data warehouses, and BI reporting layers.

I also bring strong Python-based ETL test automation, developing reusable scripts for data validation, source-to-target comparison, and automated data quality checks. I have hands-on experience with cloud data warehouses, On-Premises to Snowflake migrations, and AWS-based data pipelines (Redshift, S3, Glue). I’ve led QA teams as a QA Lead, coordinated large-scale enterprise data integration programs, and thrive in Agile environments with a focus on quality, efficiency, and clear communication.

Skills

Experience Level

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Language

English

Fluent

Work Experience

QA Lead / Senior ETL Tester at Cognizant Technology Solutions

September 1, 2018 - Present

Led ETL and data integration testing for the Enterprise Data Management (EDM) Data Warehouse. Defined test strategy, plans, and scripts across multiple integration systems. Managed offshore QA teams, executing system, integration, regression, and UAT testing in Agile sprints. Developed advanced SQL queries for end-to-end data validation across Staging, ODS, DW, and OAC reporting layers. Built Python-based automation scripts to perform source-to-target validation, data reconciliation, and data quality checks, reducing manual testing effort and increasing accuracy. Tested AWS-based data pipelines (S3, Redshift, Glue), ensuring data integrity across cloud platforms. Validated Informatica workflows, mappings, and sessions; performed cloud migration testing including On-Prem to Snowflake validation and reconciliation. Automated data validation processes using DVS; tracked defects in Jira; enabled timely delivery of high-quality outputs.

ETL QA / Data Validation Lead at Prudential

January 1, 2017 - August 1, 2018

Designed and executed ETL test scenarios, test plans, test cases, and data for Data Warehouse applications. Performed advanced SQL-based data validation and reconciliation across source, staging, and warehouse layers. Validated OBIEE dashboards and BI reports against backend warehouse data for completeness and consistency. Executed integration, regression, and UAT testing; automated data validation and regression testing using SPARTA; tracked defects and collaborated with development and business teams to ensure timely resolution.

ETL QA / Data Validation Lead at Standard & Poor’s Ratings Services

January 1, 2015 - December 1, 2016

Performed ETL and database testing using SQL and Informatica 9.1 to ensure accurate data transformations and load processes. Automated data validation and regression testing using SPARTA; validated OBIEE dashboards and BI reports for completeness and consistency. Analyzed business requirements, designed test scripts and scenarios, and ensured comprehensive coverage of data workflows. Managed offshore QA teams and coordinated Agile sprint deliveries, ensuring timely defect resolution and high-quality deliverables.

ETL Consultant (Pentaho) at Comcast

August 1, 2014 - November 1, 2014

Designed and validated ETL transformations and jobs using Pentaho Data Integration 4.2.1. Extracted and reconciled data from multiple source systems, ensuring accuracy and completeness during migration to production. Monitored data quality, consistency, and integrity across ETL workflows and target systems. Scheduled and managed ETL jobs using UC4 and UNIX Shell scripts, ensuring timely and error-free data loads.

ETL Consultant (Informatica) at JPMorgan Chase

June 1, 2014 - July 1, 2014

Developed and validated ETL mappings, workflows, and transformations using Informatica PowerCenter 8.6.5. Performed SQL-based ETL testing and data validation to ensure accuracy and completeness of data loads. Executed integration, end-to-end, and system testing, preparing test cases and documenting defects. Validated Business Objects reports and collaborated with teams to ensure timely defect resolution.

ETL Consultant (Informatica) at Shire Pharmaceuticals

May 1, 2012 - April 1, 2014

Designed and executed ETL mappings, workflows, and sessions using Informatica PowerCenter 9.01, ensuring accurate data transformations. Performed integration, functional, regression, and system testing using SQL and HP Quality Center to validate data pipelines. Collaborated closely with Business Analysts to ensure test coverage and source-to-target mappings. Validated data across Oracle and Netezza, and automated repetitive tasks using PL/SQL and UNIX Shell scripting.