QA Engineer - ETL & DWH (Chennai)

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. - Solid 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. 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. - Solid 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.