ETL Testing

Viraaj HR Solutions Private Limited; Chennai District; On-site; INR 600,000 - 900,000; Full time

Benefits offered by this job

Opportunities to work with Fortune 500

Continuous upskilling and hands-on use

Collaborative, cross-functional teams

Job summary

Viraaj HR Solutions Private Limited is seeking an ETL Testing Analyst to validate data quality across ETL pipelines, focusing on extraction, transformation, and loading into data warehouses. You will verify data integrity, mappings, and business rules, collaborating with data engineers and BI teams.

The role emphasizes backend validation with SQL, defect logging, and thorough test documentation to ensure robust data reliability for clients across industries.

Qualifications

• Experience in ETL testing and data validation.
• Strong SQL skills and data warehousing concepts.
• Experience validating source-to-target mappings across Oracle, SQL Server, Snowflake, Redshift.

Responsibilities

• Design and execute end-to-end test cases for ETL workflows, validating extraction, transformation, and loading processes.
• Perform backend validation using SQL queries to verify data counts, totals, and transformations.
• Log defects with clear steps and reproduce scenarios; collaborate with ETL developers and data engineers to resolve issues.
• Document test results and maintain traceability matrices to align with business requirements.

Skills

SQL

ETL Testing

Data Warehousing

Test Case Design

Backend Validation

Defect Logging

Source-to-Target Mapping

Test Documentation

Tools

Informatica

SSIS

QTP/UFT

Job description

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.

Skills: data warehousing,etl testing,defect logging,sql