Description
You will validate ETL processes and data warehouse integrity through rigorous testing of data transformations, mappings, and business rules.
This role is on-site.
Responsibilities
- Execute black box, functional, and regression testing for ETL pipelines.
- Write complex SQL queries with joins, subqueries, and aggregate functions to validate data accuracy.
- Verify data mappings and business rule implementation across the warehouse.
- Manage testing workflows and defect tracking using JIRA.
Required Skills
- 7+ years of experience in ETL and Data Warehouse testing.
- Expert-level SQL proficiency for data validation.
- Strong understanding of ETL concepts and data warehousing principles (Star Schema, Snowflake Schema, Dimensions, Facts).
- Hands-on experience with Azure Data Factory, Snowflake, and ADLS.
- Proficiency with SQL Server.
- Experience with JIRA for issue tracking.