Etl Testing Engineer

Infosys; Chennai District, Bengaluru, Hyderabad; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Infosys is seeking an experienced ETL Testing Engineer to join our data warehouse testing team. You will validate ETL processes, perform SQL checks, and collaborate with data engineers and analysts.

You will design test strategies, execute regression tests, and ensure data quality across source-target mappings. Familiarity with Informatica, Talend, and cloud data services is a plus.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Strong analytical and problem-solving skills.
• Excellent verbal and written communication skills.
• Ability to work in Agile/Scrum environments.

Responsibilities

• Analyze business requirements, data models, source-to-target mappings, and ETL specifications.
• Design and develop ETL test strategies, test plans, test cases, and test scenarios.
• Validate data extraction, transformation, and loading processes.
• Perform source-to-target data validation and reconciliation.
• Execute database testing using SQL queries.
• Identify, document, track, and resolve data quality issues and defects.
• Verify data integrity, data completeness, and data consistency.
• Perform regression, integration, system, and performance testing for ETL workflows.
• Validate data warehouse and data mart implementations.
• Collaborate with ETL developers, business analysts, and data architects.
• Participate in test execution cycles and provide status reports.
• Ensure compliance with data governance and data quality standards.

Skills

ETL Testing

Data Warehouse Testing

SQL

Informatica

Talend

DataStage

SSIS

Azure Data Factory

AWS Glue

BigQuery

Unix/Linux

API/JSON/CSV testing

Education

Bachelor's degree in Computer Science / IT or related field

Tools

Informatica

Talend

DataStage

SSIS

Azure Data Factory

AWS Glue

Job description

ETL Testing Engineer

Job Title

ETL Testing Engineer / ETL QA Analyst

Experience

4-10 Years

Job Location

As per business requirement

Job Summary

We are seeking a detail-oriented ETL Testing Engineer with strong experience in Data Warehouse (DWH), ETL processes, and database testing. The candidate will be responsible for validating data extraction, transformation, and loading processes, ensuring data accuracy, completeness, and integrity across source and target systems.

Key Responsibilities

• Analyze business requirements, data models, source-to-target mappings, and ETL specifications.
• Design and develop ETL test strategies, test plans, test cases, and test scenarios.
• Validate data extraction, transformation, and loading processes.
• Perform source-to-target data validation and reconciliation.
• Execute database testing using SQL queries.
• Identify, document, track, and resolve data quality issues and defects.
• Verify data integrity, data completeness, and data consistency.
• Perform regression, integration, system, and performance testing for ETL workflows.
• Validate data warehouse and data mart implementations.
• Collaborate with ETL developers, business analysts, and data architects.
• Participate in test execution cycles and provide status reports.
• Ensure compliance with data governance and data quality standards.

Required Skills

Technical Skills

• Strong experience in ETL Testing and Data Warehouse Testing.
• Excellent SQL skills with experience in:
• Complex joins
• Stored procedures
• Views
• Functions
• Data validation queries
• Experience with ETL tools such as:
• Informatica
• Talend
• DataStage
• SSIS
• Azure Data Factory (ADF)
• AWS Glue
• Strong understanding of:
• Data Warehousing concepts
• Star Schema
• Snowflake Schema
• Fact and Dimension Tables
• Experience in Data Quality Testing.
• Knowledge of Unix/Linux commands.
• Exposure to API and file validation testing (CSV, XML, JSON).

Database Skills

• Oracle
• SQL Server
• PostgreSQL
• Teradata
• Snowflake
• MySQL

Cloud Skills (Preferred)

• Azure Data Factory
• Azure Synapse
• AWS Redshift
• AWS Glue
• Google BigQuery

Testing Tools

• JIRA
• HP ALM
• Quality Center
• Azure DevOps

Required Qualifications

• Bachelor\'s degree in Computer Science, Information Technology, or related field.
• Strong analytical and problem-solving skills.
• Excellent verbal and written communication skills.
• Ability to work in Agile/Scrum environments.

Preferred Qualifications

• Experience with Big Data Testing (Hadoop, Hive, Spark).
• Experience in cloud-based data migration projects.
• Knowledge of automation frameworks for ETL testing.
• Certifications in ETL, Data Engineering, Azure, AWS, or Snowflake.