Ganesh Kumbhar
Senior Analyst | ETL QA TESTER
Hire this person
Send a job offer directly to this candidate
About
Results-driven ETL QA Tester with 4.3 years of experience in data warehousing and ETL testing. Strong expertise in validating data using SQL queries, ensuring data accuracy between source and target systems. Hands-on experience in testing full load and incremental load processes, including SCD Type 1 and Type 2 validations. I am skilled in identifying data quality issues, performing data reconciliation, and validating transformations.
Experience working with tools like Informatica, Toad, and SQL Developer. Good understanding of data models, data mapping, and ETL workflows. Proficient in writing complex SQL queries for data validation and troubleshooting. Strong analytical, problem-solving skills, and ability to work in Agile environments.
Experience
ETL QA Tester at Capgemini (2021-12 – 2026-05)
- Analyzed business requirements and source-to-target mapping documents to understand ETL workflows
- Designed, developed, and executed test cases and test scenarios for ETL processes
- Performed end-to-end data validation to ensure accuracy, completeness, and consistency of data
- Wrote and optimized complex SQL queries (joins, subqueries, aggregations) for data validation and reconciliation
- Validated data transformation logic as per business rules
- Conducted data quality checks including null, duplicate, and data mismatch validation
- Tested ETL jobs, workflows, and scheduling processes to ensure smooth data loads
- Identified, logged, and tracked defects; collaborated with developers for timely resolution
- Performed regression testing after enhancements and bug fixes
- Monitored ETL job performance and identified bottlenecks for optimization
- Prepared detailed test reports, validation reports, and documentation
- Worked with ETL tools like Informatica
Education
Bachelor of Engineering in Mechanical Engineering – Solapur University (2021)