ETL Testing

Location: Prakāshamnagar

Industry & Sector:  Recruitment & staffing for technology and analytics roles supporting Financial Services, Retail and Enterprise Data platforms. We are hiring on behalf of clients for an on-site data engineering QA role focused on validating ETL pipelines, data quality, and production-ready data warehouse solutions.

Primary

Job Title:

ETL QA Engineer

Location:

India — On-site

Role & Responsibilities

Execute end-to-end ETL test cycles: validate source-to-target mappings, transformations, row counts, and data reconciliation for batch and incremental loads.
Create and maintain detailed test plans, test cases, and traceability matrices from functional and technical specifications.
Author and run complex SQL/PLSQL queries to perform record-level validation, aggregate checks, and anomaly detection; capture and report metrics.
Automate repetitive validation tasks using scripts (Python/Shell) or ETL tool features and integrate checks into CI/CD pipelines where applicable.
Log, triage and manage defects in JIRA/ALM; reproduce issues, collaborate with ETL developers to resolve root causes, and validate fixes through regression testing.
Participate in requirement and design reviews to improve testability, support production cutovers, and execute post-deployment validations.

Skills & Qualifications

Must-Have

2+ years of hands-on ETL / Data Warehouse testing experience (source-to-target testing, reconciliation).
Strong SQL skills (complex joins, aggregations, window functions) and experience writing validation queries for large datasets.
Hands-on experience with at least one ETL tool—Informatica Power Center, Microsoft SSIS or Talend.
Solid understanding of Data Warehouse concepts: star/snowflake schemas, SCDs, fact and dimension tables, partitions.

Experience with test management and defect-tracking tools (JIRA, HP ALM) and basic Unix/Linux command-line proficiency.

Good analytical thinking, attention to detail, and effective verbal/written communication for on-site client collaboration.

Preferred

Experience automating data validation using Python or shell scripts and integrating checks into CI/CD workflows.
Familiarity with cloud data platforms (Snowflake, Redshift, Big Query, Azure Synapse) and ETL scheduling tools (Control-M, Autosys).
Exposure to performance testing for ETL jobs and experience working in Agile delivery teams.

Benefits & Culture Highlights

Exposure to large-scale data warehouse projects across banking, retail and enterprise clients—fast skill growth.
Collaborative, client-facing environment with structured onboarding and emphasis on practical, hands-on learning.
On-site role enabling close collaboration with cross-functional teams and direct impact on production readiness.

To apply:

Submit an updated CV highlighting ETL testing experience, sample SQL queries or automation snippets (if available), and your immediate availability. Competitive opportunities for candidates who demonstrate strong technical verification skills and attention to data quality.

Skills:

etl testing,big data,data warehouse testing