Job Description :
Job Title: Sr. Informatica MDM Consultant
Location: Los Angeles, CA
Duration: 12 months +
Experience Required: 8-12 yrs
Detailed Job Description
· Over 8-10yrs of experience in software development, maintenance, testing and troubleshooting on Master Data
· Management (MDM), Metadata management, ETL/DWH applications, data quality, data integration and
· Oracle database environment in various Verticals such as Pharmaceutical, Health Care Insurance, Retail, Telecom, and Banking industries.
· Involved in various stages of Software Development Life Cycles (SDLC) including requirements analysis, design, development, testing and implementation.
· (Architect) Responsible for technical architecture solution design deliverable, including detailed master data services, data model (logical & physical), SIF components, and data mapping across systems.
· Designed, Installed, Configured core Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD & Data Modelling.
· Experience in several facets of MDM implementations including Data Profiling, data migration, validation, reject processing and pre-landing processing.
· Experience in defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
· Designed & developed multiple cleansing and standardization scenarios using Address Doctor.
· Implemented Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies.
· Extensive experience in Identification of User requirements, System Design, writing Program specifications, Coding, Implementation and Testing of EIM Systems.
· Strong skills in SQL, PL/SQL packages, functions, stored procedures, triggers and materialized views to implement business logic in oracle database.
· Developed test case’s for business and user requirements to perform System/ Integration / Performance testing.
· Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.