Software Test Engineer -g

Infosys; Hyderabad; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

Infosys invites an ETL Testing Engineer to validate data extraction, transformation and loading in data warehouse environments. The role emphasizes strong SQL, hands-on ETL testing and data quality assurance, with collaboration across developers, data engineers, and business analysts.

The position involves designing ETL test cases, validating mappings, performing data integrity checks, and supporting regression, integration, and UAT testing across BI platforms.

Qualifications

• Bachelor’s degree in CS/IT/Engineering or related field.
• Certification in ETL or Data Warehousing is a plus.
• 4–10 years of ETL testing and data quality experience.

Responsibilities

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

Skills

ETL Testing

SQL

Data Validation

Defect Tracking

BI Testing

Cloud Data Platforms

Big Data

Education

Bachelor's degree (CS/IT/Engineering)

Tools

Informatica

SSIS

Talend

DataStage

Ab Initio

JIRA

Azure DevOps

Oracle

SQL Server

MySQL

PostgreSQL

Teradata

Azure Data Factory

Azure Synapse

AWS Glue

Snowflake

Databricks

Job description

Job Description

ETL Testing Engineer

Job Title

ETL Testing Engineer / Data Warehouse Tester

Experience

4 -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.

Job Classification

Industry: IT Services & Consulting

Functional Area / Department: Quality Assurance

Role Category: Quality Assurance - Other

Role: Quality Assurance - Other

Employement Type: Full time

Contact Details:

Company: Infosys

Location(s): Hyderabad

Ability to work in a team environment with members of varying skill levels. Highly motivated. Learns quickly.