SUMMARY

• Informatica MDM Certified Professional with near to 10+ 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.
• Strong knowledge 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.
• Implementing SIF API’s on Real-time to update, insert and delete data in the MDM Hub.

TECHNICAL SKILLS

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

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), Informatica Power Center, SIF

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

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

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Senior Informatica MDM Developer

Responsibilities:

• Parsed high-level design specification to simple ETL coding and mapping standards.
• Created mapping documents to outline data flow from sources to targets.
• Worked on Business support request (BSR) raised by business users for critical/high priority issues.
• Used SSIS to design ETL process using control flows and data flows.
• Using Data flows in SSIS, extracted data from an external data sources, flow that data through several transformations such as sorting, filtering, merging it with other data and converting data types, and finally store the result at a destination, usually a table in the data warehouse.
• Involved in creation of HLD and LLD document based on BR/FR and got those reviewed by customers along with detailed project timelines.
• Involved in building the ETL architecture using Informatica 9.6.1/ 9.5.1 and Source to Target mapping to load data into Data warehouse.
• Providing periodic update to customer on the coding, unit testing release and act as Coordinator between development and business team Knowledge of TABLEAU.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Performed Proof of Concept for Informatica Data Quality (IDQ).
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Worked on loading Flat Files into Data warehouse.
• Created stored procedures, collections and packages.
• Experience on Teradata utilities like Bteq, multi load, fast load and fast export.

Environment: Informatica 9.6.1/9.5.1 , Teradata, DB2, Oracle, Flat Files, UNIX, Windows, SQL Assistant.

Confidential, Maryland Heights, MO

Informatica ETL Developer

Responsibilities:

• Extracted data transformed and loaded into Oracle database according to the specifications.
• Experience in creating Tables, Procedures, Functions, Views and other database objects on Oracle DB.
• Experience in writing Complex Queries, Subqueries, Co-related subqueries, Dynamic SQL queries.
• Developed mappings and mapplets extensively using Informatica Designer tools - Source Analyzer, Target Designer, Transformation Developer and Mapplet Designer and Mapping designer.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Union, Normalizer, Sequence Generator, Update Strategy, SQL Transformation, Stored Procedure, and Joiner.
• Created and ran workflows using Workflow Manager to load the data into the Target Database. Optimized/Tuned mappings for better performance and efficiency.
• Developed mapping parameters and variables to support SQL override.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets.
• Created reusable components in the shared folder as it reduces time and effort.
• Integrated and installed IDQ on Informatica power center server machine to cleanse data.
• Designed IDQ mappings which are used as Mapplets in Power center.
• Validate data in the reports using Business Objects and provide an update on business queries.
• Involved in each phase of Software Development Life Cycle such as design, build, test and deployment phase.
• Deployed the code to the Production that follows the migration checklist.
• Used debugger to test the data flow between the source and target and to fix the invalid mappings.
• Migrated mappings and workflows from the development server to the Test Server to perform the unit, integration and system testing.
• Involved in all the existing releases and helped the team in resolving critical issues.

Environment: Informatica Power Center 8.6.1/8.1, Oracle 10g, Windows XP.

Confidential, Franklin, TN

Informatica MDM Developer

Responsibilities:

• Proactively worked and resolved high priority MDM release specific production issues.
• Led the enhancement and support stream working with users to prioritize issues by Severity and planning for work packages
• Created Source Data Quality reports profiling data for critical attributes presenting it to Data stewardship teams
• Worked in an Agile environment with sprint standups, offshore and onshore delivery model
• Executed MDM Data Migration including planning and execution from Informatica 9.6.1 to Informatica 10.1.
• Implemented SIF API’s in Post Load Hub User Exits for Bulk Import where Creator column was updated by data in excel.
• Analyzed and Participated in cleanup of data and developed new functions to be used in mapping.
• 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 effective implementation.
• Fixed various IDD (Portal) 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 new child and grandchild to existing IDD applications and implemented SIF API’s in IDD User Exits for various business scenarios.
• 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 Vertex ID for use by Business.

Environment: Informatica Multidomain MDM 10.1 HF1, Oracle 11g, SQL Developer, IDD, Toad, Jboss 6.4.

Confidential, Saint Paul, MN

Informatica MDM Developer

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.
• Involved in preparing Technical requirement document and Functional requirement specification.
• Configured Informatica Data Director (IDD) which is used as Data governance application for Informatica MDM Hub that enables business users to effectively 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.
• Configuration and creation of landing and staging tables for newly added sources.
• 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.
• 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.

Confidential, PA

Informatica MDM Developer

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 into 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.
• Tested already existing match rules and performed match tuning by determining over and under matches.
• Modified few match rules based on performance.
• Created mapping documents, functions speciation's document and technical specification documents.
• 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 effectively 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.

Confidential, Chicago

ETL Developer

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.

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