ETL Testing

Industry & Sector:

Primary Job Title:

Location:

• 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 PowerCenter, 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, BigQuery, Azure Synapse) and ETL scheduling tools (Control-M, Autosys).
• Exposure to performance testing for ETL jobs and experience working in Agile delivery teams.
  

• 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.