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 TestingETL ValidationData Warehouse TestingData Migration TestingSource-to-Target ValidationData ReconciliationData Quality TestingData Mapping ValidationETL AutomationAutomation Testing PlaywrightCypressSelenium WebDriverUI AutomationRegression TestingSmoke TestingFunctional TestingCross-Browser TestingProgramming Languages JavaScriptJavaPythonDatabase & SQL SQLComplex QueriesStored ProceduresViewsJoinsFunctionsData ValidationAzure Azure Data Factory (ADF)Pipeline ValidationETL Pipeline MonitoringAPI Testing REST APIsPostmanJSON ValidationCI/CD & Version Control Azure DevOpsJenkinsGitGitHubMethodologies AgileScrumSDLCSTLCContinuous TestingPreferred Skills Experience with Snowflake, Azure Synapse, Databricks, or SQL ServerKnowledge of Power BI or Tableau report validationExposure to Azure Data Lake Storage (ADLS)Experience with cloud data platformsPerformance and API automation testingBasic understanding of Python-based ETL frameworksExperience Required 48+ 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 TesterMicrosoft Certified: Azure Data Engineer AssociateMicrosoft Certified: Azure FundamentalsAzure Data Factory Certification (Preferred)Soft Skills Strong analytical and problem-solving skillsExcellent communication and collaboration abilitiesHigh attention to detailAbility to work independently and within cross-functional teamsStrong debugging and troubleshooting capabilitiesTime management and organizational skillsNice-to-Have Skills Azure Synapse AnalyticsSnowflakeDatabricksData Lake technologiesPerformance TestingAI-assisted Test AutomationDevOps and Continuous DeliveryTools & 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 .