Description

Own testing strategies and execution for MDM ETL applications, ensuring data integrity across pipelines, marts, and warehouses.

This role is on-site.

Responsibilities

• Define and implement test data strategies for MDM ETL applications.
• Lead testing of ETL pipelines for data marts and data warehouses, identifying validation scenarios.
• Design, develop, and optimize tests to validate ETL workflows and data migration transformations.
• Write and review complex SQL queries to validate data governance, quality rules, and golden record creation.
• Automate test data generation and provisioning processes.

Required Skills

• Strong experience in MDM and ETL Application Testing (5+ years).
• Advanced SQL skills for complex queries and stored procedures.
• Proficiency in Python for automation and data processing.
• Hands-on experience with Informatica MDM Administration.
• Strong understanding of data modelling, relational databases, and data warehousing concepts.
• Experience in data quality checks and troubleshooting data issues.
• Familiarity with Azure Data Factory.

Preferred Skills

• Exposure to cloud-based data platforms like Azure Data Factory.
• Familiarity with Agile Scrum methodologies.

Key Skills

Education

Bachelor's degree