Description

Validate ETL pipelines and data warehouse integrity through complex SQL queries and functional testing.

This role is on-site.

Responsibilities

• Write complex SQL queries including joins, subqueries, and aggregate functions to validate data accuracy.
• Test ETL processes, data transformations, mappings, and business rules.
• Execute black box, functional, and regression testing for data warehouse solutions.
• Verify data integrity against Star and Snowflake schema principles (Dimensions and Facts).
• Track defects and manage testing workflows using JIRA.

Required Skills

• 6+ years of experience in ETL and Data Warehouse testing.
• Expert-level SQL proficiency for data validation.
• Hands-on experience with Azure Data Factory, Snowflake, and ADLS.
• Proficiency with SQL Server.
• Strong understanding of ETL concepts and data warehousing architecture.
• Experience with JIRA for issue tracking.
• Bachelor's degree in a relevant field.

Key Skills

Education

Bachelor's degree