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

Nordcurrent - Junior QA Game Console Tester

Nordcurrent

Vilnius, Vilnius County, Lithuania (On-Site)
5 Months ago
Universally Speaking - Korean Games Tester

Universally Speaking

Community Of Madrid, Spain (On-Site)
1 Month ago
Monks - Quality Analyst (Visual Tester / Video Tester)

Monks

Noida, Uttar Pradesh, India (Hybrid)
7 Months ago
Universally Speaking - Traditional Chinese Games Tester

Universally Speaking

Community Of Madrid, Spain (On-Site)
1 Month ago
Virtusa - Pega Automation Tester

Virtusa

Gurugram, Haryana, India (Hybrid)
6 Months ago
Playrix - Senior QA Engineer (Mobile)

Playrix

Georgia (Remote)
6 Months ago
Playrix - Lead QA Automation Engineer (Mobile)

Playrix

Almaty, Almaty Region, Kazakhstan (Remote)
6 Months ago
Wargaming - Head of QA

Wargaming

Belgrade, Serbia (On-Site)
1 Month ago
SmileGate - CROSSFIRE Test Engineer (Contract)

SmileGate

Seongnam-si, Gyeonggi-do, South Korea (On-Site)
2 Months ago
Samsung Semiconductor - Senior Engineer, DRAM Applications

Samsung Semiconductor

San Diego, California, United States (On-Site)
4 Weeks ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Supercell - Game Tester, Project R.I.S.E

Supercell

Shanghai, Shanghai, China (On-Site)
5 Months ago
Universally Speaking - Spanish Games Tester

Universally Speaking

Community Of Madrid, Spain (On-Site)
1 Week ago
NVIDIA - Senior System Level Product Engineer

NVIDIA

Canada (Hybrid)
1 Month ago
Scientific Games  - Software Quality Assurance Tester III

Scientific Games

Oklahoma City, Oklahoma, United States (On-Site)
2 Weeks ago
Daybreak Game Company LLC - QA Analyst (Temp)

Daybreak Game Company LLC

San Diego, California, United States (On-Site)
9 Months ago
Double Eleven - QA Tester

Double Eleven

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
3 Weeks ago
Universally Speaking - Japanese Games Tester

Universally Speaking

Liverpool, England, United Kingdom (On-Site)
4 Weeks ago
Google - Senior Hardware Validation Engineer, Servers and Compute, Platforms

Google

Sunnyvale, California, United States (On-Site)
1 Week ago
Localsoft, SL. - Game Tester: Dutch

Localsoft, SL.

Andalusia, Spain (On-Site)
2 Weeks ago
ConverseNowAI - QA Engineer

ConverseNowAI

Bengaluru, Karnataka, India (On-Site)
1 Year ago

Get notifed when new similar jobs are uploaded

Jobs in Pune, Maharashtra, India

PwC - IN_Associate_ CA_Enterprise APP SAP_ Advisory _Mumbai

PwC

Mumbai, Maharashtra, India (On-Site)
3 Months ago
Google - Senior Software Engineer, Engineering Productivity, Core

Google

Bengaluru, Karnataka, India (On-Site)
1 Week ago
Virtusa - IOS Developer

Virtusa

Pune, Maharashtra, India (Hybrid)
7 Months ago
Reliance Industries  - Lead Engineer D&C

Reliance Industries

Shahdol, Madhya Pradesh, India (On-Site)
5 Months ago
Google - Program Manager

Google

Hyderabad, Telangana, India (On-Site)
1 Week ago
DNEG - FP&A Manager

DNEG

Mumbai, Maharashtra, India (Hybrid)
2 Months ago
Zeta - Information Developer

Zeta

Chennai, Tamil Nadu, India (On-Site)
6 Months ago
SparkCognition - DevOps Engineer

SparkCognition

Bengaluru, Karnataka, India (On-Site)
7 Months ago
Soul AI - Subject Matter Expert (AI Trainer)

Soul AI

Hyderabad, Telangana, India (On-Site)
7 Months ago
Google - Security Engineering Manager, Android Malware Analysis

Google

Bengaluru, Karnataka, India (On-Site)
1 Week ago

Get notifed when new similar jobs are uploaded

Quality Assurance Jobs

Google - Silicon Software Test Engineer

Google

Bengaluru, Karnataka, India (On-Site)
6 Days ago
SafeSend - QA Engineer L1

SafeSend

Bengaluru, Karnataka, India (On-Site)
5 Months ago
Lionbridge Games - Games Tester

Lionbridge Games

Mexico City, Mexico City, Mexico (On-Site)
2 Months ago
ComeOn Group - QA Engineer (Fixed Term Contract)

ComeOn Group

Silesian Voivodeship, Poland (Hybrid)
4 Weeks ago
Larian Studios - QA Engineer (Game Engine)

Larian Studios

Warsaw, Masovian Voivodeship, Poland (On-Site)
2 Months ago
Epic Games - QA Engineering Specialist

Epic Games

Cary, North Carolina, United States (On-Site)
2 Months ago
Saviynt - Senior Engineer SDET, Quality Engineering

Saviynt

El Segundo, California, United States (Hybrid)
6 Months ago
NVIDIA - Senior Software Engineer - System Customization Team

NVIDIA

Yokne'am Illit, North District, Israel (On-Site)
3 Months ago
Fluence - Sr. Power Electronics Engineer (m/f/d)

Fluence

Erlangen, Bavaria, Germany (Hybrid)
6 Months ago
Ubisoft - Lead Development Tester

Ubisoft

Berlin, Berlin, Germany (Hybrid)
1 Week ago

Get notifed when new similar jobs are uploaded