- Create Jobs for Data Cleansing and Data Quality assessment
- Responsible for end to end deliverable.
- Create Project Plan & Work on Implementation Strategy
- Need to have comprehensive understanding on ETL concepts and Cross Setting Data Transfers
- Familiarity with third-party application servers hosting On-Prem MDM,
- Data Modeling: Define Landing tables, Staging tables, Base Objects (BO), Hierarchies, and Relationship structures.
- Match & Merge: Formulate and tune deterministic and probabilistic match paths, match rules, merge settings, and survivorship strategies.
- Integrations:
Design batch and real-time integration workflows using Informatica PowerCenter/IICS, SIF (Services Integration Framework), and JMS/REST APIs.
- Data Quality (IDQ): Integrate Informatica Data Quality (IDQ) for data parsing, standardization, cleansing, and profilingCore Toolset: Informatica MDM Hub (Hub Console, Provisioning Tool, E360/C360 frameworks).
- Database & SQL: Advanced PL/SQL, Oracle, or MS SQL Server experience.
- Data Integration: Informatica PowerCenter or Cloud Data Integration (CDI), and batch job management.