ETL Tester

WebSenor Ltd; Bengaluru; Hybrid; INR 1,500,000 - 2,100,000; Full time

Job summary

WebSenor Ltd. seeks an experienced ETL Tester / SDET with strong automation expertise to validate Azure-based data pipelines, ETL processes, and enterprise data platforms.

You will design and implement automated frameworks, perform end‑to‑end data validation, and collaborate across teams to ensure data quality and scalable testing across APIs, databases, and analytics solutions.

Qualifications

• 5–8 years of experience as SDET or ETL tester.

Responsibilities

• Design, develop, and maintain automated test frameworks for data platforms.
• Perform end‑to‑end ETL testing for Azure data platforms.
• Validate data pipelines and data quality across sources and targets.
• Integrate automated tests into CI/CD pipelines.
• Develop API and web/mobile automation tests.

Skills

Test Automation

SDET

ETL Testing

Data Testing

JavaScript/TypeScript

Java

Python

CI/CD

Bug root-cause analysis

Education

Bachelor's degree in CS/IT/Engineering

Tools

Playwright

Selenium WebDriver

Robot Framework

Cypress

Jenkins

GitHub Actions

Job description

Job Title: ETL Tester / Software Development Engineer in Test (SDET) Experience: 5–8 Years Employment Type: Full-Time

Role Summary

We are seeking an experienced ETL Tester / SDET with strong expertise in test automation, ETL validation, cloud data testing, and modern application testing frameworks. The ideal candidate will have hands-on experience in building automation frameworks, validating enterprise data platforms, testing Azure-based data pipelines, and ensuring end‑to‑end quality across applications, APIs, databases, and analytics solutions.

Key Responsibilities

• Design, develop, and maintain automated test frameworks and solutions for enterprise applications and data platforms.
• Build and enhance automation frameworks using:
  • Playwright
  • Selenium WebDriver
  • Robot Framework
  • BDD / TDD / ATDD methodologies
  • Data-driven testing frameworks
• Develop automated test scripts using:
  • JavaScript / TypeScript
  • Java
  • Python (Preferred)
• Perform end‑to‑end ETL testing for Azure-based data platforms.
• Validate data pipelines developed using:
  • Azure Data Factory (ADF)
  • Azure Synapse Analytics
  • Azure SQL Database
  • Azure Data Lake
  • Cloud data warehouse solutions
• Design and execute:
  • Source‑to‑target validation
  • Data reconciliation testing
  • Data migration testing
  • Transformation validation
  • Schema validation
  • Data quality testing
• Perform database testing across:
  • SQL Server
  • Azure SQL
  • MongoDB
  • NoSQL databases
• Validate:
  • Data completeness
  • Accuracy
  • Integrity
  • Consistency
  • Data lineage
  • Business rules validation
• Create automated validation frameworks for ETL pipelines and database testing.
• Integrate automated tests into CI/CD pipelines using:
  • Jenkins
  • GitHub Actions
  • Other DevOps tools
• Develop and execute API automation tests for:
  • REST services
  • SOAP services
  • Microservices architectures
• Perform web and mobile application automation testing across:
  • React applications
  • Angular applications
  • AEM applications
  • Android/iOS platforms
  • Multiple browsers
• Execute performance, scalability, and reliability testing for cloud‑based data processing solutions.
• Analyze automation failures, identify root causes, and collaborate with development teams for resolution.
• Troubleshoot post‑production issues and determine defects related to:
  • Application layers
  • Database systems
  • File systems
  • Infrastructure components
• Participate in test strategy development, test planning, and automation roadmap discussions.
• Review existing automation frameworks and enhance them for scalability and maintainability.
• Support regression testing initiatives and improve test coverage.
• Collaborate with Agile teams and contribute to continuous quality improvement.
• Mentor team members on automation best practices and testing methodologies.

Required Qualifications

Education

Bachelor’s degree in Computer Science, Information Technology, Engineering, or related field.

Experience

• 5–8 years of experience in Software Development Engineer in Test (SDET), ETL Testing, or Test Automation Engineering.
• Strong experience developing automation frameworks and test solutions.
• Experience testing enterprise applications, cloud platforms, and large‑scale data systems.
• Healthcare domain experience preferred.

Required Technical Skills

• Test Automation
  • Strong hands‑on experience with:
  • Playwright
  • Selenium WebDriver
  • Robot Framework
  • Cypress (Preferred)
  • Web automation frameworks
  • Mobile application automation
  • Experience with:
  • TDD
  • BDD
  • ATDD
  • Hybrid frameworks
  • Data-driven testing frameworks
• Programming & Scripting
  • Strong coding skills in:
  • JavaScript / TypeScript
  • Good to have:
  • Java
  • Python
  • Experience writing:
  • Automation scripts
  • Test utilities
  • Framework components
  • Data validation scripts
• ETL & Data Testing
  • Strong experience with:
  • Azure Data Factory (ADF)
  • Azure Synapse Analytics
  • Azure SQL Database
  • Data Lake
  • Data Warehouse Testing
  • Experience in:
  • ETL validation
  • Data pipeline testing
  • Data transformation testing
  • Data migration testing
  • Source-to-target reconciliation
  • Batch validation
  • File validation
  • Reporting and analytics validation
• Database Testing
  • Hands‑on experience with:
  • SQL Server
  • Azure SQL
  • MongoDB
  • NoSQL databases
  • Strong SQL skills including:
  • Complex queries
  • Stored procedures
  • Views
  • Triggers
  • Query optimization
  • Data validation queries
• API Testing
  • Experience with:
  • REST API testing
  • SOAP API testing
  • API automation frameworks
  • Microservices testing
• CI/CD & DevOps
  • Experience with:
  • Git / GitHub
  • Jenkins
  • GitHub Actions
  • Maven
  • CI/CD automation pipelines
  • Experience managing automation code using:
  • Git repositories
  • Version control best practices

Preferred Qualifications

• Experience testing healthcare data platforms and applications.
• Knowledge of healthcare datasets including:
  • Claims
  • Membership
  • Provider
  • Clinical data
• Experience with cloud‑based testing environments such as:
  • BrowserStack
  • Sauce Labs
  • LambdaTest
• Exposure to:
  • RPA tools (UiPath, Automation Anywhere)
  • Machine Learning workflows
  • AI‑enabled testing solutions
• Experience with Agile/Scrum methodologies.
• Knowledge of performance testing tools and techniques.
• Experience with data governance and compliance testing.

Key Competencies

• ETL Testing & Data Validation
• Test Automation Framework Development
• Playwright / Selenium Automation
• Azure Data Platform Testing
• SQL & Database Testing
• API Automation Testing
• CI/CD Integration
• Cloud Testing
• Data Quality Assurance
• Root Cause Analysis
• Agile Testing Practices
• Problem Solving
• Technical Leadership
• Communication & Collaboration

Role Outcomes

• Build robust automation solutions for enterprise applications and data platforms.
• Ensure quality and reliability of Azure‑based ETL pipelines and analytics platforms.
• Improve automation coverage and reduce regression testing efforts.
• Enable faster, reliable delivery through CI/CD‑driven testing practices.
• Support high‑quality healthcare and enterprise data solutions.

Work Location: Hybrid remote in Noida, Uttar Pradesh (Noida)