ETL Test Engineer

About This Role

This role is for an experienced ETL Test Engineer to ensure data accuracy, quality, and reliability across enterprise applications at Capgemini. The engineer will contribute to the full testing lifecycle, including planning, designing, executing, and automating tests.

Responsibilities

• Develop and execute ETL test plans, test cases, and data validation scripts
• Perform source-to-target mapping verification and transformation logic testing
• Write and run complex SQL queries for data accuracy and integrity checks
• Conduct functional, regression, and risk-based testing
• Support test automation, test data management, and performance testing
• Work closely with cross-functional teams to understand requirements and resolve issues
• Contribute to CI/CD processes and continuous quality improvements

Requirements

• 6+ years of ETL testing experience
• Strong SQL expertise
• Solid understanding of ETL concepts and data warehousing
• Experience with QA methodologies and defect management

Qualifications

• 6+ years of ETL testing experience

Nice to Have

• Knowledge of automation frameworks and CI/CD tools
• Experience with tools like Informatica, DataStage, Talend, or SSIS
• Exposure to cloud platforms such as AWS, Azure, or GCP
• Experience working in Agile environments

Skills

* Required skills

Benefits