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 whats 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 ETLExperience 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 testingMust 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 processesData validation experience between on-prem & cloud (i.e. hybrid) architecture.Familiarity with cloud computing and the data ecosystem on Snowflake. 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 whats 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 ETLExperience 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 testingMust 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 processesData validation experience between on-prem & cloud (i.e. hybrid) architecture.Familiarity with cloud computing and the data ecosystem on Snowflake.