– ETL Testing Engineer (Cloud Migration & SQL)

Position

ETL Testing Engineer

Experience

3 to 4 Years Relevant Experience

Location

Hyderabad / Hybrid

Job Summary

We are looking for a skilled ETL Testing Engineer with 3–4 years of experience in Data

Warehouse/ETL Testing, Cloud Migration projects, and strong SQL validation skills. The candidate will be responsible for validating data migration from legacy/on-premise platforms to cloud-based data platforms, ensuring data accuracy, completeness, and quality throughout the migration lifecycle.

Key Responsibilities

 Perform end-to-end testing of ETL and Data Migration workflows.

 Validate source-to-target data mappings, transformation logic, and business rules.

 Create test scenarios, test cases, test data, and execute test plans.

 Perform data validation, reconciliation, and data quality testing.

 Write complex SQL queries to compare and validate large datasets.

 Validate batch loads, incremental loads, and historical data migrations.

 Perform functional, integration, system, regression, and UAT testing.

 Analyze requirements, source-to-target mapping documents, and technical specifications.

 Log, track, and retest defects using defect management tools.

 Collaborate with developers, data engineers, architects, and business users during testing cycles.

 Support migration cutover activities and parallel run validations.

Required Skills

ETL & Data Testing

 ETL Testing

Public

 Data Warehouse Testing

 Data Validation & Reconciliation

 Source-to-Target Mapping Validation

 Data Quality Testing

 Regression Testing

SQL

 Strong SQL querying skills

 Complex joins, subqueries, aggregations, and data comparison queries





 Experience working with relational databases such as:

o SQL Server o Oracle o Teradata o PostgreSQL

Cloud Migration

 Experience in Cloud Data Migration projects

 Validation of migrated data between on-premise and cloud platforms

 Knowledge of:

o Azure Databricks o Azure Data Factory (ADF)

o Snowflake (preferred)

o Azure Synapse (positive to have)

Databricks

 Databricks Notebook validation

 Spark SQL validation

 Data pipeline testing

 Delta Lake concepts

Python

 Basic to Intermediate Python scripting

 Data validation automation

 Test data comparison and reconciliation

 Pandas library knowledge preferred

Preferred Qualifications

 Bachelor's Degree in Computer Science, Information Technology, or related discipline.

 Knowledge of Data Warehousing concepts such as Facts, Dimensions, Star Schema,

and SCD.

 Experience in Agile/Scrum development methodologies.

 Familiarity with Jira, Azure DevOps, or ALM tools.

 Exposure to Airflow, Informatica, DataStage, or Pentaho is an added advantage.

Desired Candidate Profile

 3–4 years of hands-on experience in ETL/Data Warehouse Testing.

 Experience working on Cloud Migration or Data Modernization projects.

 Strong analytical and troubleshooting skills.

 Ability to identify data discrepancies and perform root cause analysis.

 Good communication and stakeholder management skills.

 Ability to work independently and within cross-functional teams.

Keywords

ETL Testing, Data Warehouse Testing, SQL, Cloud Migration, Azure Databricks, Python,

Data Validation, Data Reconciliation, Data Quality Testing, Azure Data Factory, Snowflake,

Spark SQL, Data Modernization, Migration Testing.

📌 ETL Testing Engineer (Cloud Migration & SQL) (Hyderabad)
🏢 HCL INDIA
📍 Hyderabad