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.

📌 QA Engineer (India)
🏢 Kumaran Systems
📍 India