Etl Test Engineer

People Prime Worldwide; Bengaluru, Chennai District; On-site; INR 1,400,000 - 2,200,000; Full time

Job summary

People Prime Worldwide is seeking an experienced ETL Test Engineer (Data QA Automation) in Bengaluru. The role focuses on ETL/Data Testing, Informatica, API automation, and CI/CD integration.

You will validate data pipelines, automate API tests, and ensure data integrity across systems. The candidate should have 6+ years of hands-on ETL testing experience, strong SQL skills, and proficiency with Jenkins-based CI/CD pipelines.

Qualifications

• ETL Testing, validation of data pipelines and ETL workflows.
• Informatica ETL workflows and data integration testing.
• SQL queries for backend data validation.
• Data validation and quality checks across source/target.
• REST API testing using Rest Assured or Karate.
• Automation scripts in Java/JavaScript for test execution.
• Develop and maintain CI/CD pipelines with Jenkins.
• End-to-end data quality, completeness, and integrity checks.
• Collaborate with data engineers, developers, and analysts.

Responsibilities

• Perform end-to-end ETL testing and data validation.
• Validate source-to-target data mapping and transformation logic.
• Develop and execute ETL test cases and test scenarios.
• Perform database validation using SQL queries.
• Automate REST API testing using Rest Assured or Karate.
• Develop automation scripts using Java or JavaScript.
• Build and maintain CI/CD pipelines using Jenkins.
• Validate data quality, completeness, and integrity.
• Work closely with Data Engineers, Developers, and Business Analysts.
• Perform regression, integration, and system testing.

Skills

ETL Testing

Informatica

SQL

Data Validation

Rest Assured

Karate

Java

API Testing

Jenkins

CI/CD Pipelines

Tools

Selenium

Git

Maven

TestNG

JUnit

Azure DevOps

Job description

Job Title: ETL Test Engineer (Data QA Automation)

6+ Years

Employment Type

Permanent | Full-Time

Job Description

We are looking for an experienced ETL Test Engineer with strong expertise in ETL/Data Testing, Informatica, API Automation, and CI/CD. The ideal candidate should have hands‑on experience in validating data pipelines, testing ETL workflows, automating API testing, and integrating test automation into CI/CD pipelines.

Key Responsibilities

• Perform end-to-end ETL testing and data validation.
• Validate source-to-target data mapping and transformation logic.
• Develop and execute ETL test cases and test scenarios.
• Perform database validation using SQL queries.
• Automate REST API testing using Rest Assured or Karate.
• Develop automation scripts using Java or JavaScript.
• Build and maintain CI/CD pipelines using Jenkins.
• Validate data quality, completeness, and integrity.
• Work closely with Data Engineers, Developers, and Business Analysts.
• Perform regression, integration, and system testing.
• Prepare test reports and defect documentation.

Mandatory Skills

• ETL Testing
• Informatica
• SQL
• Data Validation
• Rest Assured / Karate
• Java or JavaScript
• API Testing
• Jenkins
• CI/CD Pipelines

Good to Have

• Selenium
• Git/GitHub
• Maven
• TestNG/JUnit
• Data Warehouse Testing
• Azure DevOps
• Agile Methodology

Preferred Candidate Profile

• 6+ years of experience in ETL/Data Testing.
• Strong knowledge of Informatica ETL workflows.
• Experience with API automation using Rest Assured or Karate.
• Good SQL skills for backend data validation.
• Experience creating and maintaining Jenkins CI/CD pipelines.
• Excellent analytical, debugging, and communication skills.