OneMain Financial Jobs

Home View All Jobs (2,091,277)

Job Information

Apex Systems, Inc MDM Data Engineer - 3024231 in Dearborn, Michigan

Job#: 3024231

Job Description:

Key Responsibilities

  • Business Entity Modeling: Design and configure Business Entities, Relationships, and Field Groups within the MDM SaaS Multidomain/C360 application.
  • Cost-Optimized Design: Design data models and integration patterns with a focus on cost-efficiency. This includes optimizing the consumption of Informatica Processing Units (IPUs) and managing Managed Record limits through efficient data filtering and archival strategies
  • AI-Powered Match & Merge: Configure and tune match models using CLAIRE (Informatica's AI engine) and declarative rules.
  • Define survivorship and trust rules to ensure a "Golden Record".
  • Conduct rigorous match-tuning cycles, analyzing false positives/negatives to ensure the migrated match logic meets or exceeds the accuracy of the legacy IBM system.
  • Ingestion & Integration: Build and manage data pipelines using Cloud Data Integration (CDI) for batch processing and Cloud Application Integration (CAI) for real-time, event-driven API integrations.
  • Hierarchy Modeling: Design and implement complex many-to-many relationships and hierarchies within the Business Entity 360 framework.
  • Data Quality: Implement Cloud Data Quality (CDQ) rules for profiling, cleansing, and standardizing master data during the ingestion process.
  • User Interface Design: Configure the MDM SaaS UI, including Page Layouts, Search configurations, and Business Entity Views tailored for Data Stewards.
  • Legacy Mapping: Analyze legacy IBM MDM data models and map them to the Informatica SaaS Business Entity structure to ensure business continuity.
  • Workflow & Governance: Set up change request processes and approval workflows within the SaaS environment.

  • API Management: Develop and consume REST APIs for data synchronization between MDM SaaS and downstream/upstream applications.

     

Required Technical Skills

  • Informatica MDM SaaS: Hands-on experience with the IDMC Multidomain MDM SaaS or Customer 360 SaaS applications.
  • IDMC Platform: Proficiency in the Informatica Intelligent Data Management Cloud (IDMC) ecosystem, specifically CDI and CAI.
  • Data Quality: Experience with Cloud Data Quality (CDQ) within the IDMC environment.
  • Modeling: Strong understanding of Business Entity (BE) modeling (as opposed to traditional relational Hub modeling).
  • Web Services: Deep knowledge of RESTful APIs, JSON, and Postman for testing MDM endpoints.
  • Performance Tuning: Optimize IICS mapping performance and troubleshoot complex integration issues to ensure high-speed data processing in a cloud environment.
  • Automation & DevOps: Implement CI/CD patterns for IICS using GitHub/Azure DevOps and utilize IICS APIs for automation where applicable.

  • SQL: Proficiency in SQL for data analysis and validation against cloud data warehouses (BigQuery)

     

Skills Required:

  • Informatica SaaS/IDMC
  • MDM
  • GCP Data Engineering

  • SQL Proficiency

     

Skills Preferred:

GCP

 

Experience Required:

Engineer 3 Exp: 7+ years Data Engineering work experience

5+ Years in MDM (Minimum 3 years in Informatica SaaS/IDMC)

 

EEO Employer

Apex Systems is an equal opportunity employer.

DirectEmployers