SUMMARY

• 5 years of IT experience in the areas of Informatica Master Data Management, IDQ, IDD, Oracle,Cloudtechnologies, 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 creatingIDDapplication as per the business needs and Bulk Import integration by creating the subject area and subject area groups
• Experience inImplementingHierarchy ManagerModule in addition to Match/Merge/Unmerge which aids in depicting various hierarchies
• Worked with SIF API to interact with real time applications
• Experience in designingmappings 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

Confidential, Austin, TX

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.

Confidential, Santa Clara, CA

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.
• CreatedIDDapplication as per the business needs and Bulk Import integration by creating the subject area and subject area groups
• ImplementedHierarchy ManagerModule 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

Confidential, Houston, TX

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

Confidential, Dallas, TX

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.