ETL Test Engineer

Capgemini • New York, NY

6d • Hybrid

About The Position

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.Job Location : Columbus, OH (Onsite/Hybrid)Job DescriptionWe are looking for an experienced ETL Test Engineer with strong skills in ETL Testing and SQL. The ideal candidate will ensure data accuracy, quality, and reliability across enterprise applications and contribute to the full testing lifecycle—planning, designing, executing, and automating tests.

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.
• Knowledge of automation frameworks and CI/CD tools is a plus.

Nice To Haves

• Experience with tools like Informatica, DataStage, Talend, or SSIS.
• Exposure to cloud platforms such as AWS, Azure, or GCP.
• Experience working in Agile environments.

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.

Benefits

• Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed