Software Test Engineer

Infosys; Hyderabad, Pune District, Mumbai; On-site; INR 900,000 - 1,800,000; Full time

Job summary

Infosys is seeking an ETL Testing Engineer to validate data extraction, transformation, and loading processes within data warehouses. Strong SQL skills and hands-on ETL testing experience are required, with familiarity in Informatica, SSIS, Talend, DataStage or Ab Initio.

Collaboration with data engineers and business analysts is essential to ensure data quality and reliable BI outcomes. The role involves designing test plans, executing regression and UAT, and reporting metrics to stakeholders

Qualifications

• 3-10 years of ETL testing experience in data warehouse environments.
• Strong SQL skills and hands-on ETL testing experience.
• Experience validating data extraction, transformation and loading processes.
• Familiarity with data quality and data migration testing.
• Knowledge of star and snowflake schemas, and SCDs.
• Experience with defect tracking tools (JIRA, Azure DevOps).
• Hands-on experience with Informatica, SSIS, Talend, DataStage, Ab Initio.

Responsibilities

• Analyze business and technical requirements for data migration/ETL.
• Design and execute ETL test plans, cases, and scenarios.
• Validate data from source to target with complex SQL queries.
• Perform data integrity, completeness, and reconciliation testing.
• Verify mappings, transformation rules, and business logic.
• Execute database testing and regression/integration testing.
• Identify, document, and track defects through tools.
• Provide UAT support and test status reporting.
• Ensure data quality and consistency across platforms.
• Collaborate with developers, data engineers, and stakeholders.

Skills

ETL Concepts

SQL for validation

Data Warehouse concepts

Data quality testing

CI/CD & DevOps practices

Performance & volume testing

Big Data technologies (Hive, Hadoop, S

Education

Bachelor's degree in CS/IT/Engineering

ETL/Data Warehousing certifications

Tools

Informatica

SSIS

Talend

DataStage

Ab Initio

JIRA

Azure DevOps

Job description

ETL Testing Engineer

Job Title

ETL Testing Engineer / Data Warehouse Tester

Experience

3 -10 Years

Job Summary

We are seeking a skilled ETL Testing Engineer to validate data extraction, transformation, and loading processes in data warehouse and business intelligence environments. The ideal candidate should possess strong SQL skills, hands‑on ETL testing experience, and expertise in data validation and quality assurance.

Key Responsibilities

• Analyze business and technical requirements related to data migration and ETL processes.
• Design and execute ETL test cases, test plans, and test scenarios.
• Validate data extraction, transformation, and loading from source systems to target databases.
• Perform data integrity, completeness, and reconciliation testing.
• Verify data mappings, transformation rules, and business logic.
• Execute database testing using complex SQL queries.
• Identify, document, and track defects through defect management tools.
• Perform regression, integration, system, and UAT support testing.
• Validate data quality and consistency across multiple platforms.
• Collaborate with developers, data engineers, business analysts, and stakeholders.
• Prepare test metrics, reports, and test execution status updates.

Required Skills

• Strong knowledge of ETL Testing concepts and methodologies.
• Hands‑on experience with ETL tools such as:
  • Informatica
  • SSIS (SQL Server Integration Services)
  • Talend
  • DataStage
  • Ab Initio
• Advanced SQL skills for data validation and reconciliation.
• Experience with Data Warehouse concepts including:
  • Star Schema
  • Snowflake Schema
  • Fact and Dimension Tables
  • Slowly Changing Dimensions (SCD)
• Experience with database platforms such as Oracle, SQL Server, MySQL, PostgreSQL, or Teradata.
• Expertise in data quality and data migration testing.
• Familiarity with defect tracking tools (JIRA, Azure DevOps).

Preferred Skills

• Automation experience using Python, Selenium, or ETL automation frameworks.
• Experience with cloud data platforms:
  • Azure Data Factory (ADF)
  • Azure Synapse
  • AWS Glue
  • Snowflake
  • Databricks
• Knowledge of Big Data technologies (Hive, Hadoop, Spark).
• Understanding of CI/CD and DevOps practices.
• Performance and volume testing experience.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
• Certification in ETL, Data Warehousing, or Database technologies is a plus.