Senior ETL Test Engineer

Highbrow Technology Inc; India; On-site; INR 1,000,000 - 1,800,000; Full time

Job summary

Highbrow Technology Inc is seeking a Senior ETL Test Engineer to validate complex data pipelines, migrations, and data quality across large datasets. You will design tests, review data transformations, and perform source-to-target reconciliation in an Agile environment.

The ideal candidate has 8+ years in ETL/Data Warehouse testing, strong SQL skills, and hands-on experience with Informatica, DataStage, SSIS, or Talend, plus Jira/Azure DevOps familiarity. Remote options may vary by project.

Qualifications

• 8+ years of experience in ETL/Data Warehouse Testing.
• Strong hands-on experience with one or more ETL tools: Informatica, DataStage, SSIS, or Talend.
• Strong SQL and database testing skills.
• Good understanding of Data Warehouse concepts and ETL architecture.
• Experience in Data Migration and Source-to-Target Reconciliation Testing.
• Experience with JIRA or Azure DevOps.
• Strong understanding of Agile/Scrum methodologies.

Responsibilities

• Design and execute ETL test cases, scenarios, and test plans.
• Validate data transformations, mappings, business rules, and workflows.
• Perform source-to-target validation and data reconciliation.
• Conduct data quality, completeness, accuracy, and integrity testing.
• Perform database and SQL testing across large datasets.
• Validate data migration and end-to-end ETL processes.
• Identify, document, track, and support resolution of defects using JIRA/Azure DevOps.
• Collaborate with Developers, Business Analysts, Data Engineers, and other stakeholders in an Agile/Scrum environment.
• Support root-cause analysis for data and ETL-related issues.

Skills

ETL Testing

SQL

Agile/Scrum

Data Warehouse

Data Migration

Source-to-Target

Data Quality

Data Integrity

JIRA

Azure DevOps

ETL Automation

Snowflake

Oracle

SQL Server

Teradata

Azure

AWS

GCP

Informatica

DataStage

SSIS

Talend

Tools

Informatica

DataStage

SSIS

Talend

JIRA

Azure DevOps

Azure

AWS

GCP

Snowflake

Job description

We are looking for an experienced Senior ETL Test Engineer with strong expertise in ETL, Data Warehouse, Data Migration, and Database Testing. The candidate should have hands-on experience validating complex data pipelines, transformations, mappings, and source-to-target data reconciliation.

Key Responsibilities

• Design and execute ETL test cases, scenarios, and test plans.
• Validate data transformations, mappings, business rules, and workflows.
• Perform source-to-target validation and data reconciliation.
• Conduct data quality, completeness, accuracy, and integrity testing.
• Perform database and SQL testing across large datasets.
• Validate data migration and end-to-end ETL processes.
• Identify, document, track, and support resolution of defects using JIRA/Azure DevOps.
• Collaborate with Developers, Business Analysts, Data Engineers, and other stakeholders in an Agile/Scrum environment.
• Support root-cause analysis for data and ETL-related issues.

Required Skills

• 8+ years of experience in ETL/Data Warehouse Testing.
• Strong hands-on experience with one or more ETL tools:
• Informatica, DataStage, SSIS, or Talend.
• Strong SQL and database testing skills.
• Good understanding of Data Warehouse concepts and ETL architecture.
• Experience in Data Migration and Source-to-Target Reconciliation Testing.
• Experience with JIRA or Azure DevOps.
• Strong understanding of Agile/Scrum methodologies.

Preferred Skills

• Experience with Snowflake, Oracle, SQL Server, or Teradata.
• Exposure to cloud data platforms such as Azure, AWS, or GCP.
• Experience with ETL Test Automation Frameworks.
• Exposure to automated data validation and regression testing.