Informatica MDM Developer Resume Profile, USA

Reference Id: 71526     Posted on Saturday 1st August 2015      Informatica Resumes



Please note that this is a not a Job Board - We are an I.T Staffing Company and we provide candidates on a Contract and Full-time basis. If you need I.T.Professionals to fill a Contract or a Full-time Position, please call (800) 693-8939

Informatica MDM Developer Resume Profile, USA


Summary

  • 7 years of experience in software development maintenance testing and troubleshooting on Informatica Master Data Management MDM ETL/DWH applications data quality data integration and Oracle database
Experienced in

  • Gathering requirements from the Business and preparing the functional documents
  • Review the high level documents to ensure the requirements are addressed accordingly and
Discuss the possibilities of the requirements

  • Review on Low level documents review the documents with Client s IT team to make sure code is
Bug free and make sure times are falling under project timelines

  • Installing and Configuring of Informatica MDM Hub Console Hub Store Cleanse and Match Server Address Doctor Informatica Power Center applications
  • All facets of MDM implementations including Data Profiling metadata acquisition data migration validation reject processing and pre landing processing
  • Performing requirement gathering analysis design development testing implementation support and maintenance phases of both MDM and Data Integration Projects
  • Master Data Management MDM Data Integration concepts in large scale implementation environments
  • Creating landing tables Staging tables Base Tables as per the data model and data sources
  • Developing mappings using various cleanse functions and Address doctor functions to move data into Stage tables
  • Defining Trust Score Validation rules Match rules and Merge settings
  • Closely worked with other IT team members business partners data stewards stakeholders steering committee members and executive sponsors for all MDM and data governance related activities
  • Developing the IDD application building Hierarchies as per the business needs
  • Working with PowerCenter Designer Repository Manager Workflow Manager and Workflow Monitor
  • Worked on Real Time Integration between MDM Hub and External Applications using Power Center and SIF API for JMS
  • Created complex transformations and mappings processing tasks scheduling sessions importing/exporting repositories in power center
  • Good experience in Data Warehousing methodologies/Dimensional Data modeling techniques such as Star/Snowflake schema using ERWIN
  • Extensively implemented Slowly Changing Dimensions Type1 Type2 Type3
  • Experience in Extraction Transformation and Loading ETL data from various sources into Data Warehouses using Informatica Power Center Power Mart Repository Manager Designer Workflow Manager and Workflow Monitor
  • Strong skills in SQL PL/SQL packages functions stored procedures triggers and materialized views to implement business logic in oracle database
  • Working with tools like TOAD SQL Developer and SQL plus for development and customization
  • Worked extensively on creating new CUSTOMER ONBOARDING process with new configuration on External matching Rules and processing the customer data before loading into MDM
  • Experienced in creating workshops with data stewards and business owners on match rules tuning IDD configurations and Trust scores and validations
  • Team player and self starter with good communication skills and ability to work independently and as part of a team
Technical Skill Set
Professional Experience

Confidential

Informatica MDM Developer


Responsibilities



  • Installed Informatica MDM 9 5 In UNIX Red Hat with the middleware JBOSS 5 1 GA
  • Configured cleanse server and address doctor
  • Implement Informatica MDM workflow including data profiling configuration specification and coding match rules tuning migration
  • Build out best practices regarding data staging data cleansing and data transformation routines within the Informatica MDM solution
  • Define and build best practices regarding creating business rules within the Informatica MDM solution
  • Created Base Tables Stages tables based on the data model and number of source systems
  • Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
  • Worked with Business users in understanding Match Merge setup and incorporated their requirements and ideas
  • Collaborated with users in defining Match Rules and conducted workshops to discuss over and under matching
  • High level review of SAM discussed use of Roles creation of users and assignment of user to Role
  • Defined Roles and privileges for each environments according to the platform requirements
  • Defined the security such that schema will be secured with access only granted for specific downstream integration uses using users created for those specific integrations
  • Develop and maintain the master and translation entities in the MDM Hub and published the data into SFDC s and ERP s for supporting the ongoing business support
  • Created Customer onboarding process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store and define automation process for staging loading match and merge
  • Configured designed and delivered MDM hubs across multiple data domains Party Service/Product Prospect
  • Used hierarchies tool for configuring entity base objects entity types relationship base objects relationship types profiles put and display packages and used the entity types as subject areas in IDD
  • Created and Developed IDD application by creating Subject Area Groups Subjects Areas and Entity Relation ships
  • Performed analysis design development and maintenance activities associated with the database and data in support of multiple applications including following standards/procedures to achieve integration of systems through database design
  • Finally Created Data Validation document Unit Test Case Document Technical Design Document Informatica Migration Request Document and Knowledge Transfer Document
Environment Informatica MDM 9 5 1 Informatica 9 5 IDQ Oracle 11g MS Excel Unix

Confidential
Informatica MDM Developer
Confidential is part of one of the world s leading research oriented healthcare organizations the Confidential Active in the fields of pharmaceuticals and diagnostics Confidential develops innovative products and services that address the prevention diagnosis and treatment of diseases thus enhancing well being and quality of life

Responsibilities



  • Successfully completed Customer and Product centric Master Data Management initiatives using Informatica Master data management product
  • Developed comprehensive models for managing and communicating the relationships between Base Objects and Performed the ETL process for loading the data into hub
  • Contributed to Data Migration and the Implementation of Roadmap defined by the business case
  • Implemented batch process using automation and real time integration with Power Center for JMS interfacing with MDM HUB
  • Analyzed the Business data and defined the Match and Merge rules and Trust Scores for INFA MDM Hub
  • Defined and configured schema staging tables and landing tables base objects foreign key relationships look up systems and tables packages query groups and queries/custom queries
  • Designed and defined best implementation and deployment practices for Informatica Data director implementation within services organization
  • Develop workflows to data domains for performing extraction validation cleansing matching loading exception handling and other data related activities to support Customer s MDM requirements
  • Used Metadata manager for validating promoting importing and exporting repositories from development environment to testing environment
  • Deployed new MDM Hub for portals in conjunction with user interface on IDD application
  • Develop standards guidelines processes and expertise to consistently address strategic data issues such as data quality cleansing standards and integration by using Address Doctor cleanse adapter
  • Used metadata manager for importing exporting validating the data for transforming the schema from development environment to testing environment
  • Identified Golden Record BVT for Customer Data by analyzing the data and duplicate records coming from different source systems
  • Involved with Data Steward Team for designing documenting and configuring Informatica Data Director for supporting management of MDM data
  • Worked extensively on Informatica client tools like Designer workflow Manger Workflow Monitor during different phase of project
  • Created Sessions/Batches in Informatica server manager to execute mappings
Environment Informatica MDM 9 1 0 Informatica Power Center 9 1 Oracle 11g/10g Toad JBoss 5 1 0 Address Doctor IDD Trillium Windows server 2003 Unix



Confidential
Informatica MDM Consultant
Confidential

Responsibilities



  • Installed Informatica MDM 9 5 In UNIX Red Hat and windows server 2008 with the middleware JBOSS 5 1 GA and Web logic 11 g
  • Configured cleanse server and address doctor
  • Implement Informatica MDM including data profiling configuration specification and coding match rules tuning migration
  • Build out best practices regarding data staging data cleansing and data transformation routines within the Informatica MDM solution
  • Define and build best practices regarding creating business rules within the Informatica MDM solution
  • Created Base Tables Stages tables based on the data model and number of source systems
  • Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
  • Worked with Business users in understanding Match Merge setup and incorporated their requirements and ideas
  • Collaborated with users in defining Match Rules and conducted workshops to discuss over and under matching
  • High level review of SAM discussed use of Roles creation of users and assignment of user to Role
  • Defined Roles and privileges for each environments according to the platform requirements
  • Defined the security such that schema will be secured with access only granted for specific downstream integration uses using users created for those specific integrations
  • Develop and maintain the master and translation entities in the MDM Hub and published the data to downstreams
  • Performed land process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store and define automation process for staging loading match and merge
  • Configured designed and delivered MDM hubs across multiple data domains Party Service/Product Prospect
  • Used hierarchies tool for configuring entity base objects entity types relationship base objects relationship types profiles put and display packages and used the entity types as subject areas in IDD
  • Created and Developed IDD application by creating Subject Area Groups Subjects Areas and Entity Relation ships
  • Performed analysis design development and maintenance activities associated with the database and data in support of multiple applications including following standards/procedures to achieve integration of systems through database design
  • Finally Created Data Validation document Unit Test Case Document Technical Design Document Informatica Migration Request Document and Knowledge Transfer Document
Environment Informatica MDM 9 5 1 Informatica 9 5 IDQ IDS Oracle 11g SQL Server 2005/2008 MS Access MS Excel Unix

Confidential Sr ETL / Informatica Consultant

Responsibilities



  • Implementing the standards of creating Informatica Workflows/Mappings
  • Implemented standards for naming Conventions Mapping Documents Technical Documents Migration form
  • Extensive experience with End Users for understanding/analyzing the requirements
  • Analysis of the End user requirements and involved in Modeling the ETL Schema
  • Detailed Analysis of the Data provided by the respective source systems and filling in the gaps in the mapping specs
  • Experience in designing the complete End to End Data Flow and designing the ETL jobs
  • Created Users/Permissions/Folders/Shared Folders/Deployment Groups in 7 1/8 6
  • Worked on Source Analyzer Warehouse Designer Mapping Designer Mapplet Designer and Transformations Developer
  • Used ETL to extract and load data from different data bases and flat files to Oracle
  • Creating Complex Mappings/Workflows as per the Business Logic
  • Involved in writing lot of Functions Stored Procedures

  • Responsible for Data Extraction and Transformation from disparate sources like Oracle DB2 SAP SQL Server flat files and Loading to Oracle using Informatica Power Center
  • Involved in designing of Informatica Mappings by translating the business requirements
  • Involved in Performance Tuning and optimization of Informatica mappings and session
  • Implemented ABAC Automated Balance and Audit Controlling process to resolve errors

  • Created the Error handling Mechanisms and reconciliation procedures
  • Deploying the code across different environments
  • Performed Code Review with the team members
  • Supporting and maintaining the existing applications in Production Resolving the Tickets
  • Created UTPs/UTRs for the mappings
  • Performance Tuning of Informatica /Data Base Code
  • Analysis of the CPU Resources Used on the Application and DB servers for Performance testing
  • Creating Stored procedures Functions Views for loading the staging tables
  • Created Unix Scripts for End to End process flow
  • Created Autosys jil scripts for Automation of jobs
  • Created Technical Design Documents/Low Level Design Documents/Run Book for Basel II Project
  • Used Rational Clear Quest For Raising Migration Requests
  • Used HP Quality Center for Defect Tracking
Environment Oracle 9i/10g Informatica 8 6 1/9 0 SQL Server Sybase Solaris HP Quality Center UNIX Shell Programming

Search Resumes

Looking for I.T Professionals on a Contract basis?