MDM ETL Tester - Hybrid - W2 only

Position: MDM ETL Tester

Location:

Bloomington, IL Duration:
Long Term Job Description

• MDM ETL Application Testing

• 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

• 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

• 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

Informatica MDM Administration, INFORMATICA-MDM, MDM Conceptual