ETL Testing with Azure

Elabs Infotech; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Elabs Infotech is seeking an experienced ETL/Data Warehouse Tester to design and execute comprehensive ETL/ELT test scenarios for data ingestion, transformation, migration, and validation, with a focus on accuracy and data integrity.

The role requires strong SQL, hands-on Azure Data Factory, Azure SQL/ADLS/Synapse, and familiarity with Agile ceremonies; you will validate end-to-end pipelines and contribute to test plans and reports.

Qualifications

• Experience with ETL/Data Warehouse Testing and data reconciliation.
• Strong SQL skills including complex joins, subqueries, CTEs, and window functions.
• Understanding of SDLC/STLC and Agile methodologies.

Responsibilities

• Design and execute ETL/ELT test scenarios for ingestion, transformation, migration, and validation.
• Validate data pipelines built using Azure Data Factory and ensure data is transferred correctly between source and target systems.
• Perform source-to-target data validation including completeness, accuracy, consistency, and integrity checks.
• Validate data transformations, business rules, aggregations, joins, lookups, and calculated fields.
• Write and execute complex SQL queries for backend/database validation.
• Test data stored in Azure SQL Database, Azure Synapse Analytics, and Azure Data Lake Storage.

Skills

ETL Testing

SQL

Tools

Azure Data Factory

Azure SQL

Azure Synapse Analytics

Azure Data Lake Storage

Azure DevOps

Job description

Required Skills

• 68+ years of experience in ETL/Data Warehouse Testing.
• Strong SQL skills, including complex joins, subqueries, CTEs, window functions, and data reconciliation.
• Hands‑on experience with Azure Data Factory.
• Good knowledge of Azure Data Lake Storage, Azure SQL, and Azure Synapse Analytics.
• Experience with Azure DevOps or similar defect/test management tools.
• Understanding of SDLC/STLC and Agile methodologies.

Good to Have

• Experience with PySpark / Databricks testing.
• Knowledge of Python for test automation and data validation.
• Experience with CI/CD pipelines and Azure DevOps.
• Knowledge of Power BI data validation.
• Experience with cloud data warehouses and modern data platforms.
• Familiarity with automated ETL testing frameworks

Key Responsibilities

• Design and execute ETL/ELT test scenarios for data ingestion, transformation, migration, and validation.
• Validate data pipelines built using Azure Data Factory (ADF) and ensure data is accurately transferred between source and target systems.
• Perform source-to-target data validation, including data completeness, accuracy, consistency, and integrity checks.
• Validate data transformations, business rules, aggregations, joins, lookups, and calculated fields.
• Write and execute complex SQL queries for backend/database validation.
• Test data stored in Azure SQL Database, Azure Synapse Analytics, and Azure Data Lake Storage (ADLS).
• Validate ADF pipelines, datasets, linked services, triggers, parameters, variables, and error‑handling mechanisms.
• Participate in Agile ceremonies including sprint planning, daily stand‑ups, reviews, and retrospectives.
• Prepare test cases, test data, test execution reports, defect reports, and test summary reports.