> Markdown version of [/jobs/ext/4475535-bi-etl-test-engineer](https://www.wearedevelopers.com/jobs/ext/4475535-bi-etl-test-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# BI ETL Test Engineer

- **Company:** Capgemini
- **Location:** Santa Clara, CA, United States
- **Experience:** Expert
- **Salary:** $76,730.0 - $150,800.0
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Big Data, Bug Tracking Systems, Code Coverage, Software Documentation, Information Systems, Data Auditing, Data Validation, Data Governance, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Transformation, Data Mining, Data Warehousing, Database Queries, Meta-Data Management, Power BI, SQL Databases, Tableau (Software), Test Management, Strategies of Testing, Performance Testing, Sql Optimization, Informatica Powercenter, Test Scripts, Sap Business Objects, Information Technology, Data Lineage
- **Published:** October 13, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=3e4129d1b412d22e

## About the Role

* 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.
 * Exposure to reporting and visualization tools such as Power BI, Tableau, or Business Objects, Informatica PowerCenterInformatica IICS / IDMCETL TestingBI TestingData Warehouse TestingSQL / PL-SQLData ValidationData ReconciliationData Lineage
*

## Description

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., * 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.