MDM Lead Tester

Smart IT Frame LLC; Bloomington (IN); Hybrid; USD 100,000 - 140,000; Full time

Job summary

Smart IT Frame LLC seeks an experienced MDM Lead Tester in Bloomington, with remote options. The role focuses on leading testing efforts for MDM, ETL, and data integration across complex pipelines.

The ideal candidate will demonstrate advanced SQL, data validation, and Python-based automation, with familiarity in data modeling, warehousing, and governance practices. Agile/Scrum experience is preferred to drive iterative quality improvements.

Qualifications

• Experience in MDM and ETL testing is required.
• Strong SQL and complex query writing skills.
• Proficiency in data validation, migration, transformation and integration.
• Knowledge of data modeling, warehousing and relational databases.
• Experience with data quality, governance and golden record validation.
• Proficiency in Python for automation and data processing.
• Exposure to Azure Data Factory is a plus.
• Agile/Scrum experience preferred.

Skills

MDM testing

ETL testing

SQL

Stored procedures

Data validation

Data migration

Data transformation

Data integration

Data modeling

Data warehousing

Relational databases

Data quality

Governance

Golden record validation

Python

Automation

Azure Data Factory

Agile/Scrum

Tools

Azure Data Factory

Job description

Role: MDM Lead Tester

Location: Bloomington, IL | Remote

Job Description

• Strong MDM & ETL Testing experience
• Advanced SQL, complex queries & Stored Procedures
• Expertise in data validation, migration, transformation & integration
• Strong knowledge of Data Modeling, Data Warehousing & Relational Databases
• Experience with Data Quality, Governance & Golden Record validation
• Good knowledge of Python for automation & data processing
• Exposure to Azure Data Factory is a plus
• Agile/Scrum experience preferred