Automation Test Engineer - ETL & Data Quality Validation (6-8 yrs)

Job Title : Automation Test Engineer - ETL and Data Quality Validation

Location : Pune

Experience : 6+ years

Job Summary :

We are looking for an experienced Automation Test Engineer to join our team. The ideal candidate will build and maintain automation testing frameworks for ETL and data quality validation, leveraging Scala, Spark, and SQL. The role involves working closely with Scrum/Agile teams to support the execution of automated tests in a Continuous Integration (CI) environment. The candidate will create, modify, and execute automated tests, including functional and regression tests, to ensure the successful extraction, transformation, and loading of data between systems.

Key Responsibilities :

- Develop and maintain automation testing frameworks specifically for ETL and data quality validation.

- Design and build automated testing scripts using Scala, Spark, and SQL.

- Collaborate with Scrum/Agile teams to support automated test execution in the CI environment.

- Create, modify, and execute automated test scripts and test suites, including functional and regression tests for ETL processes.

- Conduct manual and automated tests, analyzing execution results to determine the cause of test failures.

- Provide clear and prompt reporting on build/release status to stakeholders based on test run execution results.

- Develop expertise in the applications under test and maintain knowledge of automated testing tools and techniques that support ETL/Data Integration testing.

Required Experience/Skills :

- Bachelor's degree in Computer Science, Engineering, or a related field (BE/BTech preferred).

- 5+ years of IT experience, specifically in automation testing and data validation.

- Hands-on experience developing automation frameworks for ETL and Data Integration testing.

- Strong experience with SQL for data validation purposes.

- Ability to interpret specifications and translate them into automated test cases for data validation.

- Solid understanding of testing methodologies, including BDD, TDD, Agile, and DevOps.

- Experience with CI/CD tools such as GitLab, Jenkins, and TeamCity, and version control using Git.

- A passion for verification, validation, and automation of complex software applications and distributed systems.

- Strong collaboration skills and ability to work effectively in a fast-paced Agile environment.

- Excellent verbal and written communication skills.

Desired Experience/Skills :

- Experience with cloud platforms.

- Experience working in Agile environments, including familiarity with scrum teams.

- Proficiency in using Jira, Confluence, Git, and GitHub.

- Staying up-to-date with testing methodologies, technologies, and practices.

- Ability to handle dynamic and changing work environments.

- Strong organizational and time management skills.

- A proactive learner with a desire for continuous improvement and skill enhancement.