Overall Experience: 5-10 Years
Notice Period: 0-30 Days
Location: Hyderabad/Bangalore/Chennai
Responsibility of / Expectations from the Role
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.