Experience: 10+ Years

Location: Pan India

Employment Type: Full-time / Contract

About The Role

We are seeking an experienced Senior ETL QA / Data Warehouse Testing skilled with 10+ years of experience in validating complex data integration, ETL pipelines, and data warehouse solutions. The ideal candidate will have strong expertise in ETL testing, SQL, data validation, data reconciliation, and end-to-end testing.

The candidate will work closely with data engineers, developers, business analysts, and other stakeholders to ensure data accuracy, completeness, consistency, and compliance with business requirements.

Job Description

The role involves designing and executing comprehensive test strategies for ETL processes and data warehouse applications. The candidate will validate data across source and target systems, identify data discrepancies, perform root-cause analysis, and ensure that data transformation and business rules are implemented correctly.

Responsibilities

• Design and implement ETL testing strategies, test plans, scenarios, and test cases.




• Perform end-to-end testing of ETL pipelines and data warehouse solutions.
• Validate source-to-target data mappings and transformation rules.
• Develop complex SQL queries for data validation and reconciliation.
• Perform data completeness, accuracy, integrity, and consistency testing.
• Validate ETL workflows, jobs, mappings, and data loads.
• Execute functional, integration, regression, system, and end-to-end testing.
• Identify, document, track, and manage defects through resolution.
• Perform root-cause analysis of data discrepancies and production issues.
• Review business requirements, technical specifications, and source-to-target mapping documents.
• Collaborate with Data Engineers, Developers, Business Analysts, and Product Owners.
• Support release validation and production deployment activities.
• Mentor junior QA team members and provide technical guidance.
• Contribute to improving test auto

📌 Senior ETL QA (Bengaluru)
🏢 Vivantify Technology Solutions India
📍 Bengaluru