Job Description – ETL Tester / SDET (Data & Cloud Testing)
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.
The candidate will work closely with Data Engineers, Developers, Architects, and Product teams to design, implement, and execute automated testing strategies for cloud data platforms, web applications, microservices, and enterprise healthcare 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 QualificationsEducation
- 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 SkillsTest 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:
Good to have:
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
The successful candidate will:
- 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)
