Overview
On Site
Hybrid
Depends on Experience
Contract - W2
Contract - 12 Month(s)
No Travel Required
Skills
Informatica
MDM
Data Governance
Metadata
ETL
SQL
AWS
Data Integration
Job Details
Job Description:
- Architect and Lead the end-to-end migration of Master Data Management (MDM) systems from on-premise platforms to Informatica SaaS MDM, including IDMC and Reference 360
- Design and implement scalable, secure, and high-performance MDM solutions using Informatica SaaS components such as Customer 360, CDI (Customer Data Integration), CDQ (Cloud Data Quality), and CAI (Cloud Application Integration)
- Map and migrate legacy data models, match/merge rules, and survivorship logic from RDBMS-based systems to SaaS-based Business Entities using Load-by-BusinessID techniques
- Lead offshore and onshore teams, ensuring alignment with business goals, technical standards, and agile delivery practices
- Collaborate with stakeholders to define governance workflows, data quality standards, and integration strategies with consuming systems like SAP BI, Hyperion, and Alteryx
- Deep expertise in Informatica MDM Suite: MDM Hub, IDQ, IICS, Reference 360, PowerCenter
- Strong understanding of data modeling, ETL pipelines, API integrations, and real-time data exchange
- Prior leadership in large-scale MDM modernization projects
- Needed detail-oriented Data Integration Led Architect to support enterprise-wide Customer Master data Management and integration initiative.
- The person will lead technical execution, along with performing source system analysis, metadata documentation, and data mapping while tracking milestones, reporting and working with various divisions. Ideal candidate will be both technically fluent and programmatically strong capable of defining data strategy and working with cross-functional teams through discovery to implementation.
- Design the MDM Models based on our critical data elements by domain depending on the tool it may have a landing/staging model as well as the final MDM model.
- Design the Integration mappings (source to target mappings) for data movement from producing systems, internal to MDM, and external to MDM to the consuming systems (analytics, SAP, third-party sources like D&B, etc). If we move forward with our data foundation strategy, this may just be publication to a mesh (master data data product).
- Design the Match/Merge rules and trust/survivorship rules.
- Design Workflow and UI changes (assist with security set ups/groups, etc) UI changes require execution of our DQ rules at time of data entry if we author directly into the MDM vs. have producing systems push data to the MDM or both.
- Design Hierarchies for the domains.
- Design any reference data models/integrations, etc.
- Design any analytics needed inside of the tool (reports on match/merge, DQ, workflow/task approvals, etc).
- Design integrations with Catalog and DQ (as needed).
- Monitor system performance and suggest optimization strategies (as needed).
- Testing.
- Support issue resolution and completion of ad-hoc requests in support of business partners.
- Define target states and build roadmaps to deliver value.
- Collaborate with stakeholders to understand their needs and gather detailed business requirements.
- 7+ years in Informatica MDM architecture, data integration or data governance
- 8-10 years of various strategic IT experience encompassing technology, organizational, and process improvements, with a proven track record of crafting impactful executive-level presentations.
- 3+ years of experience in AWS Data Technologies
- 3+ years of experience in project management working with multiple stakeholders
- Experience with MDM, metadata management, and data quality frameworks
- Strong problem-solving and analytical skills
- Expertise in querying, analyzing, reconciling, and testing complex relational and non-relational data
- Strong understanding of APIs, ETL pipelines, and data modeling
- Experience with SQL, relational database (e.g. Oracle, Sybase, SQL Server) and cloud data platforms (e.g. AWS, Snowflake)
- Bachelor's degree in computer science or related field.
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.