We provide IT Staff Augmentation Services!

Informatica Mdm Consultant Resume

Boston, MA

SUMMARY:

  • Over 5 years of IT experience in which over 3 years of certified experience with Informatica Master Data Management Multi Domain Edition 10.2, 10.1, Master Data Management concepts, methodologies and ability to apply this knowledge in building MDM solutions and over 2 years of experience with ETL.
  • Experience in installing and configuring Informatica MDM hub console, hub server, cleanse match server, resource kit, Cleanse Adapter, Informatica data director (IDD) and JBOSS Application server.
  • Experience in configuring Schemas including landing tables, staging tables, base objects, table/foreign - key relationships, staging lookups, auto match/merge setup, trust, and validation rules.
  • Experience in configuring packages, query groups, and queries including display and PUT queries.
  • Experience in configuring Hierarchies for profiles, entity base objects, relationship base objects, FK relationship base objects, entity types, relationship types, and profiles.
  • Configured the Smart Search and Entity 360 in IDD for Product MDM.
  • Experience in configuring IDD for the business user’s for better performance.
  • Experience in installing and configuring SOAP UI to clean the base objects and associated supporting tables.
  • Experience in configuring ActiveVOS for Managers/Data Stewards team approval.
  • Strong proficiency in developing mappings, workflows, sessions, tasks and using all Informatica transformations such as lookup, source qualifier, expression, target, mapplet & SQL procedure.
  • Experience working with Databases like MySQL, Oracle DB and SQL Server.
  • Knowledge on different file formats like Text file & XML.
  • Working experience on Agile Scrum methodology, Waterfall Methodology and Cosmic Estimation.
  • Proficient in using application servers like JBoss and Tomcat Servers.
  • Good exposure to work culture and client interaction with diverse teams. Proven ability to learn quickly and apply new technologies.
  • Good communication and written skills and can lead a team and work as a team member.

TECHNICAL SKILLS:

EIM Tools: Informatica MDM 10.2/10.1, IDD, SIF

BPM Tools: ActiveVOS

Programming Language: C, C++, C#, Java, SQL, XML

Java Technologies: Servlets, JSP, JDBC, Core Java

Web Technologies & Services: JSP, XML, HTML, CSS, Javascript

RDBMS: Oracle 10g, Oracle 11g, SQL Server and MYSQL

Development tools: Eclipse 3.2, PL/SQL Developer, NetBeans, ANT, SOAP UI

Application Servers: JBoss, WebLogic, WebSphere

Scripting: Java Scripting, Linux/Unix Shell Scripting

Operating Systems: Ubuntu, CHD3, CHD5, Sun Solaris 10, Windows XP/7/8/10, Linux, Unix

Microsoft Office Suite: MS Word/Excel/PowerPoint/Outlook

Methodologies Used: Agile (Scrum), Waterfall, Cosmic Estimation

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Informatica MDM Consultant

Responsibilities:

  • Installation and Configuration of Informatica MDM Hub Server, Cleanse Server, Resource Kit, IDD, Cleanse adapter and ActiveVOS BPM.
  • Created and configured landing tables, Base Objects, Staging tables, mappings and transformations as per business requirements.
  • Created External Batches working with ETL Developers to execute mappings to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
  • Upgraded MDM from 9.7.1 to MDM 10.2 in Sandbox, DEV, QA and PROD environments.
  • Configured Address Doctor before running the stage job and mapping with different cleanse functions.
  • Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
  • Involved in designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
  • Configured lookups, foreign-key relationships, queries/custom queries, query groups, and packages in MDM.
  • Configured entity types and relationship types and configured hierarchy system tables and user defined tables.
  • Configured match rules, match rule sets, match columns and match paths according to the requirement.
  • Configured Active VOS BPM with MDM IDD for One Step Approval Workflow process for Product (style hierarchy) approval by Managers/Data Steward team.
  • Defined the Trust and Validation rules and setting up the auto match/merge rule sets to get the right master records (BVT).
  • Configured match rule set property by enabling search by rules in MDM according to Business Rules.
  • Executed Informatica MDM batch processing.
  • Configuring IDD increased performance and improved convenience for business users.
  • Integrated SIF and configured SoapUI code for API calls to access hub data.
  • Developed Java code for SIF and User Exits.
  • Developed XML scripts in SoapUI for cleaning staging tables and base objects as and when required.

Environment: s: Informatica MDM 10.1, Oracle 11g, Informatica Power Center/Analyst 9.5.1, IBM PureData for Analytics (Netezza), Ansi SQL, Address Doctor, WebLogic, SOAP UI, Eclipse, Java 1.7 45+, Linux and Windows.

Confidential, Houston, TX

Informatica MDM Consultant

Responsibilities:

  • Gathered business requirements for the MDM HUB configuration.
  • Created and configured the foreign key relationships, Base objects, Staging tables, lookups, queries, packages and query groups.
  • Performed MDM Hub Store, Cleanse Server, IDD Applications upgrade from 9.7 to 10.1 HF5
  • Implemented the Land Process of loading the customer Data Set into Informatica MDM Hub's Landing tables.
  • 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.
  • Worked on data cleansing and standardization using the cleanse 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 rule set property by enabling search by rules in MDM according to Business Rules.
  • Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
  • Reviewed all the supporting tables whenever required for change tracking of the data.
  • Configured Supply Chain IDD Application for use by Data Stewards.
  • Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre-prod and prod environment.
  • Configured Subject Area Groups for Supplier, Manufacture, Product and Contract.
  • Created mappings using Informatica Designer, Sessions & Workflows using Workflow Manager.
  • Design, document and configure the Informatica MDM Hub to support loading, matching, merging, and publication of MDM data.
  • Installed and configured Hub, Cleanse server, JBOSS, Address Doctor on Production.
  • Worked with ETL team to schedule Batch Groups for all the domains and are called via ETL workflows which calls corresponding MDM SIF API’s.
  • High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role.
  • Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica Multi-domain MDM 10.1, IDD, Erwin, Address Doctor 5, IBM PureData for Analytics (Netezza), Ansi SQL, SQL Server 2012, SOAP UI 5.0.0

Confidential, Atlanta, GA

Informatica MDM Consultant

Responsibilities:

  • Designed and created BO, staging tables, mappings, transformations as per business requirements.
  • Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
  • Provide Project Plan for Power Center upgrade from 9.6 to 10.1(Parallel Upgrade) and Informatica MDM upgrade from 9.7 to 10.1
  • Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
  • Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
  • Identified Golden Record (BVT) for Customer Data by analyzing the data and duplicate records coming from different source systems.
  • Helped the testing team for data integrity and consistency.
  • 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.
  • Guided the testing team and review test case designs and test cases for MDM upgrade.
  • Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
  • 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.
  • Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries.
  • Configured match rule set property by enabling search by rules in MDM according to Business Rules.
  • Created mappings using Informatica Power center and loading data into pre-landing tables.
  • Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica MDM 10.1, SOAP UI 5, SQL Server, Microsoft SQL Server Management Studio, Eclipse, JBoss 6.4, Power Centre, Unix, IDD

Confidential

ETL Informatica Administrator

Responsibilities:

  • Single handedly managing entire organization’s Extract - Transform - Load (ETL) implementation to log failures, resolve load fails and ensure data for each day is captured in the required database table partition (24x7 role).
  • Responsible for extensive analysis of Informatica session logs, identifying performance bottlenecks and tuning ETL mappings, workflows to improve overall ETL performance.
  • Responsible for complete scheduling of Informatica jobs 24x7 and maintaining the order of jobs and their dependencies.
  • Identified missing constraints on tables (not null, primary keys, unique constraints, etc.) and added the same where required.
  • Ensuring each day’s flat files are processed before the next day’s files start getting processed into datawarehouse.
  • Responsible for bringing Informatica loads back to normal after scheduled organization wide outages.
  • Setup email functionality in Informatica 9.5.0 to send out notifications to users in case of job failures.
  • Hands-on experience in patching OBIEE 11.1.1.7.13 .1.1.7.141014 and tested the resulting BI System. Extremely confident in patching OBIEE older versions to latest releases using OPatch.
  • Triggered Informatica loads to capture stats of queries made on different music apps.
  • Monitored jobs continuously to ensure data for each day is captured in the required database table partition.
  • Identified gaps in Informatica logic to classify all source data into the required category and modify logic according to business process.
  • Maintain contact with Oracle for design issues, especially pushing Oracle to provide one-off patches for OBIEE design bugs that would normally be set aside as enhancement requests and dealt with in future versions.

Environment: Informatica Power Center 9.5/9.6.1, Power Exchange, Oracle11g, MS Access, UNIX Shell Scripts, Windows 10, SQL Server 2012.

Hire Now