QA Engineer - ETL & DWH

Job Information

Department Name

Insurance

Date Opened

07/12/2026

Industry

IT Services

Job Type

Full time

Skills

Testing

Work Experience

5+ years

Required Skills

etl

quality assurance

+14

Role Type

Test Consultant

City

Siruseri, Chennai

State/Province

Tamilnadu

Country

India

Zip/Postal Code

603103

About Us

Kumaran Systems: Engineering Future-Ready Transformations Since 1992, Kumaran Systems has been helping enterprises bridge the past and the future, reimagining legacy systems and embracing AI-led possibilities. With over 34 years of delivery excellence, we specialise in re-engineering core applications, driving cloud transformation, and building automation-first, GenAI-enabled ecosystems across the Banking and Financial Services, Insurance, Telecom, and Automotive sectors. We help organisations not just upgrade their systems but reimagine what’s possible.

Why Kumaran?

We blend engineering discipline with AI innovation, helping clients modernise with confidence, automate with clarity, and scale with purpose. Our global delivery model ensures agility, responsiveness, and seamless collaboration, with clients always at the heart of every engagement. At Kumaran, we don’t just solve problems, we engineer future-ready transformations.

Job Description

Hands-on experience with:

EDW source-to-target testing (SQL scripting - manual and automation)

Data transformation/manipulation testing (SQL scripting - manual and automation)

Data quality/completeness validation (SQL scripting - manual and automation)

Working knowledge and testing experience of ETL

Experience in running the processes through the scheduler

Quality Assurance, Process Improvement and Collaboration:

Develop and execute comprehensive test plans to validate data within on-prem and cloud data warehouses.

Conduct thorough testing of ETL processes, dimensional data models, and reporting outputs.

Identify, document, and track data quality issues, working closely with data engineers to resolve them.

Requirements

Strong understanding of Data Warehouse & Data Quality fundamentals.

2 to 5 years of experience in data warehouse development/testing.

2 to 5 years of experience with relational databases and ETL testing

Must be experienced in Data Warehousing Projects with good knowledge of ETL testing.

Strong in SQL, RDBMS, ETL, and DW concepts.

Experience in validating Reports/Dashboards on tools like Tableau, MS Power BI, etc.

Desirable qualifications/pluses:

Knowledge of Insurance Data & its processes

Data validation experience between on-prem & cloud (i.e. hybrid) architecture.

Familiarity with cloud computing and the data ecosystem on Snowflake.