MDM Informatica Consultant — Pharma DW/ETL Expert

SmartRecruiters, Inc.; Princeton (NJ); On-site; USD 95,000 - 130,000; Full time

Job summary

Sonsoft, Inc. is seeking a seasoned MDM/ETL specialist in New Jersey to work on Reltio MDM, Teradata, and Informatica within a life sciences data environment. The role emphasizes strong MDM concepts, dimensional modelling, and DW/BI development.

You will design and implement ETL/ELT frameworks for complex warehouses, collaborate with global teams, and troubleshoot data integration challenges in Unix/Linux environments, demonstrating analytical rigor and a drive for continuous improvement.

Qualifications

• Bachelor’s degree or equivalent required; will consider one year of relevant work experience in lieu of every year of education
• At least 4 years of experience with MDM tools
• At least 2 years of hands on experience in Design, Development & Build activities in MDM Projects
• At least 4 years of experience in Project life cycle activities on DW/BI development and maintenance projects

Responsibilities

• Exposure working on Reltio MDM and related data integration tasks
• Strong understanding of MDM trends and concepts
• Experience designing and implementing ETL/ELT frameworks for complex warehouses/marts
• Ability to work in a team with diverse stakeholders in a global delivery environment

Skills

MDM concepts

Dimensional modelling

DW architecture

ETL/ELT development

Unix/Linux scripting

Analytical skills

Global delivery

Education

Bachelor’s degree or foreign equivalent

Tools

Informatica

Teradata

ETL/ELT frameworks

Job description

Sonsoft, Inc. is seeking a seasoned MDM/ETL specialist in New Jersey to work on Reltio MDM, Teradata, and Informatica within a life sciences data environment. The role emphasizes strong MDM concepts, dimensional modelling, and DW/BI development.

You will design and implement ETL/ELT frameworks for complex warehouses, collaborate with global teams, and troubleshoot data integration challenges in Unix/Linux environments, demonstrating analytical rigor and a drive for continuous improvement.