ETL Testing

About the Opportunity
A fast-growing IT services and digital transformation consultancy based in India, we enable enterprises to modernize their data ecosystems through rigorous testing, quality assurance, and data governance frameworks. Our clients span BFSI, telecom, healthcare, and e-commerce—relying on us to validate the accuracy, performance, and reliability of their ETL pipelines before deployment.

Role & Responsibilities

• Design and execute end-to-end test cases for ETL workflows—data extraction, transformation logic, and target loading into data warehouses or data marts.


• Validate data integrity, mapping accuracy, and business rule compliance across source-to-target systems (Oracle, SQL Server, Snowflake, Redshift).


• Perform backend validation using SQL queries to compare source and target data counts, aggregates, and transformations.


• Identify data anomalies, duplicates, truncations, or referential integrity issues and log bugs with clear repro steps.


• Collaborate with ETL developers, BI analysts, and data engineers to troubleshoot defects and improve pipeline robustness.


• Document test results, maintain traceability matrices, and ensure test coverage aligns with business requirements.

Skills & Qualifications

• Must-Have


• SQL


• ETL Testing


• Data Warehousing


• Test Case Design


• Backend Validation


• Defect Logging


• Source-to-Target Mapping


• Test Documentation


• Preferred


• Informatica


• SSIS


• QTP/UFT

Benefits & Culture Highlights

• On-site collaborative environment with cross-functional data teams.


• Opportunity to work with Fortune 500 clients across multiple verticals.


• Continuous upskilling via hands-on exposure to modern data platforms.