About Role

Job Description of ETL Test Automation Engineer

Skilled Data QA Engineer II, who will be responsible for developing and maintaining an automated regression suite to prevent data loss, ensure quality, and optimize logical processes, all while ensuring seamless alignment with business requirements.

Responsibilities

• Participate in Agile ceremonies, help analyze requirements, develop testing strategies, and facilitate the Agile process within all cross-functional teams.
• Collaborate with product owners, project managers, data analysts, data scientists, and developers to refine user stories and acceptance criteria and provide feedback on missing business flows and strategies.
• Write complex SQL queries on tables with hundreds of millions of records and ensure data integrity is maintained throughout the ETL lifecycle.
• Build & maintain automated test coverage using PyTest/Python to validate business goals and technical solutions for new and existing functionality as part of the certification of each ticket, within each sprint.
• Work with team leads from discovery to resolution and be the key point of contact for all QA aspects of releases, providing QA services, UAT guidance, and coordinating QA resources internally and externally for the squad.
  
  

Requirements

• Bachelors in Computer Science or Data Science, or Information Systems
• 5+ years of experience with agile software development testing
• 3+ years of experience in database testing for relational databases( preferred Snowflake and MS SQL Server), ETL/ELT data solutions, and reporting and analytics tools
• Knowledge of data warehouse concepts, such as star schemas, snowflakes, facts, and dimensional modeling.
• Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements and creating a comprehensive test plan that supports the business and technological solutions being delivered
  
  

Skills

(API Testing, Manual Testing using tools like Postman/swagger) & automated (REST Assured/CURL).

Git,GitHub, etc.

Strong CI/CD background T

Tools (Jenkins, Docker, etc.)

Jira or other bug-tracking software

Website : https://www.itgurussoftware.com

Job Location : Pune

Years of Experience : 2 Yrs - 5 Yrs

Annual CTC : 300,000 - 700,000

Skills : ETL Tester, automation, manual, agilesoftware, snowflakes, sql, ETL Testing

Date : 12 Nov 2024 to 30 Apr 2025

Venue : Ground floor, IT-06 building, Qubix Business Park, Neopro SEZ, Near Cognizant Sys, Rajiv Gandhi Infotech Park - Phase-I, Hinjewadi, 400065