MDM Tester - Life science

PRI INDIA IT SERVICES PRIVATE LIMITED; Bengaluru; Hybrid; INR 1,200,000 - 1,600,000; Full time

Job summary

PRI INDIA IT SERVICES PRIVATE LIMITED is seeking an ETL & MDM Tester in a hybrid work setup in Bengaluru (Bangalore) / Kochi. Total 3 openings, 3–5 years of ETL testing experience, immediate notice. You will lead end-to-end data validation across ETL pipelines and Reltio MDM, with API testing and SQL data checks.

This one-year term involves collaboration with business analysts and data engineers. The role requires strong analytical skills, experience in agile environments, and familiarity with

Qualifications

• 3 to 5 years of ETL testing and data warehouse testing experience.
• Strong hands-on experience with Reltio MDM testing.
• Proficiency in SQL for complex data validation.
• Experience with ETL tools (Informatica, Talend, DataStage, SSIS or similar).
• Experience validating REST APIs (Postman, REST Assured, or similar).
• Experience in Agile/Scrum environments.
• Excellent analytical and communication skills.

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.

Skills

ETL Testing

MDM (Life Sciences Domain)

SQL

Automation Testing

Programming (Any language)

Cloud Platforms (AWS / Azure / GCP)

Tools

Jira

Azure DevOps

Postman

REST Assured

Job description

Minutes of Meeting (MOM)

Position- MDM Tester - Life science

Req ID: Yet to get

Job Title: ETL & MDM Tester

MSP: Shetty, Sujan

Hiring Manager: Lijo Cherian

Prepared on: 14th May 2026

Position Details

• Location: Bangalore / Kochi
• Contract Length: 1 Year
• Bill Rate: 1200
• Role: Individual Contributor
• No of Positions: 3

Candidate Criteria

• Experience: 3 to 5 Years
• Relevant Experience: 3+ Years
• Notice Period: Immediate / Serving Notice
• Shift: General Shift Timings

Interview Details

• Interview Mode: L1 & L2 If required, Face-to-Face Interview

Work Mode

• WFO: Depends on manager (Hybrid model will be provided)

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

• 36 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.