QA Engineer - ETL & DWH

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.

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.