Role description

MDM ETL Applicaton Testing

Key Responsibilities

Define and implement test data strategies for MDM ETL applications

Lead testing of ETL pipelines of data marts and data warehouses

Identify data validation scenarios and ensure coverage for data migration transformation and integration

Design develop and optimize tests to validate ETL workflows

Validate data governance data quality rules and golden record creation

Write and review complex SQL queries for data validation with respect to given business rules transformation logics

Collaborate with business analysts QA and development teams to understand data requirements and ensure coverage

Automate test data generation and provisioning processes

Primary Skills

Strong experience in MDM Testing

Handson experience in ETL Testing

Advanced SQL skills for complex queries and stored procedures

Strong understanding of data modelling relational databases and data warehousing concepts

Experience in data quality checks and troubleshooting data issues

Good knowledge of Python for automation and data processing

Secondary Skills

Familiarity with AgileScrum methodologies

Exposure to cloudbased data platforms like Azure Data Factory

1 Are you experienced working as a MDM tester do you atleast more than 5to 7 years of handson experience

Ans Yes

2 Are you willing to work in Central time zone

Ans Yes

3 Have you worked in Projects with Transformation initiatives and following Agile methodology

Ans Yes