Data Warehouse Testing Lead

Infosys

2–13 yrs Bengaluru Full Time Work from office
Infosys logo
Posted : today
Actively hiring

Job description

Join our Quality Engineering team as a Data Warehouse Testing Lead and play a crucial role in ensuring the accuracy and reliability of critical business data. This position offers the chance to lead testing initiatives for complex Data Warehouse (DWH) and ETL systems, working collaboratively with data engineers, BI developers, and business stakeholders to validate end-to-end data flows. You will have the opportunity to define test strategies, implement best practices, and mentor a team of testers on large-scale, enterprise data platforms. If you are passionate about tackling data quality challenges, building robust test frameworks, and driving continuous improvement in a collaborative setting, this role provides a significant opportunity to influence how data empowers the organization's success.

Responsibilities

Lead comprehensive Data Warehouse Testing (DWT) efforts across various projects, guaranteeing high standards of data quality and integrity. Develop, plan, and execute test strategies and detailed test plans for DWH and ETL components, aligning with both business and technical requirements. Verify data mapping, transformations, aggregations, and data movement from source systems through staging, DWH, and to downstream applications. Create and maintain extensive test cases, scenarios, and test data sets specifically for DWT and ETL testing. Conduct functional, regression, system integration, and user acceptance support testing for data warehouse solutions. Analyze complex SQL queries and datasets to pinpoint data discrepancies, defects, and their root causes. Collaborate effectively with ETL developers, data modelers, and business analysts to clarify requirements and resolve defects promptly. Establish and enforce quality standards, best practices, and testing processes for the team. Offer technical leadership and mentorship to junior testers, guiding them in DWT and ETL testing techniques and tools. Produce clear test reports, defect metrics, and quality dashboards for stakeholders and project management. Engage in design and code reviews from a quality assurance perspective, identifying potential data quality risks. Coordinate with cross-functional teams to ensure timely test execution and alignment with project timelines and release schedules.

Qualifications

A strong background in Data Warehouse Testing (DWT) and ETL processes is essential, complemented by expertise in Cloud testing, specifically AWS. Proficiency in PL/SQL is required for data analysis and validation. Experience with Test Data Management (TDM) tools such as Delphix or IBM Optim is expected. Familiarity with Master Data Management (MDM) concepts and Python for scripting and automation is also a key requirement. The role involves a Bachelor of Engineering degree and 2-13 years of experience. Primary skills include Cloud testing (AWS Testing), DWT/ETL, TDM (Delphix, IBM Optim), PL/SQL, MDM, and Python. Desired skills include Bigdata and Python.

Essential Skills

AWS TestingData Warehouse Testing (DWT)ETLTest Data Management (TDM)DelphixIBM OptimPL/SQLMDMPythonETL - Foundation

Good to Have

Python

Highlights

  • Actively hiring

More Details

RoleData Warehouse Testing Lead
IndustryInformation Technology & Services
DepartmentQuality Assurance
Employment TypeFull Time, Work from office

About the Company

Infosys logo

Infosys

Information Technology & Services

Data Warehouse Testing Lead at Infosys | SkillMX | SkillMX