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

Posted on : 2024-11-11

Valid Through : 2024-12-31

Company : iT Gurus Software

URL : https://www.itgurussoftware.com

Full-time

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

Date & Time : 23 Dec 2024 | 03:00 pm - 06:00 pm 24 Dec 2024 | 03:00 pm - 06:00 pm 25 Dec 2024 | 03:00 pm - 06:00 pm 26 Dec 2024 | 03:00 pm - 06:00 pm 27 Dec 2024 | 03:00 pm - 06:00 pm 30 Dec 2024 | 03:00 pm - 06:00 pm 31 Dec 2024 | 03:00 pm - 06:00 pm

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