MDM Tester

Top Skills

• ETL Testing
• MDM (Life Sciences Domain)
• SQL
• Automation Testing
• Programming (Any language)
• Cloud Platforms (AWS / Azure / GCP)
• Position - MDM Tester - Life science
• Job Description for ETL & MDM Tester ( experience 3-6 years)

We are looking for a skilled ETL & MDM Tester with strong experience in end-to-end (E2E) testing of data integration and Reltio MDM implementations. The ideal candidate will ensure data accuracy, consistency, and quality across complex ETL pipelines and MDM platforms.

Key Responsibilities

• Perform end-to-end testing of ETL and MDM solutions, from source systems to downstream applications.
• Design and execute test scenarios, test cases, and test data for ETL, MDM, and data validation.
• Validate data ingestion, transformation, matching, merging, survivorship, and publishing in Reltio MDM.
• Test batch and incremental ETL loads , ensuring data completeness and integrity.
• Perform data quality checks including duplicates, hierarchy validation, reference data validation, and business rule verification.
• Validate MDM object models , relationships, crosswalks, and survivorship rules.
• Execute API testing for Reltio inbound/outbound integrations.
• Perform SQL-based data validation across source, staging, and target systems.
• Identify, log, track, and retest defects using defect management tools.
• Collaborate with business analysts, data engineers, developers, and product owners to clarify requirements and resolve issues.
• Support UAT and regression testing cycles.
• Ensure testing aligns with data governance, security, and compliance standards.

Required Skills & Qualifications

• 3–6 years of experience in ETL Testing and Data Warehouse testing .
• Strong hands-on experience with Reltio MDM testing.
• Solid understanding of MDM concepts : golden record, matching & merging, survivorship, hierarchies, and reference data.
• Proficiency in SQL for complex data validation.
• Experience testing ETL tools (e.g., Informatica, Talend, DataStage, SSIS, or similar).
• Experience validating REST APIs (Postman, REST Assured, or similar).
• Strong understanding of data mapping and transformation logic .
• Experience in Agile/Scrum environments.
• Excellent analytical and communication skills.

Good to Have

• Experience with cloud platforms (AWS, Azure, or GCP).
• Experience working in Data Migration project.
• Exposure to CI/CD pipelines and test automation for data testing.
• Basic knowledge of Python or scripting for data validation.
• Domain Expertise
• Mandatory experience in the Life Sciences / Pharmaceutical domain.
• Good understanding of healthcare/customer master data processes.
• Strong knowledge of MDM entity types such as: Customer, Organization, Product, Payer & Related healthcare and commercial entities
• Understanding of healthcare data hierarchies, affiliations, and relationship management concepts.
• Good knowledge of GxP compliance concepts and regulated environment processes within the Life Sciences industry.
• Exposure to data governance and data quality practices in regulated pharmaceutical environments is preferred.
• Knowledge in SQL to run the query and do the data analysis without any dependency.
• Soft Skills
• Excellent verbal and written communication skills.
• Strong stakeholder management and coordination abilities.
• Ability to communicate effectively with both business and technical teams.
• Good presentation and facilitation skills.
• Strong analytical and problem-solving mindset.
• Ability to manage multiple priorities in a fast-paced environment.
• Tools or Agile & Collaboration
• Hands-on experience with: Jira & Azure DevOps
• Experience working in Agile/Scrum environments.