MDM ETL Tester - Bloomington, IL (Hybrid) - W2 only

• 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 and 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
• Hands-on 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 Agile Scrum methodologies
• Exposure to cloud-based data platforms like Azure Data Factory

1 Are you experienced working as an MDM tester? Do you have at least 5 to 7 years of hands-on experience

Ans Yes

2 Are you willing to work in the Central Time Zone

Ans Yes

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

Ans Yes

Skills

Mandatory Skills: Informatica MDM Administration, INFORMATICA-MDM, MDM Conceptual