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
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 (Noida)
