We provide IT Staff Augmentation Services!

Sr. Informatica Mdm Consultant Resume

SUMMARY:

  • Software Professional with 8+ years of experience in the field of Information Technology with an extensive experience in Master Data Management and as an ETL Developer with prime focus on analysis, design, development, customization and maintenance of various data warehouse applications in an effective way to deliver leading edge software solutions.
  • Strong expertise in installing and configuring the core Informatica MDM components (Informatica MDM Hub Server, Hub Cleanse, Resource Kit and Cleanse Adaptors like Address Doctor)
  • Proficient in the development of solutions using Informatica MDM Hub
  • Created a single, verifiable, consolidated source of data which can be referred across the organization and subsequently to have a single point of entry for all data within the organization into this single source .
  • Analyzing the regulatory restrictions and the need for identification of golden record for Master Data.
  • Designed, configured and delivered MDM hubs across multiple data domains (Customer, Product, Vendor, etc).
  • Configuring and maintaining various components of the MDM Hub including the schema, staging and landing tables, configuring base objects, Look ups, Hierarchies, display queries, put queries and query groups.
  • Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
  • Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
  • Successfully implemented and executed database store procedures in Informatica MDM Hub for Cleaning Base Objects, Stage Jobs, Load Jobs, Generating Match Tokens, Match Jobs, External Match Jobs, Manual Merge Jobs, Multi Merge, Manual Unmerge, Auto Match and Merge, CMX Put, Hard delete job, Soft Delete Job.
  • Responsible for creating user groups, privileges and roles to the users using Security Access Manager (SAM)
  • Configured Informatica Data Director (IDD) for data governance to be used by the business users, IT Managers and Data Stewards and also implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data.
  • Efficient in all the phases of the Data warehousing life cycle including: design, development, testing and implementation of the Data Warehouses as an ETL developer using Informatica Power Center 9.x/8.x
  • Good development experience in Informatica (9.1/9.5) Power Center - ETL tool and Informatica Data Quality (IDQ) tool.
  • Creating JAVA User Exits (PostLoad, PostMerge and PostUnMerge) to customize the Hub functionality.
  • Expertise in implementing complex business rules by creating re-usable transformations and Mappings/Mapplets.
  • Worked extensively on different types of transformations like Source Qualifier, Expression, Aggregator, Router, Filter, Update Strategy, Lookup, Sorter, Normalize, Union, Stored Procedure, Sequence Generators.
  • Created, launched & scheduled workflows/sessions and extensively involved in the performance tuning of mappings and sessions.
  • Strong experience in designing and developing mappings to extract data from different sources including flat files, RDBMS tables and XML files.
  • Experienced in Data Cleansing and Data Standardization using Informatica Power center and UNIX Shell script by using Reference Data/Golden copy.
  • Extensively involved in writing Oracle, PL/SQL/Functions/Cursors/ Packages & Triggers.
  • Worked with various SQL developer tools such as TOAD, SQL Plus, and SQL Developer. Strong development skills including the ability to work through the entire development cycle from gathering requirements through implementation
  • Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

Databases: Oracle 9i/10g, 11g/12c SQL Server 2014, 2012, 2008, 2005

Languages: SQL, PL/SQL, Java, UML 2.0, Unix

ETL Tool: Informatica Power Center 10.x/9.x/8.x (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

MDM Packages: Informatica MDM Multi Domain Edition 10.0, 9.7.1, 9.5, 9.1. Informatica Data Director (IDD) 10.0, 9.7, 9.5. Informatica Data Quality(IDQ) 10.0, 9.6, DDM 9.6

RDBMS: Oracle 12c/11g/10g/ 9i (SQL/PLSQL)

Tools and Utilities: TOAD 10.1, Text pad, Word Pad, SQL Developer 4.0.3

Modeling Tools: Erwin 4.0 data modeler, ER studio 7.5, MS Visio 2007

Environment: Windows 7/XP/2000, Unix, Windows Server 2003, 2008/Linux

MS Office (MS Access, MS Excel, MS PowerPoint, MS Word), Visual Studio, Java Eclipse

PROFESSIONAL EXPERIENCE:

Sr. Informatica MDM Consultant

Confidential, CA

Responsibilities:

  • Configured and Installed Informatica MDM Hub, (Server, Cleanse, Resource Kit, ActiveVOS) in Sandbox for doing a POC in Windows/Linux environment.
  • Extracted data from sources like fixed width and Delimited Flat files transformed the data according the business requirement and then loaded into Target database.
  • Created sessions, workflows and used various tasks like Email, Event-wait and raise in workflow manager.
  • Created data profiles and scorecards using Analyst tool to analyze and measure the quality of data.
  • Defined Trust and validation rules before loading the data into the base tables
  • Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.
  • Configured Match & Merge Rules (Exact and Fuzzy) for consolidation process, Validation Rules and Trust scores respective of their BO tables.
  • Configured Hierarchies (Entities/ Entity Objects/ Hierarchies/ Relationship Objects/ HM Profiles) to define the hierarchy data of the corresponding data-model in IDD.
  • Created IDD application and Subject Areas, Subject Area along with Business entities
  • Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file.
  • Used SIF APIs (GET, SearchMatch, PUT, CleansePut, ExecuteBatchDelete etc.) to search, update, cleanse, insert and delete data.
  • Evaluating Informatica MDM 10.2 for some use cases. Performed silent installation of Informatica Platform during MDM setup.
  • Configuring and publishing business entities using Provisioning tool. Used external resources to configure IDD UI
  • Created and documented the secure resources, roles, users for roles, and assigned privileges to roles using Security Access Manager in development environment.

Environment: Informatica MDM 10.1/10.2, Informatica Data Director 10.1/10.2, Informatica ActiveVos 9.2.4.1/4.2, Informatica Power Center 10.1, Jboss 6.4EAP, RHEL 7, MS SQL Server 2012

Sr. Informatica MDM Consultant

Confidential, Bellevue, WA

Responsibilities:

  • Led effort for gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management.
  • Evaluated and reported the progress of data quality improvement to the management and also provided data quality training and consulting services to Business and IT members in the organization
  • Configured source systems collaboratively and performed Batch group with Stage and Load jobs.
  • Implemented Land Process for loading the customer Data Set into Informatica MDM from various source systems.
  • Design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
  • Used Dynamic Data Masking tool to mask sensitive data and prevent unauthorized access to the database.
  • Configured Match and Merge Rules in improving the data quality by match analysis, analysis of the MDM system performance and tuning the performance by changing the existing cleanse function, match rules etc.
  • Involved in developing and configuring the Hierarchies using Hierarchy Manager to identify hierarchical relationships.
  • Designed, configured and tested Informatica Data Director (IDD) interfaces.
  • Configured composite objects and composite services for SA and enabled E360 for entity view
  • Provided weekly status updates on progress, status and fatal errors in IDD.
  • Led ETL team towards designing and development of extraction mappings for inbound source to MDM and then outbound MDM to consuming systems.
  • Worked on IDD UI configuring subject areas for Customer Domain that assisted to search and edit master records that enabled client with their sales process transformation

Environment: Informatica MDM 10.0HF2, Informatica Data Director 10.0HF2, Informatica ActiveVos 9.2.4, Informatica Power Center 10, Dynamic Data Masking 9.6, Jboss, Oracle 12c, SQL Developer

IDD/MDM Consultant

Confidential (AutoTrader), Atlanta

Responsibilities:

  • Involved in all phases of the project SDLC planning, design, documentation, configuration, testing activities and code migration.
  • Analyzed the source systems for erroneous, duplicative, and integrity issues related to the data which is resided in various source systems such as Autotrader, Manheim, NextGear Capital and defined those all source systems in systems and trust model workbench.
  • Responsible for developing the IDD user interface(s) to the Customer Hub.
  • Analyzing the IDD User Interface Requirements (GUI development).
  • Design, configure, and test the IDD interfaces.
  • Collect stewardship interface requirements and develop the IDD constructs within MDM Hub.
  • GUI development based on Data Stewardship requirements.
  • Designed User Exits for validation errors and messages for save operation in IDD
  • Implemented multiple user exits, validation rules, SIF API's to customize IDD application and create business classified records.
  • Configured Subject Area Group, Subject Area, Subject Area Child and Subject Area Grand Child in IDD Admin Console.
  • Integration of MDM Hub with external applications using SIF APIs.
  • Used SIF APIs (GET, SearchMatch, PUT, CleansePut, ExecuteBatchDelete etc.) to search, update, cleanse, insert and delete data.
  • Created and documented the secure resources, roles, users for roles, and assigned privileges to roles using Security Access Manager in development environment.

Environment: Informatica MDM 9.7.1 HF4, Informatica Data Director 9.7.1, Informatica Power Center 9.6, Informatica Data Quality(IDQ) 9.6, Jboss, Oracle 11gR2, Address Doctor, SQL Developer, MS Visio 2013

Informatica MDM Consultant

Confidential, St Louis, MO

Responsibilities:

  • Involved in all phases of the project SDLC planning, design, documentation, configuration, testing activities and code migration.
  • Interacted with the Business Users & Enterprise Data Architects in the analysis & design of conceptual and logical data model that is required for solid MDM implementation & ensuring that it meets the business requirements and also supports the products capabilities.
  • Worked w /Data Profiling Team in analyzing the source systems data for duplicative and quality issues.
  • Performed data profiling of reference data for large data sets using Informatica Data Analyst tool.
  • Configured Base Object Tables in schema and relationship tables in hierarchies according to data-model.
  • Configured Landing Tables, Staging Tables, Look-ups, Cleanse Lists, Cleanse functions, Mappings, Audit trail/ Delta detection.
  • Executed Stage Jobs/ Load jobs using Batch viewer and Batch Group Jobs.
  • Analyzed the data from all the source systems and designed Match Rules, Validation Rules and Trust Scores.
  • Configured Match & Merge Rules (Exact and Fuzzy) for consolidation process, Validation Rules and Trust scores respective of their BO tables.
  • Created IDD/ HM Queries, Packages (PUT & Display) and Search Queries (Custom Queries).
  • Configured Hierarchies (Entities/ Entity Objects/ Hierarchies/ Relationship Objects/ HM Profiles) to define the hierarchy data of the corresponding data-model in IDD.
  • Creating JAVA User Exits (PostLoad, PostMerge and PostUnMerge) to customize the Hub functionality.
  • Configured Subject Area Group / Subject Area / Subject Area Child / Subject Area Grand Child in IDD Admin Console.
  • Utilized Metadata manager for Validating, importing and exporting the ORS repositories to different environments.
  • Created and documented the secure resources, roles, users for roles, and assigned privileges to roles using Security Access Manager in development environment.
  • Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.

Environment: Informatica MDM 9.7.1/9.5.1, Informatica Data Director 9.5.1, Informatica Power Center 9.5, Jboss, Oracle 11gR2, Microsoft SQL Server 2008, Address Doctor, SQL Developer

Informatica/MDM Developer

Confidential, TX

Responsibilities:

  • Involved in landing the data from Seven Different source systems by running external batch process to load business data for creating customer master data. External batch process used was ETL process.
  • Defined the Landing tables, Base objects, staging tables, foreign key relationships, lookup definitions, queries, packages and query groups.
  • Analyzed the source systems for erroneous, duplicative, and integrity issues related to the data which is resided in various source systems such as ERP, LEGACY, CRM, DNB, SALES system, and defined those all source systems in systems and trust model workbench.
  • Developed and managed relationships between data domains for the data models.
  • Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
  • Analyzed the business data and defined the Match and Merge rules and Trust Scores for MDM Hub.
  • Involved in loading data from different sources to staging area by cleansing data to do this we are using Trillium services and Duns Numbers from Duns and Bradstreet (DNB). After getting data as per business requirement from DNB and Trillium we are loading data to the ware house
  • Involved with ETL developers, for developing complex mappings, mapplets, reusable transformations using Informatica 8.6 designer to integrate data from different sources like Oracle, Flat files, and SQL databases by following guidelines and loaded data successfully into target.
  • Used Informatica components extensively Repository, Designer, Workflow Manager & Workflow Monitor .
  • For loading business logic successfully to database used different transformations like Router, Expression, Source Qualifier, Aggregator, Filter and Sequence Generator transformations extensively.
  • Created workflows and used various tasks like Email, Event-wait and raise, decision in workflow manager.
  • Involved in interaction with DBA team for creation of primary and secondary indexes on data warehouse tables.
  • Used debugger to test the mappings and fixed bugs accordingly.
  • Created Session and Batches using server manager to execute mappings.
  • Helped the testing team for data integrity and consistency.

Environment: Informatica Multi Domain MDM 9.5, Informatica Data Director 9.5, Informatica Power Center 9.5, Oracle 11gR2, IBM DB2, Windows Server 2008, TeraData, Toad 10.1, SQL*Loader, Erwin.

Informatica Developer

Confidential

Responsibilities:

  • Worked with business analysts for gathering requirements from high-end users and Performed Analysis on Business Data.
  • Responsible for development, support and maintenance of the ETL (Extract, Transform and Load) processes using Informatica Power Center.
  • Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations.
  • Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules. Created reusable transformations and mapplets and used them in complex mappings.
  • Used Workflow Manager for creating, validating, testing and running the sequential and concurrent Batches and Sessions, scheduled them to run at a specified time.
  • Used mapping parameters and variables.
  • Analyzed Session log files to resolve errors in mapping and managed session configuration.
  • Involved in migrating the ETL application from development environment to testing environment and extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and triggers.

Environment: Informatica Power Center 9.1/8.6, DB2, Oracle 10gR2, SQL, TeraData, PL/SQL, Toad 9.1 SQL*LOADER and UNIX Script.

Informatica/ SQL Developer

Confidential

Responsibilities:

  • Extraction, Transformation and data loading were performed using stored procedures into the database. Involved in Logical and Physical modeling of the drugs database.
  • Based on the requirements created functional design documents and technical design specification documents for ETL.
  • Created tables, views, indexes, sequences and constraints.
  • Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
  • Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
  • Involved in design and development of data validation, load process and error control routines.
  • Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
  • Generated monthly and quarterly drugs inventory/purchase reports.
  • Coordinated database requirements with Oracle programmers and wrote reports for sales data.
  • Designed, documented and sign off ETL process from business, implementing partners and Vendors.
  • Created workflows for ODS, DHW and Real Time based on mapping dependencies. Used UNIX scripts to execute workflows in correct fashion.
  • Participated in defects review meetings - to expedite defects fixes and enhancements.
  • Configured & created repository for metadata manager & imported Metadata from Cognos 8.2, Erwin, Powercenter 8.1.1 repository.

Environment: Informatica PowerCenter 8.1.1 Hotfix9, PowerExchange8.1.1 Hotfix8, Oracle 10g, SQL*Loader, SQL, PL/SQL, WindowsNT, UNIX shell scripting, Toad and ERWIN.

Hire Now