QA Engineer - ETL & DWH

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.