ETL Test Automation Engineer (ETL Tester)

6 Months ago • 5-7 Years • Quality Assurance • ₹3,00,000 LPA - ₹7,00,000 LPA

Job Summary

Job Description

This role involves developing and maintaining an automated regression suite for ETL processes to ensure data quality and prevent loss. The candidate will participate in Agile ceremonies, collaborate with various teams, write complex SQL queries, and build automated test coverage using PyTest/Python. They will also be the key point of contact for all QA aspects of releases.
Must have:
  • Agile software development testing
  • Database testing (Snowflake, MS SQL Server)
  • ETL/ELT data solutions
  • Complex SQL queries
  • PyTest/Python
  • CI/CD background
  • Git/GitHub
  • Jira or bug-tracking software
Good to have:
  • API Testing
  • Manual Testing (Postman/Swagger)
  • REST Assured/CURL
  • Jenkins
  • Docker

Job Details

About the job

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 Dec 2024

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

Similar Jobs

Amber - Localization Quality Assurance with Finnish

Amber

Montreal, Quebec, Canada (On-Site)
11 Months ago
Aspyr - Game Quality Assurance Specialist 1

Aspyr

Austin, Texas, United States (On-Site)
18 Hours ago
Reality Games - Mid-Level Automation QA Tester

Reality Games

Kraków, Lesser Poland Voivodeship, Poland (On-Site)
2 Months ago
lowpixel studios - QA Tester (Remote)

lowpixel studios

(Remote)
4 Months ago
PlayStation Global - Sr. Technical Product Manager, Partner Experiences

PlayStation Global

Aliso Viejo, California, United States (On-Site)
2 Weeks ago
Playrix - Lead QA Automation Engineer (Mobile)

Playrix

Ukraine (Remote)
6 Months ago
Corsair - Automation Engineer

Corsair

Vietnam (On-Site)
1 Month ago
Epic Games - Lead Automation Programmer

Epic Games

Montreal, Quebec, Canada (On-Site)
1 Month ago
Thatgamecompany - Build Engineer (Associate to Mid-Level)

Thatgamecompany

United States (Remote)
1 Month ago
G5 Games - Junior WEB QA Engineer

G5 Games

Astana, Astana, Kazakhstan (Remote)
1 Month ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Xsolla - Acceptance Tester (Games)

Xsolla

(Remote)
1 Week ago
Cerence - Senior Python Developer

Cerence

Montreal, Quebec, Canada (On-Site)
20 Hours ago
Global Step - Localization QA Tester (LQA-Norwegian) – Part Time

Global Step

Portugal (On-Site)
6 Months ago
Amber - Localization Quality Assurance (Polish)

Amber

Quebec, Canada (Hybrid)
2 Months ago
Amber - Localization Quality Assurance (Spanish EU)

Amber

Quebec, Canada (Hybrid)
2 Months ago
TransPerfect - Game Tester Opportunity!

TransPerfect

India (Remote)
11 Months ago
Universally Speaking - Polish Games Tester

Universally Speaking

England, United Kingdom (On-Site)
1 Week ago
Electronic Arts - Senior QA Tester

Electronic Arts

Vancouver, British Columbia, Canada (Hybrid)
3 Weeks ago
Obsidian Entertainment - Senior Producer

Obsidian Entertainment

Irvine, California, United States (On-Site)
2 Months ago
Universally Speaking - Japanese Games Tester

Universally Speaking

England, United Kingdom (On-Site)
1 Month ago

Get notifed when new similar jobs are uploaded

Jobs in Pune, Maharashtra, India

Balbix - Senior/Staff Data Engineer

Balbix

Bengaluru, Karnataka, India (On-Site)
6 Months ago
Edifeces - Associate Software Engineer

Edifeces

India (On-Site)
2 Months ago
SingleStore - Platform Engineer, FullStack

SingleStore

Hyderabad, Telangana, India (On-Site)
1 Day ago
PwC - Associate - App Tech - GDC

PwC

Kolkata, West Bengal, India (On-Site)
7 Months ago
Alphawave Semi - Senior Engineer II - Analog Design

Alphawave Semi

Bengaluru, Karnataka, India (On-Site)
18 Hours ago
Zeta - Lead - Training

Zeta

Bengaluru, Karnataka, India (On-Site)
6 Months ago
Shaadi - UI Designer (Motion, Graphic)

Shaadi

Maharashtra, India (On-Site)
7 Months ago
FCM Travel - Team Lead, IS Security Lead- Asia

FCM Travel

Bengaluru, Karnataka, India (On-Site)
7 Months ago
Granicus - Cloud Network Security Engineer

Granicus

Bengaluru, Karnataka, India (Hybrid)
6 Months ago
PwC - IN-Director_Oil & Gas_Fuels & Resources_Advisory_Mumbai

PwC

Mumbai, Maharashtra, India (On-Site)
6 Months ago

Get notifed when new similar jobs are uploaded

Quality Assurance Jobs

ByteDance - Test Development Engineer - Global Payment - San Jose

ByteDance

San Jose, California, United States (On-Site)
5 Months ago
GoMotive - Senior SQA Engineer

GoMotive

Pakistan (Remote)
1 Month ago
Canva - Quality Engineer - Internationalization

Canva

Wuhan, Hubei, China (Remote)
4 Weeks ago
Werplay - QA Engineer

Werplay

Islamabad, Islamabad Capital Territory, Pakistan (On-Site)
4 Months ago
Aristocrat Gaming - Senior Software Engineer I

Aristocrat Gaming

Noida, Uttar Pradesh, India (Hybrid)
1 Week ago
Amber - Senior Development Tester

Amber

Bucharest, Bucharest, Romania (On-Site)
1 Month ago
Sucker Punch Productions - QA - QA Tester

Sucker Punch Productions

Bellevue, Washington, United States (On-Site)
5 Months ago
Google - System Level Test Engineer

Google

Sunnyvale, California, United States (On-Site)
2 Weeks ago
Tesla - Vibration and Structural Test Technician

Tesla

North Brabant, Netherlands (On-Site)
2 Months ago
Escape Velocity Entertainment - Certification QA Lead

Escape Velocity Entertainment

(Remote)
1 Month ago

Get notifed when new similar jobs are uploaded