ETL Testing

Viraaj HR Solutions Private Limited

0 years

10 - 20 Lacs

bengaluru karnataka india

Posted:3 days ago| Platform:

Apply

Skills Required

etl testing data analytics support integration reporting finance test regression design reconciliation relational profiling sql automation report reports management agile informatica unix linux troubleshooting tracking aws redshift azure tableau power engineering collaborative metrics engagement collaboration talend jira

Work Mode

On-site

Job Type

Full Time

Job Description

Industry & Sector:

Enterprise IT Services — Data Warehousing, Business Intelligence (BI) and Analytics. We support large-scale ETL pipelines, data integration, and BI reporting for clients across finance, retail, and telecom.

Primary Title (standardized):

ETL Test Engineer

About The Opportunity

We are hiring an on-site ETL Test Engineer to join a delivery-focused QA team responsible for validating complex data pipelines, ensuring data quality, and certifying BI/analytics outputs. The role is India-based and centered on hands-on ETL testing across batch and streaming integrations, regression suites, and production verifications.Role & Responsibilities

Design, develop and execute end-to-end ETL test cases for data ingestion, transformation, reconciliation, and reporting across relational and cloud data stores.
Create test data sets, perform data profiling and validation using SQL/PL-SQL and automation scripts to verify business rules and transformation logic.
Validate data lineage and reconciliation between source systems and data warehouse targets; identify and log data discrepancies with clear root-cause analysis.
Develop and maintain automated ETL test suites and regression packs using ETL testing tools or SQL-based frameworks to accelerate release cycles.
Collaborate with ETL developers, data architects, and business analysts to review requirements, clarify acceptance criteria, and validate fixes in UAT and production support.
Report test progress, prepare test summary reports, and maintain test artifacts in test management tools; participate in agile ceremonies and release planning.

Skills & Qualifications

Must-Have

Strong SQL and PL/SQL proficiency for complex data validations and transformations.
Hands-on experience testing ETL tools such as Informatica PowerCenter, SSIS, or Talend.
Practical knowledge of Data Warehousing concepts (star/snowflake schemas, slowly changing dimensions, partitions).
Experience with UNIX/Linux for running scripts and troubleshooting ETL jobs.
Proven ability in test case design, data validation, data profiling and reconciliation techniques.
Familiarity with test management and defect tracking tools such as JIRA.

Preferred

Experience with data-focused automation tools like QuerySurge or custom SQL-driven automation frameworks.
Familiarity with cloud data platforms (AWS Redshift, Azure Synapse, Google BigQuery) and related ETL patterns.
Exposure to BI tools (Tableau, Power BI) for validating report-level data accuracy.

Benefits & Culture Highlights

Hands-on, high-impact role within a delivery-oriented data engineering practice, with clear growth into senior QA or data engineering tracks.
Collaborative, metrics-driven environment with emphasis on quality, automation, and continuous improvement.
On-site engagement enabling close cross-functional collaboration with developers and business stakeholders.

Location: India (On-site). If you are a disciplined ETL tester who thrives on solving data quality problems and speeding reliable releases, apply to join a focused QA team delivering enterprise-grade data solutions.
Skills: sql,etl testing,talend,data validation,automation,data warehousing,jira,pl/sql,ssis,etl

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Viraaj HR Solutions Private Limited

Login to

Please Verify Your Phone or Email

Confirm Action

ETL Testing