ETL Tester (SDET – Data Testing & Automation)

We are seeking an experienced ETL Tester with strong expertise in ETL/Data Warehouse Testing, Playwright, Cypress, Selenium, JavaScript, Java, Python, Azure Data Factory (ADF), and SQL. The ideal candidate will be responsible for validating enterprise data pipelines, ETL/ELT processes, cloud-based data integration workflows, and business-critical reporting systems while developing robust automation frameworks for web and data applications.

The candidate should possess strong knowledge of data validation, database testing, API testing, automation testing, and Azure Data Factory pipelines, ensuring data accuracy, completeness, consistency, and quality throughout the data lifecycle.

Key Roles & ResponsibilitiesETL & Data Validation

Design, develop, and execute comprehensive ETL test strategies and test plans.

Validate ETL/ELT workflows, data transformations, and data migration processes.

Perform source-to-target data validation for enterprise data warehouse projects.

Validate Azure Data Factory (ADF) pipelines, data ingestion workflows, and orchestration processes.

Execute data reconciliation, completeness, consistency, and accuracy testing.

Identify and troubleshoot data quality issues across multiple systems.

Validate business rules, transformation logic, lookup tables, aggregations, and data mappings.

Perform database testing using SQL queries, joins, stored procedures, views, and functions.

Validate large datasets across relational databases and cloud data platforms.

Test Automation

Design and maintain automation frameworks using Playwright, Cypress, and Selenium.

Develop reusable automated test scripts using JavaScript, Java, and Python.

Automate UI, regression, smoke, integration, and end-to-end testing.

Integrate automated testing into CI/CD pipelines for continuous quality assurance.

API & Database Testing

Validate REST APIs supporting ETL and data integration workflows.

Perform backend testing using SQL and API validation tools.

Verify data synchronization between source systems, APIs, and target databases.

Quality Engineering

Collaborate with Data Engineers, Developers, Business Analysts, and QA teams.

Participate in Agile ceremonies including Sprint Planning, Daily Standups, Reviews, and Retrospectives.

Prepare test cases, test data, defect reports, and execution reports.

Perform root cause analysis and support defect resolution.

Ensure compliance with enterprise data governance and quality standards.

Continuously improve automation coverage and testing processes.

Required Technical SkillsETL & Data Testing

ETL Testing

ETL Validation

Data Warehouse Testing

Data Migration Testing

Source-to-Target Validation

Data Reconciliation

Data Quality Testing

Data Mapping Validation

ETL Automation

Automation Testing

Playwright

Cypress

Selenium WebDriver

UI Automation

Regression Testing

Smoke Testing

Functional Testing

Cross-Browser Testing

Programming Languages

JavaScript

Java

Python

Database & SQL

SQL

Complex Queries

Stored Procedures

Views

Joins

Functions

Data Validation

Azure

Azure Data Factory (ADF)

Pipeline Validation

ETL Pipeline Monitoring

API Testing

REST APIs

Postman

JSON Validation

CI/CD & Version Control

Azure DevOps

Jenkins

Git

GitHub

Methodologies

Agile

Scrum

SDLC

STLC

Continuous Testing

Preferred Skills

Experience with Snowflake, Azure Synapse, Databricks, or SQL Server

Knowledge of Power BI or Tableau report validation

Exposure to Azure Data Lake Storage (ADLS)

Experience with cloud data platforms

Performance and API automation testing

Basic understanding of Python-based ETL frameworks

Experience Required

4–8+ years of experience in ETL Testing and Data Quality Assurance.

Hands-on experience with Azure Data Factory (ADF).

Strong expertise in SQL and database validation.

Experience in automation using Playwright, Cypress, or Selenium.

Experience working in Agile development environments.

Knowledge of CI/CD and DevOps testing practices.

Educational Qualifications

Bachelor's or Master's degree in Computer Science, Information Technology, Software Engineering, Data Engineering, or a related discipline.

Professional Certifications (Preferred)

ISTQB Certified Tester

Microsoft Certified: Azure Data Engineer Associate

Microsoft Certified: Azure Fundamentals

Azure Data Factory Certification (Preferred)

Soft Skills

Strong analytical and problem-solving skills

Excellent communication and collaboration abilities

High attention to detail

Ability to work independently and within cross-functional teams

Strong debugging and troubleshooting capabilities

Time management and organizational skills

Nice-to-Have Skills

Azure Synapse Analytics

Snowflake

Databricks

Data Lake technologies

Performance Testing

AI-assisted Test Automation

DevOps and Continuous Delivery

Tools & Technologies

ETL: Azure Data Factory (ADF)

Automation: Playwright, Cypress, Selenium

Programming: JavaScript, Java, Python

Database: SQL Server, Oracle, MySQL

API: REST APIs, Postman

Version Control: Git

CI/CD: Azure DevOps, Jenkins, GitHub

Methodology: Agile, Scrum

Cloud: Microsoft Azure

Work Location: Hybrid remote in Noida, Uttar Pradesh