Data Warehouse Testing Lead

Infosys · IT Services & Consulting

Bangalore, India
On-site
Posted today
Data & AI

About the job

As 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.

Responsibilities

Lead 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 requirements

Primary 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 requirements

Bachelor of Engineering

Preferred skills

Technology->ETL & Data Quality->ETL - Others

Experience: 2-13 years

Apply on Infosys