Infosys—Data Warehouse Testing Lead

Job description

Description: 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. Requirements: 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. Skills: 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