SUMMARY:

• 7 years experience as Informatica MDM
• Experience on Informatica MDM 9.7, 9.5, 9.1, along wif Informatica Data Director (IDD) and Hierarchy Manager.
• Experience in designing MDM solution using MRM, HM and ETL processes for oil industry and financial domains.
• Configuring the MDM Hub to use the embedded workflow management Setting up the workflow engine.
• Mapping the ORS to the workflow management. Assign predefined workflow user roles to business managers. Assigning workflow user roles.
• Enabling Access to workflow Web Applications.
• Work wif business users to clarify requirements and business rules and functionality. Act as a leader and architect for the IDD and Hub wif excellent understanding of Informatica tools architecture and EAI architecture.
• Experience in working wif Informatica Data Director tool in set up, configuring and customizing data flow. Working noledge of customizing screens, UI, business process and use of its metadata repository.
• Good development experience in Informatica Power Center and Informatica Data Quality (IDQ) tool.
• Strong background on IDD, configurations, customizations and data flow.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts.
• Strong experience in designing the Design Documents for loading data into Data Warehouse and Data Mart tables.
• Good programming experience in Transact SQL, SQL, PL/SQL, Complex Stored Procedures, Triggers.
• Experience in working wif multiple RDBMS including Oracle 11i/9i/8i, SQL Server, and MS Access.
• Experience in configuring MDM objects like landing, staging, base objects and cleanse functions.
• Configuration of business rules configurations like trust settings, match and merge rules. Configurations of reusable cleanse functions in Mappings.
• Developing PL/SQL procedures to synchronize metadata information in MDM.

TECHNICAL SKILLS

MDM Tool: Informatica 9.7, 9.5, 9.1 wif Experience in Hierarchy Manager and Informatica Data Director (IDD).

ETL Tool: Informatica Power Center 9.6/9.1/8.6

Data Warehousing: Informatica 8.2.1,8.6.1, Data Stage

BPM Tools: Strong workflow management capabilities

Operating Systems: Windows, Linux, Unix

Databases: Oracle 11g, 10g, 9i, 8i, SQL Server 2014, 2011, DB2

Development/Productivity Tools: MS Office, PL/SQL, XML, TOAD, SQL Loader, SQL Navigator

PROFESSIONAL EXPERIENCE

Confidential

MDM Developer

Responsibilities:

• Understand the business functionality of all the systems and understand the integration requirements.
• Performing the dataprofiling on schematables using Informatica Analyst tool and understanding the data.
• Involving in discussions wif business people and technical supervisors to build requirements for the project.
• Worked under the architect’s supervision to provide MDM technical services using Informatica technology.
• Worked on mapping spec to point out the data flow and relationships for the MDM schema.
• Building the party hierarchy data model and defining the relationships between entities in HM.
• Involved in match merging process by using exact match and fuzzy match logic types.
• Creating lading tables, Staging tables and base objects. Involved in Independent Client Calls and presenting Daily Status report to client.
• Configuration of business rules configurations like trust settings, match and merge rules.
• Creating queries, packages and working wif data manager to create display packages and custom packages.
• Configuring of the workflow management engine.
• Configuration of ORS to the workflow management and assigning the predefined work flow user roles.
• Enabling Access to workflow Web Applications.
• Creating DQ rules, basic data cleansing in IDQ before loading the data into MDM landing tables.
• Creating reusable Mapplet’s for current and future business requirements to deal wif the source data while loading.
• Data profiling all source tables for good understanding of the source data to build data quality rules.
• Worked wif Informatica Data Director tool in set up, configuring and customizing data flow. Working noledge of customizing screens, UI, business process and use of its metadata repository.
• Good experience in working on SQL Server and Oracle databases, stored procedures.
• Understanding of basic data modeling concepts and data flow, Understanding of data ware - house concepts.
• Configured Informatica Data Director; design workflow customizations for Data Stewards using IDD.
• Helped ETL Developers to create mappings wif business rules to load data.
• MDM model was implemented in agile methodology.

Environment: Informatica MDM 10.0, IDD,IDQ 9.6,JBoss, SSIS, UC4, TFS, SQL Server 2014, Windows 8, SQL Server Management Studio.

Confidential, Atlanta, GA

MDM Developer

Responsibilities:

• Architect the Customer domain wif the halp of Business Stakeholders and project sponsors.
• Define the scope of the project and provide a roadmap of the MDM implementation.
• Convene the design sessions wif the Data Governance teams to understand their current
• Worked wif source systems to understand the MDM attributes they has and create a design ofextracting the data from their systems on a periodic basis.
• Worked wif the DG team to create the 240 business rules and created the mapping to theirDeveloped MDM Hub using the Data Models proposed to accommodate the Customer Mastersolution.
• Created the Hierarchy wif the different types of Entities and establishing the relationships.
• Configured the IDD application for viewing, entering, updating and managing the Customer &Created Roles and workflows to create appropriate access and privileges.
• Worked wif the ETL teams to source the data into MDM and route it out of MDM to consumingapplications.
• Designed and halped the Webservices team to provide real time access of MDM data to otherapplications.
• Worked wif the QA teams to create test cases and halp them throughout the various stages of thetesting cycles.

Environment: MDM 9.5.1, 9.7.1, Data Quality 9.5.1, Oracle 11g, PL/SQL, Flat files (delimited, fixed width), JBOSS,processes and pain points in the existing usage, resolution process and managing the violations.

Confidential, Greensboro, NC

MDM Developer

Responsibilities:

• Understand the business functionality of all the systems and understand the integration requirements.
• Extracted the data from ETL tool and different source systems imported in oracle tables and transform the data to the landing tables.
• Configuration of business rules configurations like trust settings, match and merge rules.
• Involved in match merging process by using exact match and fuzzy match logic types. Load the base objects and used Trust and Validation rules.
• Created mappings to move the data from landing tables to staging tables.
• Worked wif Informatica Data Director tool in set up, configuring and customizing data flow. Working noledge of customizing screens, UI, business process and use of its metadata repository.
• Good experience in Informatica (9.1/9.5) Power Center and Informatica Data Quality (IDQ) tool.
• Worked under the architect’s supervision to provide MDM technical services using Informatica technology.
• Designed and implemented IDD applications to support multiple domains
• Configured Informatica Data Director; design workflow customizations for Data Stewards using IDD.
• Involved in Independent Client Calls and presenting Daily Status report to client. Helped ETL Developers to create mappings wif business rules to load data.

Environment: Informatica MDM 9.0.1/9.1 IDD, Power Center 9.5, IDQ, Oracle 9i/10g, Windows NT/XP, SQL developer, PL/SQL, Unix.

Confidential

Informatica Developer

Responsibilities:

• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Management, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

Environment: Informatica Power Center 8.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, Sybase, UNIX AIX, Toad 9.0, Cognos 8.

Confidential

ETL Developer/Designer

Responsibilities:

• Worked wif Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin 4.0
• Used Repository manager to create user groups and users, and managed users by setting up their privileges.
• ProfileTuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Used sorter transformation and newly changed dynamic lookup.
• Created events and tasks in the work flows using workflow management.
• Developed Informatica mappings and also tuned them for better performancewif PL/SQL Procedures/Functions to build business rules to load data.
• Created Schema objects like Indexes, Views, and Sequences.
• Developed mappings for policy, claims dimension tables.
• Working wif database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Environment: Informatica Power Center 8.0 Work Flow Management/Monitor, Erwin 4.0, Oracle 10g/9i, SQL, PL/SQL, TOAD, SQL Loader, Sun Solaris 2.6, UNIX Shell Scripting