Job Description Of ETL Test Automation Engineer (ETL Tester)
Location- Pune
Interview Process- Face to face
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
ETL Tester
Website : https://www.itgurussoftware.com
Job Location : Pune
Years of Experience : 5 Yrs - 7 Yrs
Annual CTC : 300,000 - 700,000
Skills : ETL Tester, data qa engineer, agile software, PyTest/Python, software development testing, database testing, ETL/ELT data solutions, Strong CI/CD background, Git,GitHub, Tools (Jenkins, Docker, etc.)
Date : 24 Sep 2024 to 31 Oct 2024
Venue : Ground floor, IT-06 building, Qubix Business Park, Neopro SEZ, Near Cognizant Sys, Rajiv Gandhi Infotech Park - Phase-I, Hinjewadi, 400065