Senior Informatica Cloud MDM Consultant

Job Title: Senior Informatica Cloud MDM Consultant

Location: Bengaluru Onsite

Experience: 6+ years in Informatica MDM

Start Date: ASAP

Contract Duration: 6 Months extendable

Notice: Immediate to 30 days

Hands-on Experience with the below:

Set up user roles, permissions, and access controls

Replicate the existing data model, including entities, attributes, and relationships.

Data Ingestion: Configure Oracle data sources and set up data ingestion pipelines from MDM Schema.

Data Quality Rules Determination: Implement data quality rules to cleanse and standardize data.

Match and Merge Rules Determination: Implement existing Semarchy rules for matching and merging records.

Survivorship rules Determination

Enhance Customer hierarchy to include address grouping and additional fuzzy logic (Last Name)

Create Customer-Account hierarchy and relationships

Create Customer-Entity hierarchy and relationships

Create proper Entity-Entity hierarchy and relationships

Create Product hierarchy(ies)

Practice environment migration (getting data from one env to other environment e.g (prod to QA) and document the steps.

Data Migration Strategy planning and execution (Match Clusters, Golden Records, Relationships, Household, Reference Data and History) to the new MDM system.

API and Data Services: Set up APIs and data services for data access and sharing.

Integration with MDM Outbound Systems: Replicate existing outbound integration with multiple systems.

Functional Testing: Test the functionality of the MDM system, including data quality and match/merge rules.

Performance Testing: Evaluate system performance and scalability.

MDM Upstream and Downstream integration, analysis etc

Deployment and go-live support

Mandatory skills:

Hands on exposure to MDM (Informatica) on the Cloud

Strong knowledge on SQL

Strong Communication skills

Good to have Skills:

Good to have experience working with ETL (IICS) & Informatica Data Quality

Good to have experience implementing MDM solutions for Banks

Good to have exposure to Semarchy MDM