Informaticamdm Hub & Sif Developer Resume
4.00/5 (Submit Your Rating)
UsA
SUMMARY
- Over 4 years of hands on experience as a MDM Hub Developer specialized in design, development, testing and maintaining MDM systems using Informatica MDM product suite (MDM hub, IDD, Hierarchy Manager tool and SIF) and Power Center 9.5/8.6.1 (Designer, Workflow Manager, Workflow Monitor and Repository Manager).
- Masters graduate in MIS with hands - on experience design, build and implementation of MDM applications
- Deep product knowledge on Informatica MDM Hub, Informatica Data Director (IDD), Business Entities, Business Entity Services, Hierarchy Management(HM), Match/Merge process, ETL, SIF, IDD Java User Exits
- Certified Java developer
- Team player with strong problem-solving skills, analytical skills and excellent communication skills
TECHNICAL SKILLS:
- Informatica Master Data Management(MDM)
- SIF APIs
- IDD
- Business Entity
- Informatica MDM Hub
- IDD
- Eclipse Indigo
- TOAD for Oracle 11g
- SQL Developer
- SQL Server Management Studio
- Visual Studio
- MS Office Tools
- Power Center
- SOAPUI
- Java
- C#
- C
- C++
- SQL
- PL/SQL
- T-SQL
- ASP.NET
- JavaScript
- HTML
- CSS
- JQuery
- REST
- SOAP
PROFESSIONAL EXPERIENCE:
Confidential, USAInformatica MDM Hub & SIF Developer
Responsibilities:
- Worked as an Informatica MDM Developer/ Consultant using Informatica MDM 10.2
- Designed data model along with the hierarchies, relationships and entities for product and customer domains
- Developed Business Entities, Business Entity Views and transformations using provisioning tool to generate a business entity schema that can be utilized by Entity 360 and Business Entity services
- Configured AVOS workflows and integrated them with MDM so that the tasks can be monitored using AVOS console
- Developed transformations, mappings, mapplets, Java transformations in Informatica Power Center to consume the SQL server data and expose the mapplet as a web service
Informatica MDM Developer
Responsibilities:
- Worked as an Informatica Master Data Management (MDM) developer for Confidential, USA (PwC) global data repository - a large scale MDM project handled by Confidential
- Actively participated in discussions, via telephone, email and in person with the onsite as well as offshore team, where requirements, design, build, testing defects and implementations were discussed
- Developing mappings using in-built cleanse functions, custom Java cleanse functions and Address Trillium functions for staging process as well as for IDD
- Developed Match paths, Match Columns, Match rule sets and Match rules (Exact and Fuzzy) for Match and Merge Process in Informatica Hub.
- Configured staging, loading, cleansing, matching, merging of MDM data to get single reference of golden data
- Created and Developed Informatica Data Director (IDD) application to allow Data Stewards to search, view and edit and delete the master records
- Analyzed the data and defined Trust scores and Trust score validation rules to get golden record BVT for Party and Customer data
- Used SIF APIs (GET, SearchMatch, PUT, CleansePut) to search, update, cleanse, insert and delete data
- Created Subject Area Group, Subject Areas, Subject Area Child and Subject Area Grandchild to organize data in IDD
- Developed IDD user exits using JAVA, Object oriented programming concepts, SQL, RDBMS concepts on Address, Relationships and Party data for MDM IDD application development
- Created very complex SQL queries on Oracle 11g/12g database to check record count and data integrity issues
- Configured data security in IDD to restrict unauthorized users from accessing and enriching IDD data
- Created search queries for each subject area in IDD to allow the Business users to search for the required data
- Configured schema, landing tables, staging tables, base objects, lookup tables, batch jobs, queries and packages
- Created Tasks in IDD and added actions to the tasks as part of the IDD workflow configuration
- Created custom Java cleanse functions and bound those cleanse functions to the columns in the IDD to cleanse the data and report validation errors
- Created PL/SQL Stored Procedures, Packages, Indexes, Views and Triggers to validate data on Informatica Hub
- Worked independently during UAT and Go-Live activities and fixed critical issues to ensure successful release
- Conducted Knowledge Transfer(KT) sessions on Informatica Data Director (IDD), Informatica MDM Hub and User Exits