ETL Lead consultant

Infosys; Bengaluru; On-site; INR 700,000 - 1,200,000; Full time

Job summary

Infosys Bengaluru is seeking a Data Services Testing professional to validate ETL processes and data pipelines. You will design test plans, write test scenarios and scripts, and ensure data quality, integrity and reconciliation across source-to-target mappings.

Join a collaborative team; work with ETL developers and data engineers in an Agile environment, performing DW/ETL testing, SQL validation, and generating quality metrics for release readiness.

Qualifications

• MCA/MSc/MTech or BE/BCA/BSc/BTech in relevant field.
• Experience in Data Warehouse testing and ETL testing.
• Strong SQL and data-validation skills.

Responsibilities

• Analyze business requirements, mappings and data models.
• Create test plans, scenarios, test cases and scripts for ETL.
• Validate ETL data extraction, transformation and loading.
• Perform DW, ETL, Data Migration, Regression and Integration testing.
• Verify data quality, integrity, reconciliation and completeness.
• Execute SQL queries for data validation and backend testing.
• Identify and resolve data-related defects.
• Validate large-scale datasets and pipelines.
• Collaborate with ETL developers, data engineers and stakeholders.
• Participate in Agile/Scrum ceremonies and release testing.
• Generate test execution reports and quality metrics.

Skills

ETL testing

SQL

Data testing

Agile/Scrum

Education

MCA

MSc

MTech

Bachelor of Engineering

BCA

BSc

BTech

Tools

ETL tool

Job description

Responsibilities

• Analyze business requirements, source-to-target mappings, and data models.
• Develop test plans, test scenarios, test cases, and test scripts for ETL processes.
• Validate data extraction, transformation, and loading between source and target systems.
• Perform Data Warehouse, ETL, Data Migration, Regression, and Integration Testing.
• Verify data quality, data integrity, data reconciliation, and data completeness.
• Execute SQL queries for data validation and backend testing.
• Identify, track, and resolve data-related defects.
• Validate large-scale datasets and data pipelines.
• Collaborate with ETL developers, data engineers, business analysts, and stakeholders.
• Participate in Agile/Scrum ceremonies and release testing activities.
• Generate test execution reports and quality metrics.

Technical Requirement

• Technology->Data Services Testing->Data Warehouse Testing->ETL tool

Educational Requirement

• MCA
• MSc
• MTech
• Bachelor of Engineering
• BCA
• BSc
• BTech

Preferred Skills Service Line

• Infosys Quality Engineering