Informatica Mdm Process Server
Resume:
Mouvya
*********@************.***
Professional Summary:
●Around 6 years of IT experience in the areas of Informatica Master Data Management, IDQ, IDD, Oracle, Cloud technologies, Build and Release and Linux & System Administration.
●Experience in Master Data Management and Informatica Product Information Management concepts, Informatica Customer 360, Information MDM methodologies and ability to apply this knowledge in building MDM Solutions.
●Experience in Configuring core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling.
●Created Design Document, Business requirement documents, worked on data steward services for implementing data and MDM governance.
●Experience working on data governance tools to manage project data sets.
●Experience in gathering and documenting project requirements with data flows and procedures from internal as well as external stakeholders.
●Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian)
●Experience in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation
●Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects
●Experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign key relationships, lookups, query groups, queries/custom queries and packages.
●Experience in creating IDD application as per the business needs and Bulk Import integration by creating the subject area and subject area groups
●Experience inImplementing Hierarchy Manager Module in addition to Match/Merge/Unmerge which aids in depicting various hierarchies
●Worked with SIF API to interact with real time applications
●Experience in designing mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
●Experience in designing and developing Informatica mappings in IDQ for data loads that include Source Qualifier, Aggregator, Unconnected Lookup, Connected Lookup, Filter, Router, Update Strategy etc.
●Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica server
●Experience in enabling Searchable columns as per the business need
●Good Exposure to development, testing, debugging, implementation, documentation and production support
●Experience in production support to resolve critical issues and mingle with teams to ensure successful resolution of the reported incident
TECHNICAL SKILLS
Informatica MDM Tools
Informatica MDM 10.1,10.2,10.3,10.4 (MDM Hub, Informatica Data Director, Message Queues). IDQ
Web/App Servers
Web Logic 10.3.6, JBoss EAP 6.4/7.1, IBM WebSphere 8.5
Databases
PostgreSQL, Oracle 11g, Oracle 12C, SQL Server and MSSQL
ETL
Informatica Power Center
IDE
Eclipse, MS Visual Studio, NetBeans, WebStorm, Visual Studio Code, Sublime Text 3, IntelliJ.
Web Technologies & Frameworks
HTML4/5, JavaScript, AJAX, jQuery, JSON, CSS2/3, MVC Frameworks like AngularJS, Bootstrap, Jquery UI, Node.JS, Rx.js
Version Control
TFS, GitHub.
Operating Systems
Windows XP/7/8/10, Mac OS, Linux, Ubuntu.
Professional Experience:
Client: Camping World, Irvine, CA March 2022 – July 2022
Role: Informatica MDM developer
Responsibilities:
●Implemented Customer and Product Centric Master Data Management on retail and non-retail data using Informatica customer 360 data model.
●Successfully completed the Hub configuration phase to deployment of the project.
●Configured ActiveVos one step approval workflows in provisioning tool for Create, Update, merge and unmerge activities.
●Implemented real-time integration with MDM HUB using real-time batch processing for business data coming from four source systems.
●Created Stored procedures to perform SOAP UI calls for ExecuteBatchDelete, ExecuteBatchUnmerge automatically in batches from database using loops.
●Worked on development of the MDM processes, involved in testing phase and deployed the code to production environment through change control.
●Defined custom landing tables, staging tables, and configured base objects.
●Defined foreign-key relationships, lookups, query groups and queries.
●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.
●Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
●Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
●Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
●Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.
Environment: Informatica MDM 10.4, Provisioning Tool, C360 data model, IDQ, IDD, SQL Server, Oracle 11g, JIRA, Pitney Bowes, Informatica PowerCenter, JBoss 6.4.
Client: HHSC- State of Texas, Austin, TX Aug 2020 – March 2022
Role: Informatica MDM developer
Responsibilities:
●Integrated Agency data from different sources e.g. CAR, MFX, Genius, BRM etc to create Agency Master Data to get best version of truth as golden record.
●Configured MDM hub console and created Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups
●Updated IDQ Mappings and run workflows to apply IDQ logic on data from land to stage area.
●Configured C360, created dropdowns for Indicator attributes, relationships and business entities.
●Create and Update match rules as per the business to handle over match and under match records.
●Created and inserted test data through C360 for testing certain match rules on business certified fields.
●Performed UN-Merge jobs to validate over-merged data and updated match rules to avoid future over-merging.
●Used Pitney Bowes to cleanse address data for US and Canada.
●Created SQL minus queries for data validation in all the stages of MDM workflow.
●Designed and Developed hierarchy mapping based on DNB data for alternate identification of agencies.
●Performed stage, load jobs for IDL followed by net change data and did data validation from landing to base object .
●Manually deleted purged records from source and validated the match-merge and updated IDQ mapping to automate the purge process.
Environment: Informatica MDM 10.3, Provisioning Tool, C360, IDQ, IDD, DB Vis, Oracle 11g, JIRA, Pitney Bowes, Informatica PowerCenter, JBoss 6.4.
Client: Silicon Valley Bank, Santa Clara, CA Jun 2019 – May 2020
Role: MDM Developer
Responsibilities:
●Installation and Configuration of JBOSS Application Server, Informatica MDM Hub Console, Hub Server, Cleanse Match Server (Process Server), Resource Kit, Upgrading Master and User Specific ORS
●Understand the key business requirements of client and performed Data Analysis and abstracted the transactional nature of data.
●Analyzed the source systems for erroneous, duplicative, and integrity issues related to the data, created match rules for removing duplicates.
●Worked on Informatica MDM to design, develop, test and review & optimize Informatica MDM
●Created Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation
●Creation and maintained of entity objects, hierarchies, entity types, relationship objects
●Designed and configured of landing tables, staging tables, base objects, hierarchies, foreign key relationships, lookups, query groups, queries/custom queries and packages.
●Identified Golden Record (BVT) for Client Data by analyzing the data and duplicate records (in _MTCH and _HMRG tables) coming from different source systems.
●Created IDD application as per the business needs and Bulk Import integration by creating the subject area and subject area groups
●Implemented Hierarchy Manager Module in addition to Match/Merge/Unmerge which aids in depicting various hierarchies
●Worked with SIF API to interact with real time applications
●Successfully, setup the data and configured the components needed by Hierarchy Manager for MDM HUB implementation which included implementing hierarchies, relationships types, packages and profiles by using hierarchies’ tool in model workbench.
●Successfully implemented IDD using hierarchy configuration and subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data
●Used Metadata manager for validating, promoting, importing and exporting change lists.xml from development environment to testing environment, testing environment to pre-production environment, and finally from pre-production to production environment.
●For importing the changes made to IDD application used import to existing application button and for exporting the entire application used export button
●Used data manager tool from Data steward workbench for entering data for lookup tables in hub.
●Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
●Created Unit Test Case Document, Technical Design Document, Informatica MDM Hub batch process, Informatica Hub and IDD Migration Request Document
Environment: Informatica MDM 10.2, 10.1, Provisioning Tool, IDD, Smart Search, SQL Server 2008/2016, Address Doctor, Informatica Power Center/Analyst 10.1, JBoss 6.4 EAP, Salesforce, Java 1.8_44+, SOAP UI, Eclipse, Windows Server 2008/2012
Client: Idoo global Inc, Houston, TX Jun 2018 – May 2019
Role: Informatica MDM Developer
Responsibilities:
●Worked on staging and loading process using the batch viewer for initial and adhoc loads.
●Created base objects, staging tables, landing tables and defined foreign key relationships among the base objects and Hierarchy setup for all the data.
●Defined the Foreign Key relationships and provided lookup information for the columns in the staging tables .
●Configured Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match/Merge and cascading unmerge Process.
●Created Match Paths, Match Columns for Match and Merge Process.
●Configured match rule set property by enabling search by rules in MDM according to Business Rules.
●Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
●Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
●Modified few match rules based on performance.
●Loaded the data into the landing tables using SQL scripts and used the batch viewer to run the Stage and Load process.
●Data governance application for Informatica MDM Hub that enables business users to effectively create, manage, consume and monitor master data using IDD (Informatica Data Director).
●Developed IDD applications for different business teams with different requirements
●Configured hierarchies and relationships for Assets, Customers, Entities, Financial Entities and product domains
●Created subject area groups, subject areas, subject area child, IDD display packages and search queries.
●Performed Unit Testing, worked with Quality team on System Testing.
●Created MDM query’s and packages for IDD application
Environment: Informatica MDM Multi-domain 10.2, JBoss EAP 6.4, Oracle
Client: American Airlines, Dallas, TX Jan 2017 – May 2018
Role: Jr. Informatica MDM Developer
Responsibilities:
●ETL tools preferably Informatica IICS or PowerCenter, IDQ
●Strong knowledge on data modeling including relation data model.
●Demonstrated experience working with cross functional teams.
●Excellent knowledge with Software Development Life Cycle processes and standards.
●Very good knowledge using Microsoft Office tools including MS-Word, MS-Excel and MS-PowerPoint and Microsoft Project.
●Excellent written and oral communication and presentation skills.
Contact this candidate