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.

Location This position is onsite in Phoenix, AZRole Summary We are seeking a BI ETL Test Engineer, you take care of the testing of BI systems. This includes validation of the business data flow , ETL components, data lineage, ETL architecture and you are able to analyze defects during data validation. This includes setting up testing strategy, recommend tools, perform technical feasibility and risk assessments.

Your Role Design, develop, and execute comprehensive test strategies and test plans for BI, ETL, and data warehouse solutions, ensuring high data quality, accuracy, and reliability.

Perform end-to-end validation of business data flows, including source-to-target mappings, data transformations, and reporting layer verification.

Conduct ETL testing for Informatica Power Center, Informatica IICS/IDMC, and related data integration solutions to validate data extraction, transformation, and loading processes.

Validate data lineage, ETL architecture, and data movement across multiple systems to ensure compliance with business requirements and data governance standards.

Analyze and troubleshoot data quality issues, identify root causes of defects, and collaborate with ETL developers and data engineers to implement effective resolutions.

Execute data reconciliation, data integrity, regression, and performance testing to ensure consistency and accuracy across enterprise data environments.

Evaluate, recommend, and implement appropriate testing tools, automation frameworks, and best practices to improve test coverage, efficiency, and quality assurance processes.

Perform technical feasibility studies and risk assessments, identifying potential data, process, and system risks while providing mitigation recommendations.

Collaborate with business analysts, architects, developers, and stakeholders to ensure successful delivery of BI and data integration initiatives.

Develop and maintain test artifacts including test cases, test scripts, validation queries (SQL), defect logs, and testing documentation to support audit and compliance requirements.

Your skills and experience

Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
8+ years of experience in ETL Testing, BI Testing, Data Warehouse Testing, or Data Quality Assurance.

Hands-on experience with Informatica Power Center, IICS, or Informatica IDMC.Strong knowledge of ETL processes, data integration, and data validation techniques.

Advanced SQL skills with the ability to write complex queries for data analysis and validation.

Experience testing large-scale data warehouse and business intelligence environments.

Strong understanding of source-to-target mapping validation and data reconciliation.

Experience with test management and defect tracking tools.

Excellent analytical, troubleshooting, and problem-solving skills.

Strong communication and stakeholder management abilities.

Knowledge of data governance, metadata management, and data lineage concepts.

Experience working in Agile/Scrum environments.

Exposure to reporting and visualization tools such as Power BI, Tableau, or Business Objects,Informatica Power Center Informatica  IICS / IDMCETL TestingBI Testing Data Warehouse Testing SQL / PL-SQLData Validation Data Reconciliation Data Lineage The base compensation range for this role in the posted location is $76,730 - $150,800

Ca…