Informatica MDM SME AWS / Redshift

Overview

Hybrid
$60 - $65
Accepts corp to corp applications
Contract - W2
Contract - 12 Month(s)

Skills

Informatica MDM
Master Data Management
Amazon Redshift
Amazon S3
Amazon Web Services
Data Governance
Data Engineering
Life Sciences
GxP
Data Modeling
Data Management
Meta-data Management
IDQ

Job Details

Job Title: Informatica MDM SME AWS / Redshift
Location: Trenton, NJ (Hybrid 2 3 days onsite preferred)
Duration: 12 Months Contract (Extendable)
Industry: Pharmaceutical / Life Sciences

Job Summary:
Looking for an experienced Informatica MDM Subject Matter Expert (SME) to lead enterprise master data initiatives for a major pharmaceutical client. The role involves architecting and integrating MDM solutions with AWS data platforms such as Redshift, S3, and Glue, while ensuring GxP/FDA compliance and high data quality standards.

Key Responsibilities:

  • Design, implement, and support Informatica MDM for key Pharma domains (Product, Customer, Vendor, Clinical).

  • Define match-merge, survivorship, and data quality rules (Informatica MDM + IDQ).

  • Integrate mastered data with AWS Redshift, S3, and downstream BI/reporting platforms.

  • Collaborate with data engineering teams to build ETL/ELT pipelines (AWS Glue, Lambda).

  • Own data models, metadata, hierarchies, and governance processes.

  • Ensure compliance with Pharma regulatory standards (GxP, FDA).

  • Manage data publishing and synchronization with operational systems.

Required Skills:

  • 8+ years in Data Management / Data Engineering, incl. 4+ years in Informatica MDM.

  • Strong AWS expertise Redshift, S3, Glue, Lambda.

  • SQL, data modeling, and integration design experience.

  • Pharma / Life Sciences regulatory experience (GxP, FDA).

  • Proficient in Informatica DQ / IDQ.

  • Strong data governance and metadata management knowledge.

  • Excellent communication & stakeholder collaboration.

Preferred Skills:

  • Experience with Snowflake or Databricks.

  • Knowledge of Collibra / Alation.

  • Python or PySpark automation experience.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.