Junior ETL Tester

About Role.

Job Description for 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.

JOINS.

TC's writing.

Severity, Priority.

Defect life cycle.

Bug tracking tools like JIRA, Redmine etc Mobile app testing, API (Will be plus point).

Website : https://www itgurussoftware com.

Job Location : Pune.

Years of Experience : 2 Yrs 5 Yrs.

Annual CTC : 200,000 500,000.

Skills : ETL Tester, automation testing, manual testing, agile software, database testing, jira, mssql, snowflakes.

Date : 07 Oct 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.

Show more Show less