Data Warehouse Testing/ETL Testing Professional

Infosys; Hyderabad; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Infosys is seeking candidates for a role focusing on Data Warehouse Testing in Hyderabad, India. As a pivotal part of the Infosys Quality Engineering team, you will lead end-to-end testing initiatives and ensure data quality across multiple projects. You should possess a Bachelor of Engineering and have significant expertise in AWS Testing, DWT, ETL tools, and PL/SQL. The role also entails preparing test cases and collaborating with various teams to ensure high standards of quality are met. This position offers a strong opportunity for technical leadership and mentoring junior team members.

Responsibilities

• Lead end-to-end Data Warehouse Testing initiatives across multiple projects.
• Design, plan, and execute test strategies and test plans for data warehouse components.
• Validate data mapping, data transformations, and data movement.
• Develop and maintain comprehensive test cases for DWT and ETL testing.
• Perform functional, regression, system integration, and UAT for data warehouse solutions.
• Analyze complex SQL queries to identify data discrepancies.
• Collaborate with ETL developers and business analysts to clarify requirements.
• Establish and enforce quality standards for data testing.
• Provide technical leadership and mentoring to junior testers.
• Prepare clear test reports and defect metrics.
• Participate in design and code review discussions.
• Coordinate with cross-functional teams for timely test execution.

Skills

Cloud testing - AWS Testing

DWT (Data Warehouse Testing)

ETL

Test Data Management (Delphix)

Test Data Management (IBM Optim)

PL/SQL

Python

Bigdata - Python

Education

Bachelor of Engineering

Job description

Educational Requirements

Bachelor of Engineering

Service Line

Infosys Quality Engineering

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 and Professional 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

Preferred Skills

• Technology->ETL & Data Quality->ETL - Others
• Technology->Data Services Testing->Data Warehouse Testing->ETL tool