Software Tester

Job Title: Senior ETL Testing Engineer

Experience: 8+ Years

Work Location: Hyderabad

Work Mode: Hybrid

Shift Timings: 3:00 PM 12:00 AM IST

Notice Period: Immediate joiners only

Job Description

We are looking for an experienced Senior ETL Testing Engineer to join our data engineering and analytics team. The ideal candidate will have strong hands-on experience in ETL testing, data warehouse validation, SQL testing, and data quality assurance across complex enterprise data environments.

Roles & Responsibilities

Perform end-to-end ETL testing including source-to-target data validation, transformation logic validation, and data reconciliation.

Validate ETL workflows, mappings, stored procedures, and incremental/full load logic across multiple data sources.

Execute Data Warehouse testing , including fact and dimension table validation, SCD Type 1 & Type 2 checks, and historical data verification.

Conduct data quality testing completeness, accuracy, consistency, duplicates, null checks, threshold checks, and referential integrity.

Write and optimize complex SQL queries for large datasets across relational and cloud databases.

Validate CDC logic, incremental loads, and batch schedules .

Perform BI report validation (Power BI / Tableau) by reconciling reports with backend data.

Review Source-to-Target (S2T) mapping documents , functional specs, and business rules.

Collaborate closely with ETL developers, data architects, and business analysts during requirement analysis and defect resolution.

Log, track, and manage defects using JIRA/ALM , and actively participate in SIT, UAT, and production validation.

Support production data validation , root cause analysis, and data issue resolution.

Required Skills

8+ years of hands-on experience in ETL Testing / Data Warehouse Testing

Strong expertise in SQL (Oracle / SQL Server / Snowflake / DB2)

Experience with ETL tools such as Informatica PowerCenter / IICS (preferred)

Solid understanding of Data Warehousing concepts (Star Schema, Snowflake Schema, Facts & Dimensions)

Knowledge of CDC, incremental loads, and batch processing

Experience in Agile/Scrum environments

Familiarity with UNIX/Linux commands and shell scripting

Exposure to BI validation (Power BI / Tableau) is a plus

Preferred Qualifications

Experience working in Banking / Financial Services / Federal or Regulatory domains

Exposure to cloud data platforms such as Snowflake or Azure/AWS

Immediate availability or notice period up to 15 days preferred

Why Join Us?

Opportunity to work on large-scale enterprise data platforms

Hybrid work model with flexible collaboration

High-visibility role with ownership across data quality and validation

Competitive compensation and growth opportunities