Informatica Mdm Hub/idd Developer Resume
Melville, NY
SUMMARY:
- 8+ years of experience in the field of Information Technology with an extensive experience in Master Data
- Management and as an ETL / Informatica 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 Siperian MRM XU/Informatica MDM components
- (Informatica MDM Hub Server, Hub Cleanse, Resource Kit and Cleanse Adaptors like Trillium and Address Doctor)
- Proficient in the development of solutions using Informatica (Siperian) MDM Hub
- 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
- Experience in utilizing the best practices of Informatica Data Quality (IDQ) by streamlining the Cleanse process in the discovery, documentation and resolution of data quality issues
- Experience in Erwin Data Modeler tool in designing both logical and physical data models
- Experience 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.
- Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups
- 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
- 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/7.x
- Hands on Experience in Extracting, Transforming, and Loading (ETL) data for data warehouse, data migration and other data conversion
- 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 Generator and Slowly Changing Dimensions (SCD) Type-1and Type- 2
- Created, launched & scheduled Workflows/sessions and extensively involved in the Performance Tuning of Mappings and Sessions
- Strong experience in designing and developing complex mappings to extract data from different sources including flat files, RDBMS tables and XML files
- Experienced in Data Profiling, Data Cleansing and Data Standardization using Informatica Power center and UNIX Shell script by using Data/Golden copy
- Excellent experience in using and writing UNIX Shell Scripts
- Extensively involved in writing Oracle, PL/SQL, Stored Procedures/ 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 selflearning.
TECHNICAL SKILLS:
ETL Tools: Informatica Power Center 9.x 8.x/7.x, Informatica Power ExchangeCleanse Adapters Address Doctor and Trillium
Databases: Oracle … 11g, SQL Server … DB2, MS-Access, Teradata
Languages: SQL, PL/SQL, C, C++, C#, UML 2.0, JAVA, J2EE, Unix Script
RDBMS Tools: TOAD, SQL*Loader (Oracle), SQL*Plus, Db Visualizer, Teradata SQL Assistant
OLAP/ Reporting Tools: OBIEE and Cognos
Modeling Tools: Erwin Data Modeler and MS Visio
Environment: Windows 2000/ XP, Unix, Windows 7, server 2003, 2008/Linux
Packages: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word), Visual Studio 6.0.
Testing Tools: Win Runner, Load Runner, Test director, QTP
WORK EXPERIENCE:
Informatica MDM Hub/IDD Developer
Confidential - Melville, NY
Responsibilities:
- Interact with the Business Users & Solution Architects and design the Conceptual and logical data model
- Configure the Landing Tables, HUB Base objects, Staging table for each source systems, MappingsRelationships, static lookups, dynamic lookups, Queries, Packages
- Define the Trust and Validation rules and set the Match and Merge rule sets to get the right master records
- Configure Match and Merge Rules in improving the data quality by match analysis
- Configure Informatica Hierarchy Manager and its components entity types, hierarchies, relationships typespackages, and profiles
- Create Batch Groups that has a combination of all Stage jobs and Load jobs and can be executed with a single command.
- Create different types of Cleanse Functions that were used for Subject Areas in IDD Applications.
- Configure Informatica Data Director (IDD), created IDD Applications, Subject Area Groups, Subject AreasChild Subject Areas and Grand Child Subject Areas
- As per the Business, customize the IDD Screens; design IDD Search Queries with advanced search option.
- Create and implement different validations within IDD screens using the Cleanse functions and User Exits.
- Create User groups, Roles and privileges to the users using Security Access Manager (SAM) in accessing
- MDM Hub and IDD Applications.
- Writing Shell Scripts for Autosys to run the Batch jobs
- Raise Service Requests to Informatica Support and then resolved the issues
- Prepare User Guides for all IDD Applications and Technical documents
Environment: Informatica MDM 9.6.1, Informatica Data Director 9.6.1, Web logic 10.3.6, Oracle, TOAD/SQL
Informatica MDM Hub Developer (Oracle DB)
Confidential - Dayton, OH
Responsibilities:
- Acted as the primary Hub Designed and Developer of Customer Master functionality incorporating all aspects f the SDLC
- Provided Technical Domain Expertise within the scope of Master Data Management
- Assisted with the development at all times ensuring adherence to enterprise technical and architectural standards and processes
- Coordinated with multisystem solutions to clarify interdependencies such that systems appear seamless to
- Customer
- Heavily Interacted with Business & Data Architects Leads to understand the business requirements for the next release (R5.3) and involved in GAP analysis for the earlier release
- Prepared Technical Requirement's and Technical Design Document's for implementing the solutions as per business needs
- Played a vital role in Enterprise Customer Master (ECM) team to Inbound the source data to ECM MDM
- Hub through Middleware RT Services - GET, SEARCH, SYNC and then outbound the Customer Master to consuming systems
- Configured Data model changes after peer review and approval and implemented those changes to the MDM
- Data model schema which includes adding new Base Objects and columns for a changing Business Process
- Working on Delta Data - Incremental Process. (Configuring the new R 4.6 release requirements to the DEV environment:, copying the Prod. data of R 4.5 release to the same DEV environment and run the Batch jobs accordingly)
- Designed and executed PUT Database procedures to load the data into the MDM Base Object
- Coordinating with Offshore team and mentored peers during the course of the project required
Environment: Informatica MDM 9.5.1, Informatica Data Director 9.5.1, Erwin Data Modeler r7.3, Address
Informatica MDM Hub/Data Configurator
Confidential - Alpharetta, GA
Responsibilities:
- Master Data Control Point (MDCP) Product Space
- Interacted with the Enterprise Data Architects to understand the requirements and prepared technical documents for implementing the solutions as per Business needs
- Worked on Erwin Data Modeler tool in designing both logical and physical data models
- Using the Erwin, documented the Metadata Mapping and mentored the peers
- Created the Base Objects and Columns as per the Data Model and also created Queries, Query groupsPackages
- Configured the Hierarchies using Hierarchy Manager to identify hierarchical relationships
- Involved in tuning the Match and Merge Rules in improving the data quality by match analysis
- Requested the MTD (Move to Dev) and MTI (Move to ITG/Stage) and promoted the Change List to respective environment: s.
- Sales Customer Technical Conversion
- The scope of the Technical Conversion Process is to convert existing Salesforce customer accounts subscriptions in MDCP to the business relationship model, which would be a onetime conversion.
- Interacted with Architects and Leads in understanding the Business requirements and prepared High Level
- Design documents
- Created the Landing Table, Staging Tables for corresponding Base Objects, Cleanse Functions, Mappings and Batch Groups
- Wrote the Database Scripts to populate Landing Table from Existing Base Object
- Played a critical role in Optimizing the Load Process time as low as we can
- Requested the MTD (Move to Dev) and MTI (Move to ITG/Stage) and promoted the Change List to respective environment: s.
- Contact Cloud - Target Builder Inbound
- Gathered Business requirements and maintained the documents, accordingly developed the specifications in the development
- Configured the Landings Tables, Base objects, Staging Tables and defined foreign key relationships, static lookups, dynamic lookups and mappings
- Configured the Cleanse functions and mappings
- Requested the MTD (Move to Dev) and MTI (Move to ITG/Stage) and promoted the Change List to respective environment: s.
Environment: Informatica MDM 9.5.1, Informatica Data Director 9.5.1, Erwin Data Modeler r7.3, Address
MDM Hub Specialist - Informatica Professional Services
Confidential - Fort Worth, TX
Responsibilities:
- 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
- Analyzed the source system for integrity issues to the data resided in various source systems
- Performed Data profiling of data for large data sets using Informatica Data Analyst tool.
- Configured and installed Informatica MDM Hub server version 9.6(BETA RELEASE) for SQL SERVER 2012cleanse, resource kit, and Address Doctor5 in all the Environments.
- Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
- Defined the HUB Base objects, Staging tables, foreign key relationships, static lookups, and dynamic lookupsqueries, packages and query groups.
- Performed ETL mappings & ran sessions and workflows to execute the Land Process of loading the customer/ product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems
- Worked on data cleansing and standardization using cleanse functions, cleanse lists and creating custom cleanse functions (Attribute functions and Object functions) in Informatica MDM
- Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
- Configured match rules and rule sets property by enabling search by rules in MDM according to Business
- Rules
- Implemented IDD applications based on subject areas and subject area groups for search requests for
- Customer model
- 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.6.0 (BETA RELEASE), Informatica Data Director 9.6.0, Informatica Data
Informatica MDM Consultant
Confidential - Groton, CT
Responsibilities:
- Interacted with the Business to understand the requirements and prepared technical documents for implementing the solutions as per Business needs
- Led Information Exchange Hub (IXH) team to place the source data in XML file format and inbound to MDM
- Hub and then outbound the Master record to consuming systems like ODW and CSDW teams.
- Involved in implementing the Pre - Land and Land Process of loading the dataset into Informatica MDM Hub Data Module (RDM)
- Involved in Parsing, Standardizing and Data profiling the dataset using Informatica Data Quality (IDQ) tool
- Configured Address Doctor to cleanse and validate Worldwide Addresses
- Took development decisions by working with business users and enterprise architects to understand enterprise vision and direction
- Created Queries, Query groups, Packages, cleanse functions and cleanse lists
- Analyzed the RDM system performance and issues, modified the existing Match Rules for the better Match percentage
- Configured Match and Merge Rules in improving the data quality by match analysis
- Configured Informatica Data Director (IDD), created Applications, Subject Area Groups, Subject AreasPackages and Queries for the BO's and assigned tasks to the respective users.
- As per the Business, designed IDD Search Queries as Standard, IDD Queries as public, Subject Area name as Subject Area Group
- Raised SR's to Informatica Support and Oracle and then resolved the issues
- Responsible for creating user groups, privileges and roles to the users using Security Access Manager
- (SAM).
Environment: Informatica MDM 9.1, Informatica Data Director, Informatica Data Quality 9.1, Informatica PowerCenter 9.1, SIF, Web logic 11g-R1, Oracle 11g, SQL Developer, Address Doctor, Toad 11.5, SQL*LoaderWindows server 2003, Erwin.
Informatica MDM Consultant
Confidential - Bellevue, WA
Responsibilities:
- Responsible for GAP Analysis to help identify current and purpose and structure of MDM system.
- Led effort for gathering business requirements for the data - warehouse as well as business-intelligence reports to be used by the management.
- Designed, Installed and Configured the Informatica MDM Multi domain. (Hub Server, Cleanse, Cleanse
- Adaptor, Resource Kit)
- Defined Business rules in Informatica Data Quality (IDQ) to evaluate data quality by creating cleanse processes to monitor compliance with standards and also identified areas for data quality gaps and assist in resolving data quality issues.
- Evaluated and reported the progress of data quality improvement to the Management and also provided data quality and consulting services to Business and IT members in the organization
- Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM
- Hub that was coming from various source systems.
- Performed Data profiling using Informatica Data Analyst tool.
- Took development decisions by working with business users and enterprise architects to understand enterprise vision and direction.
- 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.
- Provided weekly status updates on progress, status and fatal errors in IDD.
- Hands on executing MDM hub Batch Jobs (Stage, Load, Tokenize and Match Processes) and Batch Groups.
- Led ETL team towards designing and development of extraction mappings for inbound source to MDM and then outbound MDM to consuming systems.
- Responsible in installing the SIF Services Development Kit (SDK) and used the Java classes by running a
- Java virtual machine (JVM)
- Participated in Mentoring of peers in Informatica MDM and Informatica Data Director Product.
Environment: Informatica Multi Domain MDM 9.1, Informatica Data Director, Informatica Data Quality9.x, Informatica Power Center 9.1, SIF, Web logic, Oracle 10g, SQL Developer, Address Doctor, ToadSQL*Loader, Windows server 2003, Erwin.
Siperian/MDM Consultant
Confidential - Indianapolis, IN
Responsibilities:
- Responsible for GAP Analysis to help identify current and purpose and structure of MDM system.
- Interacted with Client to understand the Business requirements and prepared technical documents for implementing the solutions as per business needs.
- Responsible for migrating Siperian MRM XU to Informatica MDM Hub 9.1
- Configured the core Informatica MDM components such as Hub Console, Hub Server, Cleanse Match ServerHub Store, Services Integration Framework, and IDD Configurations and Data Modeling
- Installed and Integrated Informatica Data Quality (IDQ) on Informatica power center server machine and also applied business rules to cleanse data
- Implemented the Customer Master Source data into landing tables from a Siebel SFA and SAP Customer
- Master (CM) applications and other syndicated sources, such as CRM, Legacy and DNB
- Defined the schema, staging tables, and landing table, configuring base object (customer, address, and
- Organization), foreign - key relationships, query groups and queries
- Configured IDD for Data Governance to be used by the Business.
- Analyzed high-level MDM business requirements translated and documented them to detailed requirements.
- Responsible to maintain the architecture diagrams and impact analysis for the MDM Hub.
- Configured Address Doctor and was responsible in developing the source-target mappings.
- Involved in all phases of the Software Development Lifecycle (SDLC) including monitoring and guiding all
- MDM tasks.
- Configured in Data Modeling and ETL/Database Design Sessions.
Environment: Informatica MDM 9.1, Informatica Data Quality 9.1, Informatica 8.6, Oracle 10g, Toad, JBoss
Sr. Informatica ETL/Oracle Consultant
Confidential - Stevens Point, WI
Responsibilities:
- Gathered business scope and involved in modifying various technical & functional specifications in the development.
- Responsible for migrating all the Applications code, workflows, sessions and mappings from Informatica 8.5 version to 9.1.
- Worked with Power Center Designer tools in developing mappings and mapplets to extract and load the data from flat files and Oracle (source) to Oracle (target).
- Extensively used Informatica Power Center and created mappings using transformations like Source
- Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator and also created Reusable Transformations and Mapplets to use the transformation logic in multiple mappings.
- Responsible for creating user groups, privileges to the users using repository manager.
- Involved in the designing of the Data Model in deriving Conceptual, Logical and Physical model's using Erwin
- R7 with Architect teams
- Scheduled Sessions on the Informatica Server using Informatica workflow Manager.
- Designed complex mapping logic to implement SCD1 and SCD2 dimensions.
- Wrote Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage and also created Views and altered some of the dimensional tables to satisfy their reporting needs.
- Performed Unit Testing.
Environment: Informatica Power Center 8.5/9.1(Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations), Oracle 9i/10g, PLSQLErwin, Load Runner, TOAD
Informatica ETL Developer
Confidential
Responsibilities:
- Interacted with Business users to understand the Business requirements and prepared technical documents for implementing the solutions as per business needs.
- Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes.
- Involved in logical and physical data modeling, analyzed and designed the ETL processes.
- Involved in migration of Informatica 7.1.3 to Informatica 8.1.1
- Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
- Created and developed various transformations, several complex Mappings, Mapplets and Reusable
- Transformations and also Extracted the data from relational Database source (Oracle), flat files to facilitate one time, Daily, Monthly and Yearly Loading of Data based on company requirements and load into Oracle tables.
- Configured the mappings to handle the updates to preserve the existing records using Update Strategy
- Transformation.
- Experienced in implementing and maintaining SCD Type 2 Dimension Tables
- Used Informatica Workflow Manager for Creating, running the Batches and Sessions and scheduling them to run at specified time.
- Involved in Debugging, Troubleshooting, Testing, and Documentation of Data Warehouse.
- Created new Tables, Indexes, and Sequences where needed.
- Documenting the ETL mapping strategies and transformations involved in the extraction, transformation and loading process
Environment: Informatica Power Center 8.1.1, Oracle 9i, SQL, PL/SQL, TOAD 9.0, Windows XP
Oracle/ETL developer
Confidential
Responsibilities:
- As a Technical Team Member, involved in identifying the business user requirements and development of different modules and PL/SQL procedures.
- Extensively used Informatica Power Center 7.1 an ETL tool to extract, transform and load data from remote sources to DW.
- Worked extensively on various active & passive transformations and created complex mappings and tuned them for better performance.
- Used ODBC to connect to the target Oracle database.
- Extensive Use of SQL Overrides and substituted them in place of multiple transformations.
- Used transformations for data joins, complex aggregations.
- Responsible for improving query and session performance.
- Created, launched & scheduled sessions and batches using Server manager.
- Define mappings slowly changing dimensions and slowly growing Targets.
- Performed Unit testing.
Environment: Oracle 8i, PL/SQL, Informatica Power Center 7.1, Windows, SQL plus, Win Runner, Toad.