Data Warehouse Testing Lead
Infosys
Infosys
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.
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.
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.
Infosys
Information Technology & Services