MDM, Informatica Consutant n

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 a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

Job Description:-

• Exposure working on Reltio MDM.
• Life sciences industry experience, specifically in pharma is highly recommended.
• Good understanding of MDM trends and MDM Concepts.
• Strong Knowledge of Dimensional Modelling, DW architecture, ETL Frameworks, Design and Development using Informatica, Best Practices and Troubleshooting.
• Understanding of Unix/Linux system, file systems, shell scripting .
• Experience in Teradata.
• Experience with design and implementation of ETL/ELT framework for complex warehouses/marts.
• Strong analytical skills, experience gathering business requirements, analyzing, defining and documenting business processes and data flows.
• Hands-on development mentality, with a willingness to troubleshoot and solve complex problems.
• Ability to work in team in diverse/ multiple stakeholder environment.
• Strong analytical skills.
• Experience and desire to work in a Global delivery environment.

Qualifications

Basic Qualifications :-

• Bachelor’s degree or foreign equivalent required. Will also 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

Additional Information

Note:-
This is a Full-Time & Permanent job opportunity for you.
Only US Citizen , Green Card Holder , GC-EAD , H4-EAD & L2-EAD can apply.
No OPT-EAD, H1B & TN candidates please.
Please mention your Visa Status in your email or resume .