Must Haves :

Mandatory : Minimum 4 years Relevant exp in : ETL AUTOMATION TESTING (in summary and projects)

- SELENIUM JAVA

- Rest Api,(Kafka / NoSQL / OpenSearch)

Role And Responsibilities :

We are seeking a highly skilled and detail-oriented Software Development Engineer in Test (SDET) with proven experience in test automation for data integration and transformation workflows. This role blends Quality Engineering and Data Engineering, requiring strong automation capabilities alongside a solid understanding of data pipelines, messaging systems, and NoSQL/search platforms.

The ideal candidate will have strong hands-on skills in :

- ETL Testing

- Selenium with Java

- API Testing

- Kafka (or any other queuing system)

- NoSQL databases (like Cassandra, MongoDB)

- OpenSearch/Elasticsearch

The candidate must possess at least two of the Kafka / NoSQL / OpenSearch skill sets and be capable of quickly learning the third. Strong understanding of data validation, test automation frameworks, and CI/CD practices is required.

Skills : ETL, Java, Selenium, Rest Api,(Kafka / NoSQL / OpenSearch)

1. Test Automation Development :

- Design and implement automation frameworks using Java + Selenium WebDriver.

- Automate functional, regression, and integration tests for web applications.

- Develop data validation and ETL automation scripts to ensure correctness of data pipelines.

- Create and maintain reusable test utilities and libraries.

2. ETL Testing & Data Validation :

- Perform ETL process validation (Extract, Transform, Load).

- Validate data integrity, completeness, and consistency across different data sources.

- Write SQL queries to validate data at different stages of the pipeline.

- Automate ETL test cases using scripts and tools.

3. CI/CD Integration :

- Integrate test automation into CI/CD pipelines (Jenkins, GitHub Actions, GitLab, etc.).

- Ensure automated tests run in build pipelines to provide quick feedback.

- Maintain test results dashboards and defect tracking.

4. Collaboration :

- Work closely with developers, business analysts, and QA teams to understand requirements.

- Participate in code reviews and suggest improvements in automation design.

- Support DevOps/Release teams during deployments with automation validation