We provide IT Staff Augmentation Services!

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, USA

Informatica 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
Confidential

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

We'd love your feedback!