iT Gurus Software, Pune : ETL Test Automation Engineer (Hybrid)

ETL Test Automation Engineer (Hybrid)

Job Description of ETL Test Automation Engineer

About Role
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

Company : iT Gurus Software

URL : https://www.itgurussoftware.com

Job location : Pune, Maharashtra, India Pune Maharashtra India

Years of experience : 2 Yrs - 5 Yrs

Skills : ETL Tester automation manual agilesoftware snowflakes sql ETL Testing

Annual CTC : INR 300000 - 700000

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

If this job matches your profile, apply now!

Upload resume *

Questionnaire

Apply by uploading the resume and answering the following questions.

How much relevant experience do you have for the skills mentioned for this vacancy? *

What is your current CTC? *

50 characters remaining

What is your current location? *

20 characters remaining

What is your expected CTC? *

50 characters remaining

What is your notice period? *

20 characters remaining

Cancel Submit