BI ETL Test Engineer

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.

Your Role

• Design and execute ETL test cases to validate data extraction, transformation, and loading processes across source and target systems.
• Develop and optimize complex SQL queries to perform data validation, reconciliation, and integrity checks in data warehouses and databases.
• Validate source-to-target mappings, transformation rules, data quality, and business logic to ensure accurate data movement and reporting.I
• dentify, analyze, and troubleshoot data discrepancies, ETL job failures, and performance issues, working closely with development and data engineering teams.
• Collaborate with Business Analysts, Developers, and QA teams to define test strategies, test scenarios, and acceptance criteria for data integration and warehouse projects.
  
  

Your Profile

• 6 to 9 years of experience in ETL and SQL Testing, with strong expertise in validating data warehouse and data integration solutions.
• Hands-on experience in ETL testing, including source-to-target validation, transformation testing, data migration, and data reconciliation.
• Strong proficiency in writing complex SQL queries for data validation, data quality checks, and backend database testing.
• Good understanding of Data Warehouse concepts, ETL architecture, dimensional modeling, and reporting/database systems
• Experience working in Agile/Scrum environments, collaborating closely with Data Engineers, Developers, Business Analysts, and QA teams.
  
  

What will you love working at Capgemini?

• Opportunity to work on large-scale ETL, Data Warehouse, and Data Migration projects across enterprise environments.
• Exposure to modern data integration technologies, cloud platforms, and advanced SQL-based testing frameworks.
• Structured learning programs, certifications, and continuous upskilling opportunities in ETL, Data Engineering, and Cloud technologies.
• Collaborative and innovation-driven culture focused on data quality, automation, and delivering reliable data solutions.
  
  

Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organizations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of €22.1 billion.

Make it real | www.capgemini.com

---