Data Warehouse Testing Lead

Job DescriptionAs a Quality Engineering Lead in Data Warehouse Testing, you will be at the heart of ensuring that business-critical data is accurate, reliable, and ready for insight-driven decisions. You will lead testing efforts across complex DWH and ETL ecosystems, collaborating closely with data engineers, BI developers, and business stakeholders to validate data flows end-to-end. This role offers the opportunity to shape test strategies, introduce best practices, and mentor a team of testers while working on large-scale, enterprise-grade data platforms.If you enjoy solving data quality challenges, designing robust test frameworks, and driving continuous improvement in a collaborative environment, this position will allow you to make a visible impact on how data powers the organization's success.
Roles & ResponsibilitiesLead end-to-end Data Warehouse Testing (DWT) initiatives across multiple projects, ensuring high data quality and integrity.

Design, plan, and execute test strategies and test plans for data warehouse and ETL components based on business and technical requirements.

Validate data mapping, data transformations, aggregations, and data movement from source to staging, DWH, and downstream systems.

Develop and maintain comprehensive test cases, test scenarios, and test data sets for DWT and ETL testing.

Perform functional, regression, system integration, and user acceptance support testing for data warehouse solutions.

Analyze complex SQL queries and datasets to identify data discrepancies, defects, and root causes.

Collaborate with ETL developers, data modelers, and business analysts to clarify requirements and resolve defects efficiently.

Establish and enforce quality standards, best practices, and processes for data testing within the team.

Provide technical leadership and mentoring to junior testers, guiding them on DWT and ETL testing techniques and tools.

Prepare clear test reports, defect metrics, and quality dashboards for stakeholders and project leadership.

Participate in design and code review discussions from a quality perspective, highlighting potential data quality risks.

Coordinate with cross-functional teams to ensure timely test execution and alignment with project timelines and release plans.

Position will be based on business requirements across locations.
Technical RequirementPrimary skills:Cloud testing->AWS Testing,Data Services->DWT (Data Warehouse Testing)/ (ETL),Data Services->TDM (Test Data Management),Data Services->TDM (Test Data Management)->Delphix,Data Services->TDM (Test Data Management)->IBM Optim,Database->PL/SQL,Package testing->MDM,Python

Desirables:Bigdata->Python
Educational RequirementBachelor of Engineering
Preferred SkillsTechnology->ETL & Data Quality->ETL - Others
Generic SkillsTechnology->ETL & Data Quality->ETL & Data Quality - ALL->Pentaho - Pentaho ETL (Kettle)
Service LineInfosys Quality Engineering