BI ETL Test Engineer
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. This position is onsite in Phoenix, AZ. 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.
Requirements
- 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 PowerCenter, 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.
Nice To Haves
- Exposure to reporting and visualization tools such as Power BI, Tableau, or Business Objects
- Informatica PowerCenter
- Informatica IICS / IDMC
- ETL Testing
- BI Testing
- Data Warehouse Testing
- SQL / PL-SQL
- Data Validation
- Data Reconciliation
- Data Lineage
Responsibilities
- 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 PowerCenter, 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.
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
