ETL tester

Virtusa; Bengaluru; Hybrid; INR 600,000 - 1,200,000; Full time

Job summary

Virtusa in Bengaluru, India is seeking an ETL Tester to join our data engineering and QA team. You will validate data transformations, verify source-to-target mappings, and write SQL queries to ensure data accuracy and performance across our data warehouse.

You will collaborate with data engineers, ETL developers, and business analysts to resolve data quality issues and ensure testing requirements are met using Jira for defect tracking.

Qualifications

• 2 to 5 years of hands-on ETL / Data Warehouse testing experience.
• Strong expertise in writing complex SQL queries.
• Hands-on experience with relational databases (e.g., PostgreSQL, Oracle, MySQL, SQL Server) or cloud data warehouses (e.g., Snowflake, BigQuery, Redshift).
• Familiarity with ETL processes and QA concepts.
• Experience using Jira for defect tracking.

Responsibilities

• Data Validation: Validate ETL processes from source systems into the data warehouse.
• Test Creation & Execution: Write and run complex SQL queries to verify data completeness and accuracy.
• Source-to-Target Mapping: Analyze mapping documents and ensure transformation rules are correctly implemented.
• Defect Reporting: Identify, document, track, and retest data defects using Jira.
• Collaboration: Work with data engineers, ETL developers, and business analysts to resolve data quality issues.

Skills

ETL testing

SQL queries

Data warehouse

QA concepts

Tools

Informatica

Talend

SSIS

DataStage

Job description

Job Overview

We are looking for an ETL Tester to join our data engineering and QA team. In this role, you will be responsible for validating data transformations, verifying source-to-target mappings, and writing SQL queries to ensure data accuracy, integrity, and performance across our data warehouse environment.

Key Responsibilities

• Data Validation: Validate data extraction, transformation, and loading (ETL) processes from multiple source systems into the target data warehouse.


• Test Creation & Execution: Write and execute complex SQL queries to verify data completeness, correctness, and business rule logic.


• Source-to-Target Mapping: Analyze source-to-target mapping documents and ensure transformation rules are accurately implemented.


• Defect Reporting: Identify, document, track, and retest data defects using tools like Jira.


• Collaboration: Work closely with data engineers, ETL developers, and business analysts to resolve data quality issues and clarify testing requirements.

Requirements & Skills

Must-Have:

• Experience: 2 to 5 years of hands-on experience in ETL / Data Warehouse testing.


• SQL Proficiency: Strong expertise in writing complex SQL queries (joins, aggregations, subqueries, set operations).


• Database Knowledge: Hands-on experience working with relational databases (e.g., PostgreSQL, Oracle, MySQL, SQL Server) or cloud data warehouses (e.g., Snowflake, BigQuery, Redshift).


• ETL Tools: Familiarity with ETL processes and tools (e.g., Informatica, Talend, SSIS, or DataStage).


• QA Concepts: Solid understanding of Software Testing Life Cycle (STLC), test planning, test case execution, and defect tracking (Jira).