Data Warehouse Testing

Infosys; Bengaluru; On-site; INR 600,000 - 900,000; Full time

Job summary

Infosys is seeking a skilled professional for Data Warehouse Testing initiatives in Bengaluru, India. This role includes designing and executing test strategies while validating data movements and transformations across complex projects.

The ideal candidate will hold a Bachelor of Engineering and possess strong skills in AWS Testing, ETL, and SQL analysis. Responsibilities also include mentoring junior testers and collaborating cross-functionally. The position is based on business requirements across locations.

Qualifications

• Bachelor of Engineering required.
• Strong skills in Cloud Testing - AWS and Data Warehouse Testing.
• Experience with ETL tools and PL/SQL.

Responsibilities

• Lead end-to-end Data Warehouse Testing initiatives ensuring data quality.
• Design, plan, and execute test strategies for ETL components.
• Analyze complex SQL datasets to identify discrepancies.

Skills

Cloud Testing - AWS Testing

Data Warehouse Testing (DWT)

ETL (Extract, Transform, Load)

PL/SQL

Python

Test Data Management

Education

Bachelor of Engineering

Tools

Delphix

IBM Optim

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

Generic Skills

Technology->ETL Data Quality->ETL Data Quality - ALL->Jaspersoft - Jaspersoft ETL