Informatica MDM developer

Project Description:

This Project is for Financial Corporation, This is an insurance holding company. The Company's segments include Specialty, Commercial, International, Life & Group Non-Core, and Corporate & Other Non-Core. Its Specialty segment provides a range of professional, financial, and specialty property, and casualty products and services. We do Mastering the Customer Data, By extracting the customer data from different source systems and store unique data from different sources in centralized repository and then load this data into Informatica MDM and prepare single version of truth (Golden data) and Pass this data to downstream system and different source so that data can be used effectively for multiple requirement and make life easy

Key Responsibility:

Understand the business functionality of all the systems and understand the integration/MDM requirements.

Load the data from different source using Informatica Powercenter and IDQ by Performing the cleansing and data filtrations.

Validation on schema tables and understanding the data.

Involving in discussions with business people and technical Architect to build requirements for the project.

Worked under the architect’s supervision to provide MDM technical services using Informatica technology.

Worked on mapping spec to point out the data flow and relationships for the MDM schema.

Building the party hierarchy data model and defining the relationships between entities in HM.

Involved in match merging process by using exact match and fuzzy match logic types.

Creating lading tables, Staging tables and base objects. Involved in Independent Client Calls and presenting

Configuration of business rules configurations like trust settings, match and merge rules.

Creating queries, packages and working with data manager to create display packages and custom packages. Sindhuja G (Informatica MDM Professional)

E-Mail: *************@*****.*** Current Location: Minneapolis, MN, Mobile: +1-210-***-****

Resume Summary

7 years of IT experience in analysis, design and development and Integration of various Data warehousing and Client Server Business Applications in Informatica

MDM along with Informatica IDQ and Informatica Powercenter Technology/Skills Details Experience in Years

Skill-1:

MDM-Informatica Master Data Management Development and Support

Senior MDM Developer with Experience in Informatica MDM along with all the MDM components, including MDM Hub / IDD

/ Installation and configuration

7 Years

Skill-2:

ETL- Informatica IDQ /

Informatica PowerCenter

Worked on the Informatica PowerCenter- Repository

manager

,Workflow(wf) Manager,wf Designer,wf Monitor and

Data Quality Developer and Analyst tool

Skill-3:

RDBMS – Oracle,SQL Server

Worked on Oracle Pl/SQL 9i/10g/11g

and SQL server as per the Data Integration /MDM Project requirements

Tools/Product Used Details

Tools

MDM 10.4 /MDM 10.2, IDD / Provisioning / E360 / Business Entity / SQL Loader, Data Modeler- ER-Win, SQL Server, SVN, JIRA Professional Experience Summery

Project 1 Analytics and Data Model Office

Client Name CAN Financial, Minneapolis, MN, United States Role Sr. MDM Developer

Team Size 6

Domain Financial

Skills

Informatica MDM 10.4, JBOSS, Informatica PowerCenter 10.2,IDQ 10.1, Oracle 11g,

PL/SQL Developer .Linux Operating system

Duration of project Jan 2019 -Till Date

Created mappings to move the data from landing tables to staging tables. Load the base objects and used Trust and Validation rules.

Configured Informatica Data Director; design workflow customizations for Data Stewards Project 2 Enterprise Data Integration and virtualization Client Name Monsanto, St. Louis, Missouri, United States Role Development/Support/Module Lead

Team Size 6

Domain Agrochemical and Agricultural biotechnology corporation Skills

Informatica Power centre 9.6.1, Informatica MDM 9.1, Informatica Address doctor,IDD,

Oracle Exadata, WebLogic, Linux Operating System

Duration of project Jun 2018- Dec 2018

Project Description:

We worked for multinational agrochemical and agricultural biotechnology corporation. It is a leading producer of genetically engineered (GE) seed and Roundup, a glyphosate-based herbicide. Its roles in agricultural changes, biotechnology products and lobbying of government agencies and roots as a chemical company. In this project, We did maintenance and provides Application and infrastructure support of the whole environment, get all requests/Requirements from business for maintenance and support activities and support them by providing optimized solution. Key Responsibility

Responsible for all Administrative tasks in Informatica Power Center, Informatica MDM, Informatica Data

Responsible for installation, Upgrade, investigate an issue and EBF implementation.

Team mentoring, support them on burning issue, and handle high priority issues.

Manage permissions and privileges for users/groups, grant/invoke access for App Team

Code Migration from lower environment to higher environment.

Create and manage Repository folders, Create and manage relational connections.

Investigation for the failure of the Jobs for MDM and for IPC wf/session/node Logs and investigate and fix.

Every other day backups on TDV/CIS/BD metadata.

Make sure all the IPC, IDR, MDM, CIS, IDD and BD services are up and running,

Workflow Relation connection management, Password updates as per the compliance

Update MDM Country files from Informatica Address dr to Informatica MDM.

Support for the Informatica MDM applications and provide resolution for the process failure and fix the MDM issues

Attend Daily ops call and share business updates.

Informatica Module Lead and Team mentor.

Shift lead responsibilities / Informatica SPOC

Additional competency on WebLogic

Worked on Automation -implemented monitoring scripts for the following features across the environments:

Services/processes up and running

Filesystem usage (space left) /Filesystem on write mode,receive an email alert in case something fails, or a threshold is surpassed

Logs monitoring script that executes every hour and search for specific words on the logs.

Daily Backups for IPC Repository and domain.

Daily removal of old logs (avoid space problems).

Subscriber alerts : receive an email when one of the nodes goes down or service crashes.

Mass password update automation : automated labour-intensive process. A shell script performs this activity now, it is faster, safer and more elegant

Jobs Monitoring : we detect long running workflows in order to prevent performance issues

Platform reports: on minute basis we collect information from services, processes, CPU, RAM, IO and N/W This helped us to provide RCA of latency on dev and test Workflows that to not have an IS assigned Project 3 Prodcut MDM

Client Name Covidien, Minneapolis, MN, Unites States Role Sr MDM Developer

Team Size 4

Domain Health Care

Project Description:

Mastering the Customer Data, By extracting the customer data from different source systems and store unique data from different sources in centralized repository and then load this data into Informatica MDM and prepare single version of truth (Golden data) and Pass this data to downstream system and different source so that data can be used effectively for multiple requirement and make life easy. Key Responsibility:

Understand the business functionality of all the systems and understand the integration requirements.

Load the data from different source using IPC/IDQ by Performing the cleansing and data filtrations on schema tables and understanding the data.

Involving in discussions with business people and technical Architect to build requirements for the project.

Worked under the architect’s supervision to provide MDM technical services using Informatica technology.

Worked on mapping spec to point out the data flow and relationships for the MDM schema.

Building the party hierarchy data model and defining the relationships between entities in HM.

Involved in match merging process by using exact match and fuzzy match logic types.

Creating lading tables, Staging tables and base objects. Involved in Independent Client Calls and presenting Daily Status report to client.

Configuration of business rules configurations like trust settings, match and merge rules.

Creating queries, packages and working with data manager to create display packages and custom packages.

Created mappings to move the data from landing tables to staging tables. Load the base objects and used Trust and Validation rules.

Configured Informatica Data Director; design workflow customizations for Data Stewards Project Description:

Data Integration project, In which we publish ERP sales history Incremental data based on certain parameter to the Oracle Public Schema for specific regions, then subscribe the data based on the Business requirement from Oracle Public Schema based on acknowledgement received. Transfer information between different instance for the Accounts, Invoices, Install Base/Assets, Territory Management and Material Management/ Item Master objects.

Key Responsibility:

Requirement gathering by Consult with business analyst and architects to understand, anticipate, and meet Current and future business needs.

Analyze existing applications and systems and formulates logic for new systems, devises logic procedures, logical Database design, perform coding and tests/debugs programs.

Assist in the definition, development, and documentation of deliverables, and specifications defined in the IT Methodology, in collaboration with business analyst and other project team members.

Extract and Populate MDM Landing tables after basic cleansing

Worked with JDE and project team to gather requirements for Data integration and prepare Golden records.

Prepare high level design for Replication, Synchronization, Transformation, loading and Task flow

Design, develop, modify, configure, debugs and evaluates application programs for functional business areas, Programs include interfaces, conversions, and enhancements.

Trouble Shooting of data which is partially send to the Target system

Respond to ad-hoc questions and intra-departmental communications. Supports may include bug fixes, Patches, enhancements, and service request

Skills

Informatica MDM 9.7.1, JBOSS, Informatica Cloud, Oracle 11g, PL/SQL Developer, SFDC

Duration of project Jun-2015 to May-2018

Project 4 JDE Integration

Client Name weatherford, Huston Texas, Unites States Role Informatica Developer

Team Size 4

Domain Health Care

Skills

Informatica MDM 9.5, Oracle 11g, PL/SQL Developer, Informatica Power Center

9.6,Windows platform

Duration of project Feb-2014 to May-2015

Contact this candidate