Informatica Mdm Consultant Resume
Warsaw, IN
SUMMARY
- 8+ years of IT experience in Analysis, design, development, testing and Implementation of EIM solutions using Informatica Master Data Management and Informatica Power Center in various verticals such as Sales and banking, Pharmacy data warehousing and public services.
- Expertise in Installing, Managing and configuring Informatica MDM Hub Server, Informatica MDM Hub Cleanse, Cleanse Adapters(Address Doctor), Informatica MDM Hub Resource Kit.
- Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
- Configured batch groups for processing staging, loading base objects and for performing match jobs.
- Configured JMS Message Queue in the MDM hub Console.
- Configured Soap based SIF API calls by using SoapUI for performing multiple tasks in Informatica MDM Hub.
- Helping business to understand the Match rules configuration and decide the trust factor andConfigure match/merge rules.
- Successfully, setup the data and configured the components needed by Hierarchy Manager for MDM HUB implementation which included implementing hierarchies, relationships types, packages and profiles by using hierarchies’ tool in model workbench.
- Developed workflows to data domains for performing data extraction, data validation, data cleansing, data match, data load and required data related activities to support Customer’s MDM requirements.
- Designed & developed multiple cleansing and standardization scenarios using Address Doctor.
- Addressing issues of master data definition, metadata acquisition and data migration including data profiling, validation, clean-up and remediation, and source to target mapping.
- Implementing IDD applications to maintain/manage data, access relationship hierarchies and configured task management to route tasks to the Data stewards.
- Identified Golden Record (BVT) for Customer Data by analyzing the data cleansing and merging duplicate records coming from different source systems.
- Analyzed the Business data and defined the Match and Merge rules and helped business to develop Trust Scores for MDM Hub.
- Analyzed the source systems for erroneous, duplicative, and integrity issues related to the data.
- Expert at creating Queries, Packages both using Hierarchies and Packages.
- Continuously monitor the accuracy of the data and the content of the delivered reports.
- Strong analytical and problem solving skills.
- Excellent communication and interpersonal skills. Ability to work effectively while working as a team member as well as individually.
TECHNICAL SKILLS
EIM Tools: Informatica MDM Multi-domain Edition (9.5.x/9.7.x/10.1), IDD
Cleanse Adapters: Address Doctor
Databases: Oracle 8.x/9.x/10g/11g
Database Tools: SQL Developer.
ETL Tools: Informatica Power Center 9.x
Data Modeling: MS Visio 2000, Erwin.
Programming Skills: SQL, PL/SQL, XML, JAVA
Application Servers: JBoss, Web logic.
Package: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word)
OS Platforms: Windows 8.1/7/XP/2000, Windows SERVER 2008
PROFESSIONAL EXPERIENCE
Confidential, Warsaw, IN
Informatica MDM Consultant
Responsibilities:
- Interacted with Business & Data Architects Leads to understand the business requirements.
- Installed Informatica MDM 9.7.1 on Jboss -6.2.0 in Windows environment.
- Defined ETL process to load the data into the landing tables during the land process using Informatica Power Center.
- Configured landing, staging and base objects and configured relationship between entities.
- Configured Mapping by using cleanse functions to get data from landing to staging.
- Created hierarchies using the hierarchy manager in the MDM hub as per the business needs.
- Created packages based on queries in MDM Hub for displaying/updating the data.
- Performed manual landing, staging and loading process using the batch viewer.
- Developed the Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and Merge Process
- Configured batch groups for performing the staging, loading, generate match tokens and perform match and merge process.
- Worked on Security Access Manager (SAM) workbench for creating roles and assigning users.
- Created MDM query’s and packages in MDM hub under model workbench.
- Participated in Mentoring of peers in Informatica MDM and Informatica Data Director Product.
- Created and Implemented IDD application, created subject area groups, subject areas, subject area child.
- Configured Hierarchies in IDD to display and maintain relationship between customers and devices.
- Created manual merge tasks for Data stewards and managers for managing manual merge tasks.
- Coordinating with Offshore team and mentored peers whenever required.
Environment: Informatica MDM Multi-domain 9.7.1/10.1,JBoss EAP 6.2.0, Informatica Power center 9.1, SQL Server
Confidential, Houston, TX
Informatica MDM Consultant
Responsibilities:
- Coordinated with project leads, business users, enterprise data architects and data modelers in finalizing the master data-model.
- Utilized ERWIN data modeler to define entities, attributes and relationships.
- Configured Base Objects, Staging Tables, Landing Tables and columns in the tables.
- Defined Mapping data from Loading Tables to Staging Tables.
- Standardized the data using cleanse functions.
- Involved in setting up Foundation Objects for Datamodels like Organizations, Business Relationships, Person and Person Privacy data models in MDM Hub
- Defined the Foreign Key Relationship between Base Objects.
- Created Match Paths, Match Columns for Match and Merge Process.
- Develop standards, guidelines, processes, and expertise to consistently address strategic data issues such asdata quality, cleansing, standards, and integration by using Address Doctor cleanse adapter.
- Created Queries and Query Groups to be used in Packages for IDD and Data Manager Tools.
- Developed Data import functionality on IDD for bulk data import.
- Configured Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, and Profiles using Hierarchies tool.
- Defined Put / Update and Display Packages to be used in Hierarchy Manager.
- Troubleshooting the rejected records during the Landing, Staging and Loading process.
- Coordinated with Informatica Support team for any Vendor issues.
- Coordinated with offshore and onshore team in successful MDM.
Environment: Informatica MDM 9.5, IDD, Oracle 11g/10g, JBoss 6.2.0, Address Doctor, Windows server 2008.
Confidential, Chicago, IL
Informatica MDM Consultant
Responsibilities:
- Configured Base Objects, Staging Tables, Landing Tables and columns in the tables.
- Build the source systems in Systems and Trust model workbench.
- Created the Foreign Key Relationship between Base Objects.
- Designed and developed validation rules and match/merge rules and data cleansing using Informatica MDM Hub.
- Created Queries and Query Groups to be used by Packages, Data Manager and Merge Manager Tools.
- Defined Put / Update and Display Packages to be used in Hierarchy Manager.
- Configured Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, and Profiles using Hierarchies tool.
- Improved the data quality by Match analysis, analysis of the MDM system performance and tuning the performance by changing the existing cleanse function and match rules.
- Experienced in Metadata manager to Import and Export of Metadata and Promote Incremental changes between environments from development to testing environment.
- Created user groups, privileges and roles to the users using Security Access Manager (SAM).
Environment: Informatica Multi Domain MDM 9.5x, Oracle 10g, SQL Developer.
Confidential, Simsbury, CT
ETL Developer
Responsibilities:
- Verifying the Business requirement document and Technical design document against requirements.
- Gathered requirements about design of data warehouse and data mart entities.
- Designed data model, created dimension tables and measure objects according to business requirements
- Designed mapping templates which specify high level approach.
- Developed the Informatica maps by using the functional documents with sources like flat files and XML etc.
- Experience in data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator
- Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues
- Used Informatica Power Center and it’s all features in migrating data from OLTP to Enterprise Data warehouse.
Environment: Informatica Power Center 8.6.1, SQL, SQL Server 2000.
Confidential
ETL Developer
Responsibilities:
- Created data extracts and reports using Microsoft SQL Server Suite (SQL Server Integration Services and SQL Server Reporting Services).
- Worked closely with Business Analysts and SMEs to understand business requirements.
- Designed, developed and maintained complex business intelligence reports.
- Designed and developedSQL Server stored procedures, functions, views and triggers to be used with ETL and reporting processes.
- Created source-to-target mappings for loading data warehouse/data marts.
- Perform data analysis of structured and unstructured data, performance tuning of ETL processes.
- Recommended new and modified reporting methods and procedures to improve report content and accuracy.
- Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, and Joiner.
- Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
- Extracted data from different sources like Oracle, flat files, XML loaded into DWH Prepared Test SQL Scripts to Test ETL Transformation logic.
Environment: Oracle 8i, PL/SQL, Informatica Power Center 7.1, Windows, SQL plus, Win Runner, Toad.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Maintained and led Production support team and achieved single digit backlog production incidents.
- Automated many manual process using oracle pl/sql.
- Worked on tuning of sql and pl/sql codes which runs behind java user interfaces, significantly reduced a response time of a page from 160 seconds to 7 seconds.
- Performed cleanup activities and maintained the system without erroneous, duplicative, and integrity issues.
- Developed sql loader control files to load data from files to database.
- Involved in security analysis and enhanced security for the project by implementing new changes on the process.
- Created diagnostic tool to the project which helps new resources to handle production incidents effectively.
- Participated on auditing activities and improved the system more stable and reliable.
Environment: Oracle 8i, PL/SQL