ETL Test Automation Engineer

You are a skilled Data QA Engineer II tasked with developing and maintaining an automated regression suite to safeguard data integrity, ensure quality, and streamline logical processes in alignment with business needs. Your responsibilities include actively participating in Agile ceremonies, analyzing requirements, devising testing strategies, and facilitating the Agile process across cross-functional teams. You will collaborate with various stakeholders such as product owners, project managers, data analysts, data scientists, and developers to enhance user stories, acceptance criteria, and provide feedback on business flows and strategies. Your role involves writing intricate SQL queries on extensive datasets to maintain data integrity throughout the ETL lifecycle. You will construct and sustain automated test coverage using PyTest/Python to validate business objectives and technical solutions for both new and existing functionalities within each sprint. Additionally, you will liaise with team leads from discovery to resolution, serving as the primary contact for all QA aspects of releases, delivering QA services, offering UAT guidance, and coordinating QA resources internally and externally for the squad. To excel in this position, you should hold a Bachelor's degree in Computer Science, Data Science, or Information Systems, with at least 5 years of experience in agile software development testing. You must possess a minimum of 3 years of expertise in database testing for relational databases (preferably Snowflake and MS SQL Server), ETL/ELT data solutions, and reporting and analytics tools. Proficiency in data warehouse concepts like star schemas, snowflakes, facts, and dimensional modeling is crucial. Your experience in crafting complex SQL queries, determining the required testing types, evaluating testability of requirements, and devising comprehensive test plans that align with business and technological solutions will be essential. Key skills for this role include API Testing, Manual Testing using tools like Postman/swagger, and automated testing with REST Assured/CURL. Proficiency in utilizing Git, GitHub, CI/CD processes, Jenkins, Docker, Jira, or other bug-tracking software is highly valued. The job location is in Pune, with a required experience range of 2 to 5 years and an annual CTC between 300,000 to 700,000 INR. If you are passionate about ETL testing, automation, manual testing, agile software development, snowflakes, SQL, and ETL Testing, we invite you to apply for this exciting opportunity. Join our team from 12th November 2024 to 30th April 2025 at the specified venue - Ground floor, IT-06 building, Qubix Business Park, Neopro SEZ, Near Cognizant Sys, Rajiv Gandhi Infotech Park - Phase-I, Hinjewadi, Pune 400065. For more information, visit our website at [https://www.itgurussoftware.com](https://www.itgurussoftware.com).,