QA Engineer - ETL & DWH
Summary
QA Engineer focused on ETL and Data Warehouse testing, performing source-to-target validation and data quality checks using SQL. Also involved in testing reports/dashboards like Tableau/Power BI.
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.