SUMMARY

• Informatica MDM Certified Professional with more than 7 years of IT experience in Software Development Life Cycle (SDLC) analysis, design, development, testing, maintenance and quality assurance with implementation of software applications in MDM and Data warehousing.
• Installation and Configuration of Informatica MDM Hub, Cleanse Match Server (Process Server), Upgrading Master and User Specific ORS in different MDM versions and capability to apply any Hot Fixes.
• Extensive experience on Testing MDM Components like Base Objects, Match & Merge Rules, IDD Screens, Search/Display Queries/Packages, SIF APIs, System/Applications Health Checks, Infrastructure Upgrades and Testing/Validations.
• Configured landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups.
• Worked on Mappings from landing to staging tables and imported new ORS into MDM hub console.
• Designed & developed multiple cleansing and standardization scenarios using Address Doctor.
• Implemented Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies.
• Configuring Informatica Data Director (IDD) to meet Data Governance objectives in project life cycles and configuring Subject Area Groups, Subject Areas, Cleanse Functions, Match Rules Sets in IDD.
• Configured Entity 360 view by building business entities in Provisioning Tool.
• Installed and Configured Smart Search in all the environments.
• Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Using Informatica Service Integration Framework (SIF) to develop the web service for MDM processes.
• Installed and configured Oracle 11g and Oracle SQL Developer.
• Proficient with Informatica Data Quality (IDQ) for cleanup and massaging at staging area.
• Good noledge in SQL, PL/SQL and in Teradata RDBMS development and use of Teradata utilities.
• Extensive experience in creation of ETL Mappings and Transformations using Informatica Power Center to move data from multiple sources into target area using complex transformations like Expressions, Routers, Lookups, ERP Source Qualifiers, Aggregators, Filters, Joiners.
• Configuring charts on the dashboard according to business requirements in IDD and user exits in IDD for selective validation alert pop ups.
• Implementing SIF API’s on Real-time to update, insert and delete data in the MDM Hub.
• Provided solutions for various uses cases provided by the business users to meet the requirements.

TECHNICAL SKILLS

Data Modelling: MS Visio 2000, ERWIN 4.x/3.x

Database Client Tools: Toad, Sql Plus, Sql Loader, SQL Navigator Export/Import

Operating System: Windows Server, Linux

EIM Tools: Informatica MDM Multi-domain 10.2/10.1, Informatica Data Director (IDD).

Cleanse Adapter: Address Doctor 5.X

Application Servers: Web Logic 10.3.6, JBoss EAP 6.2/6.4, IBM WebSphere 8.5

ETL: Informatica Power Center 9.6.1/ 10.2.0, Informatica Data Quality.

Databases: MySQL, Oracle 10g/11g, SQL Developer 4.0.3

PROFESSIONAL EXPERIENCE

Informatica MDM / ETL Developer

Confidential, Minneapolis, MN

Responsibilities:

• Supporting the development team and Production team in MDM related tasks.
• Worked on upgrading the Informatica MDM from 10.3 to 10.4.
• Provided on-call Support.
• Worked on Monitoring all Jobs and make sure they run smooth at all times.
• Worked with production team and helped them to solve the Productions Issues.
• Solved IDD issues for Data Stewards.
• Worked closely with Informatica global support to achieve client’s specific requirements.
• Monitor Informatica applications on a daily basis, check the performance of the tool and create profiles to users as an Administrator.
• Tested already existing match rules and performed match tuning by determining over and under matches.
• Modified few match rules based on performance.
• Working withData basetestingInvolved in Data Migration Testing and preparing documents.
• Involved in migration of large amount of data fromOLTPto OLAPby usingETLPackages.
• Configuration and creation of landing and staging tables for newly added sources.
• CreatedETLprocess usingSSISto transfer data from heterogeneous data sources.
• Implemented SIF APIs in Post Load Hub User Exits for Bulk Import where Creator column was updated by data in excel.

Environment: Informatica MDM 10.3 HF1, 10.4. IDQ 10.2.0, Oracle 11g, SQL. Mule Soft. REST Services.

Informatica MDM / IDQ Developer

Confidential, Des Moines, IA

Responsibilities:

• Working with development team in match merge rules tuning for the newly added source systems.
• Worked on IDD to enhance the user experience and added the additional functionality.
• Worked on IDQ to implement business rules in cleansing the data.
• Worked on developing the mappings in the IDQ and migrate them to MDM.
• Used API calls to reevaluate the batch data and apply trust settings after making changes in the hub.
• Implemented the business requirement for Common Landing Page, where the UI would be accessible to the End users to be used as a Common Interface.
• Designed, documented, and configured Informatica MDM Hub to load, cleanse, match, merge, and publish MDM Data.
• Participate in daily meetings to discuss about the Data Model, ETL loads with respect to Insurance domain.
• Implemented new child and grandchild to existing IDD applications and implemented SIF API’s in IDD User Exits for various business scenarios

Environment: Informatica MDM 10.3 HF1, Informatica developer 10.2 HF2, Power center 10.2.0, Oracle 11g, SQL Developer, IDD, Address Doctor, Putty, Visio, JAVA, Eclipse, SOAP UI 5.4.0\

Informatica MDM Developer

Confidential, Franklin, TN

Responsibilities:

• Proactively worked and resolved high priority MDM release specific production issues.
• Worked with enhancement and support stream working with users to prioritize issues by Severity and planning for work packages.
• Implemented Informatica RDM on top of MDM 10.2 and 10.3.
• Acted as key member in upgrade project which involves the upgrade of Dev, UAT, Prod Env from 9.7.1 to 10.3 HF1 version.
• Worked in an Agile environment with sprint standups, offshore and onshore delivery model.
• Implemented REST Services.
• Executed MDM Data Migration including planning, execution from Informatica 9.6.1 to 10.1.
• Using Kafka tool to publish the messages and which is then consumed by web-services and downstream systems.
• Prepared detailed documentation for the Existing MDM Infrastructure.
• Added new source systems by creating new landing tables, Base Objects, staging tables, mappings, Batch group, cleanse functions by analyzing requirement specifications and participated in Business meetings to capture the Business requirements for TEMPeffective implementation.
• Fixed various IDD (Portal) issues like match and merge, IDD search results etc.

Environment: Informatica Multidomain MDM 10.2 HF2, IBM DB2, Address Doctor, Active VOS, IDD, Toad, Microsoft Visio, Jboss 6.4.

Informatica MDM Developer

Confidential, Saint Paul, MN

Responsibilities:

• Designed DFD’s to understand the overall data flow.
• Developed an enterprise level architectural solution and a structure that is stable, resilient and performant.
• Involved in documenting source to target mappings.
• Proposed many currents to to-be state Architectural designs for the Informatica RDM.
• Involved in preparing technical requirement document and Functional requirement specification.
• RDM come with the basic Data Model from the Informatica when you configure it. Made changes to the Data Model according to the business requirements.
• Configured Informatica Data Director (IDD) which is used as Data governance application for Informatica MDM Hub that enables business users to TEMPeffectively create, manage, consume and monitor master data using IDD.
• Created Base objects, staging tables, landing tables and defined foreign key relationships among the base objects and Hierarchy setup for all the Well data.
• Configured ActiveVOS for workflow management.
• Used IDQ for profiling the data and used different transformations before moving the data into landing layer.
• Defined the Foreign Key relationships and provided lookup information for the columns in the staging tables.
• Configured the Hierarchies using Hierarchy Manager to identify hierarchical relationships between the Reference Data Elements.

Environment: Informatica Multidomain MDM 10.2 HF2, IBM DB2, Address Doctor, ActiveVOS, IDD, Toad, Microsoft Visio, Jboss 6.4, UC4 Scheduler. VSTS.

Informatica MDM Developer

Confidential, Boston, MA

Responsibilities:

• Successfully upgraded MDM from 9.7.1 HF5 to MDM 10.2 HF2.
• Solved high priority address issues in the production by modifying existing Address Doctor mapping.
• Created new Jasper reports using Jasper Studio for Business view. Modified existing jasper reports to consume data from different schemas for poor IDD performance.
• Analyzed and Participated in cleanup of data and developed new functions to be used in mapping.
• Added new source systems by creating new landing tables, Base Objects, staging tables, mappings, Batch group, cleanse functions by analyzing requirement specifications and participated in Business meetings to capture the Business requirements for TEMPeffective implementation.
• Fixed various IDD issues like match and merge, IDD search results etc.
• Implemented IDD Bulk Import functionality for importing data via Excel into MDM. Developed Excel VBA code for Import Template that makes less work for Business while entering data in excel.
• Implemented SIF API’s in Post Load Hub User Exits for Bulk Import where Creator column was updated by data in excel.
• Worked on various IDD User Exits and hub cleanse functions and displayed error/warning messages and performed backend related processes.
• Attended Business meetings and suggested MDM solutions for various Business scenarios.
• Created a new manual match rule and Oracle script for a Business scenario where records were added to IDD merge queue on a certain condition.
• Developed an Oracle stored procedure to get the latest golden Confidential ID for use by Business.

Environment: Informatica Multidomain MDM 10.2 HF1, Oracle 11g, SQL Developer, IDD, Toad, Erwin, Jboss 6.4, Jasper Studio.

Informatica MDM Developer

Confidential, PA

Responsibilities:

• Configuration and creation of landing and staging tables for newly added sources.
• Added new sources to the existing MDM implementation.
• Create mappings to load data in to the staging tables.
• Build the cleanse functions based on the requirements for the mappings.
• Defined the Foreign Key relationships and provided lookup information for the columns in the staging tables.
• Defined Trust and Validation rules and Configured Match Set Rules for getting the matches in order to eliminate the duplicate records.
• Migration of Siperian objects from Dev to QA and to Production environments.
• Configured Informatica MDM hub on WebLogic application server.
• 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 TEMPeffectively create, manage, consume and monitor master data using IDD. (Informatica Data Director).
• Configured the Hierarchies using Hierarchy Manager to identify hierarchical relationships.

Environment: Informatica Multidomain MDM 10.1, Informatica Power Center 9.6/, Linux, Oracle 11g, SQL Developer, Salesforce, WebLogic 10.3.

ETL Developer

Confidential, Chicago

Responsibilities:

• Responsible for design and development of Sales Data Warehouse.
• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Extracted data from heterogeneous sources like Oracle, SQL Server.
• Conducted a series of discussions with team members to convert Business rules into Informatica mappings.
• Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target-based commit interval.
• Created Mapplets and used them in different Mappings.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Monitoring the Data Quality, generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.
• Worked with SAP and Oracle sources to process the data.
• Worked on SAP for data migration Human Resources and Finance and converted various objects on Organizational Structure, Addresses, Time, Basic Pay, Bank Details, Recurring Payments, Tax assignment, Insurance Plans, Payroll etc., to generate report from SAP BI system.
• Worked with Pre-and Post-Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Implemented pipeline partitioning concepts like Round-Robin, Key-Range and Pass Through techniques in mapping transformations.
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Worked on the data masking activities for cloning the GDW for several buyers.

Environment: Informatica Power Center 9.1, Oracle11g, SQL Developer, Linux.

SQL Developer

Confidential

Responsibilities:

• Designed, created and maintained the database.
• Used tools like SQL *Loader to load the data into the database tables from flat files and excel sheets.
• Created control files for fixed length data, variable length data and for data that TEMPhas to be inserted in multiple tables within a database at a time.
• Used SQL*Plus to perform DML operations for small updates.
• Created number of database Triggers using PL/SQL.
• Created indexes for faster retrieval and improved query performance.
• Customized different modules of reports after upgrade process using MS Access.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Involved in programming, debugging, and unit and system integration testing of modules.

Environment: Oracle 9i, SQL*Plus, SQL*Loader, MS Word, MS Excel, MS SQL Server 8.0, MS Visio.