We provide IT Staff Augmentation Services!

Informatica Mdm Lead Resume

Boston, MA


  • Motivated and result oriented professional with a 18 - years of experience in IT with focus on Master Data Management and exposure to various MDM products from Informatica, Confidential, SAP, Microsoft (MDS), Tibco, Stibo.
  • Extensive end to end exposure in product development and customer facing IT projects.
  • Expertise in Master Data Management (MDM) - experience with major MDM products such as Informatica MDM, Stibo MDM, i2-MDM/ABPP, TIBCO- MDM, Microsoft-MDS, SAP-MDM
  • SME in Informatica Master Data Manager - Data Director (IDD), customization of workflow/approval process, author user exits using Java, SIF API, REST
  • Strong Experience in Technical Analysis, Architecture, Data Quality Analysis, Data Discovery, Business Process Analysis, Impact Analysis, Master Data Design, Data Governance Design, Creation of Reference Materials, Creation of Business Glossary, Data Quality Rules Implementation
  • Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in JBoss, Websphere
  • Experience in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match & Merge rules, Batch Group creation,Address Doctor
  • Experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages, data loading process
  • Experience in implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation
  • Experience in database related activities like PL/SQL Stored Procedures, Functions and Triggers
  • Good knowledge of PIM for CPG/Retail, CDI and Global Data Synchronization
  • Good knowledge of J2EE, EJB, SOA and Web services
  • Trained in SAP-HANA
  • Complete SDLC experience including functional, requirements gathering, design, development, testing, maintenance and support.
  • Experience in development using Core Java, JFC/Swing, Jython, Python, XML.


MDM Applications: i2-ABPP, Teradata- eMDM,, SAP-MDM, Informatica MDM, Oracle Customer/Product Hub

Programming: J2EE, Struts, EJB, Hadoop,Hive,SOA, Web Services (SOAP, WSDL), XML, XSL

Scripting: Java Script/Jscript, Python, Jython, VBScript, Perl

Web/App Servers: Weblogic, Websphere, Tomcat

GUI: Java Swing, HTML

IDE: JBuilder, Eclipse, Microsoft Visual Studio

OS: Windows XP/2k, Unix (HP, Solaris), AIX

Databases: Oracle, SQLServer, DB2, MySQL

Version Control: Clearcase, CVS, MKSSI

Project Management: Microsoft Office, MS Project, MS Visio

Testing Tools: Silk Test, WinRunner, Rational Visual Test


Confidential, boston,ma

Informatica MDM Lead


  • Act as SME for MDM (Customer/Party Master)
  • Mentor team members on Informatica MDM
  • Conduct gap analysis, create technical design, coding adhere to tech standards
  • Update Party data model, mappings,Trust rules, match rules, cleanse functions etc using console
  • Configure for various batch processes - stage,load, match-merge etc
  • Build and modify the Informatica Data Director (IDD) interface per Business Users requirements
  • Configure Business rules and workflows for process management/Data Governance
  • Analyze and Maintain Reference data using ‘Load by RowID’ for 40 different Lookup tables from two sources
  • Code Migration & Data loading across different environments - DEV, QA & UAT
  • Followup with vendor on product related issues and help resolve
  • Using PL/SQL Identify & resolve data related issues at various stages of data integration - ETL,Landing, Staging,Loading
  • Using SIF Servives to clean data,register indexes etc and ActiveVOS (AVOS) workflow configuration
  • Development methodology: Agile (Kanban), daily standups, sprint planning and weekly Dev team meetings

Environment: Informatica-MDM v10.1, Websphere, IDQ, Oracle, Powercenter

Confidential, ohio

MDM (PIM) Developer


  • Analyze requirements for new data attribution of Products
  • Propose solution for new attributes mapping to old attributes
  • Udating Model ( Attributes, Attribute Links, Valid Object Types etc ) using Talend process to read from Excel
  • Develop Business rules and workflows for process management/Data Governance
  • Use PL/SQL for data analysis, updating attributes etc

Environment: Stibo-MDM, Talend,Excel, Javascript

Confidential, Vancouver,WA

MDM (PIM) Architect


  • Architect ETL process for Initial & incremental Load of approx 100 source tables from various sources using BIML, C# to generate SSIS packages
  • Develop Data Integraion Hub for various domains - Customer, Vendor, Product, Finance etc.
  • Create Data Dictionaries of metadata
  • Develop various other SSIS packages for Sales, Finance and other data processing for various downstream BI/Analytics and SAP applications
  • Analyse exisitng data and help develop MDM artifacts
  • Gap Analysis and help generate Data for BI & integration with Adaptive Insights, Tableau, JDA Supply Chain planning etc., Oracle Product/Customer Hub
  • Participate in requirements gathering and drive MDM data strategy using TIBCO MDM & Microsoft Data Services (MDM) for mastering Product,Vendor,Customer,Bank for BI
  • Initial data standardization and quality analysis using Talend MDM

Environment: Dell Boomi, Talend-MDM, Microsoft -MDS, TIBCO- Cloud MDM 8.3x, TIBCO-Business Works, TIBCO-EMS, SQLServer 2012, BIML,SSIS, Excel, BI

Confidential, Carlisle,PA

MDM (PIM) Architect


  • Gathered requirements from business users
  • Define workflow process
  • Help create data model according to the requirements

Environment: Tibco MDM, Tibco EMS, Tibco BW

Confidential, Irving,TX

MDM Developer


  • Gathered requirements from business users
  • Help create data model according to the requirements
  • Help create Mappings to get the data loaded into the Staging tables during the Stage Process
  • Coordinate with Leads to understand Match & Merge requirements and help incorporate
  • Create IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file
  • Analyzed the data by running the queries and provided the stats after Initial data and incremental Loads
  • Defined Roles and privileges for each environment according to the platform requirement
  • Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules
  • Involved with ETL team in getting the data loaded into the landing tables
  • Created Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation,Address Doctor
  • Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
  • Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
  • Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
  • Configured match rule set property by enabling search by rules in MDM according to Business Rules.
  • Involved in creating, monitoring, modifying, & communicating the project plan with other team members.

Environment: Informatica Multidomain MDM 9.5.0, JBoss 5.1, Oracle 11g R2, Address Doctor 5, IDD, SIF, Toad, SQL*Loader, Windows Server 2008

Confidential, Buffalo,NY

MDM Lead Consultant


  • Participate in requirements and design review meetings
  • Analyse requirements and propose solution for Initial Load and Incremental data loading process
  • Create Logical Model in CIM Studio and the Physical model in database using CIM Studio
  • Assist in implementing the Match and Merge process using BW and CIM Workflow
  • Implement the merge workflow and custom Rulebase function for merging based on precedence

Environment: TIBCO-CIM, TIBCO-BW, TIBCO-EMS, Unix, Weblogic

Confidential, Dalton,GA

MDM Lead Consultant


  • Facilitated daily scrum meetings
  • Participate in requirements and design review meetings
  • Mentor developers on development of processes and workflows
  • Implement workflow and validations based on a set of parallel/split approval processes
  • Debugging and fixing issues in solution

Environment: TIBCO-CIM, TIBCO-BW, TIBCO-EMS, Unix, Weblogic

Confidential, Milwaukee,WI

MDM Lead Consultant


  • Define and design the Data Acquisition, Transformation, and Data Cleansing approach for the MDM implementation
  • Mentor and provide direction to offshore junior engineers on development, processes, and product architecture
  • Participate in planning and design review meetings with technical leads and project managers to determine schedules, review technical problems, and assign tasks and resource
  • Create Logical Model in CIM Studio and the Physical model in database using CIM Studio
  • Application Performance testing with high volumes of data
  • Debugging and fixing issues in solution

Environment: TIBCO-CIM, TIBCO-BW, TIBCO-EMS, Unix, Weblogic

Confidential, New Jersey

MDM Lead Consultant


  • Mentor and provide direction to junior software engineers regarding MDM platform development, processes, and product architecture
  • Responsible for developing custom workflows/processes and validations in CIM.
  • Deployment of HotFixes of the product
  • Help the Support team troubleshoot customer issues
  • Supported customer go-lives

Environment: TIBCO-CIM, TIBCO-BW, TIBCO-EMS, Unix, Weblogic

Confidential, Bentonville,AR

Data Analyst & Product Integration


  • Workflow/UI development using ABPP for custom User/Role Management
  • Responsible for System Integration and analysis of high volumes of raw data (millions) from SAMS Club’s legacy systems (that existed in various formats)
  • Using Java/Python/Jython scripts to prepare raw Product Hierarchy, Time Hierarchy, Stores & miscellaneous data to database loading requirements
  • Writing code & helping in code fixes
  • Creating sample data of millions of records in DB2 to test aggregation and various other scripts for History data and other analysis, performance testing etc
  • Using DB2 Load to load high volume data
  • Writing SQL & batch scripts to load formatted data in a form required for loading into final tables
  • Installing and maintaining the Hub Servers and Satellite clients on various servers & laptops in SAMS Club environment
  • Helping in debugging issues at client site and capturing logs from time-to-time

Environment: Net, C#, Microsoft Excel (UI), Microsoft Office & Charts, Java, DB2, Python/Jython

Confidential Inc, Palo Alto,CA

Technical Support


  • Provide technical support to customers using TIBCO Collaborative Information Manager (CIM) in the Product Information Management (PIM) domain
  • Maintenance of the hosted production and development environments
  • Customers include Glaxo Smithkline, Coke, Safeway, Target, Clorox, Wachovia etc.
  • Catalogs - creation, update etc
  • Uploading of Data sources from files, Import and Export mappings, XSL/XML transformations for WWRE, UCCNet etc
  • Update of workflows, validations, Role based permissions settings
  • Debugging errors related to workflows, configuration, datapools- UCCNet,WWRE (1Sync)
  • Have helped consultants at ‘Campbell Soup’ in their upgrade effort from version 4.7 to 5.9


Senior Software Engneer


  • Pre-sales development for Master Data Management (MDM) - Design and development of ‘Proof of Concept’ workflows using i2 MDM/ABPP framework
  • Customizing PIM solution using ABPP framework, Analysis of competitive products
  • Design and development of i2’s ‘DataModeler’ product using Java/Jython framework
  • Testing of Client/Server products like ‘Explore’, ‘DataModeler’ etc. and web-based products like ‘Explore. Net’.
  • Document Reviews - Release Notes, User Guide etc

Hire Now