Informatica Consultant Resume
NY
SUMMARY
- Over 8+ years of industry experience and 8+ years of experience in Master Data Management, Data Integration, Data Quality, TDM and Business Intelligence Applications
- Expertise on complete life cycle implementation of projects using Informatica Power Center, Data Quality and Informatica MDM, IDD
- Extensive experience in Identification of User requirements, System Design, writing Program specifications, Coding, Implementation and Testing of EIM Systems
- Installation, cluster set - up, upgradation and configuration of the below components:
- Informatica MDM Components
- Configuration of Address Doctor
- Informatica Power Center and Data Quality Components (DQ Content and DQ Accelerator)
- Experienced in all facets of MDM implementationsincluding Data Profiling, metadata acquisition, data migration, validation, reject processing and pre-landing processing
- Experienced in defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages
- Designed & developed multiple cleansing and standardization scenarios using Address Doctor
- Implemented Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies
- Creating IDD application as per the business needs by creating the subject area and subject area groups
- Developing Put and Display packages for both Hierarchy Manager and IDD Application
- Practical experience in using SIF APIs such as Get, SearchQuery, CleansePut, SearchMatch, Merge and Unmerge to develop complex application to communicate with Hub Server and process the data from Base Object.
- Experience working on standardization of data, Data Analysis & Profiling, Data cleansing, validating data using Business Rules, Parsing, Improving the data quality by eliminating the redundant data, Standardization &Merging, Natural Language Processing.
- Data profiling, specifying and validating rules (Scorecards), and monitoring data quality using the Informatica Analyst tool.
- Extensively involved in ETL Data warehousing using Informatica PowerCenter Developer tool, Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
- Broadly worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
- Strong experience in working with different RDBMS as Oracle, Teradata, MS SQL Server, DB2 UDB
- Exceptional knowledge of dimensional modeling, Data warehousing concepts, Ralph Kimball and Bill Inmon Methodologies, Star and Snowflake schemas
- Very good in Debugging, Optimizing and Performance Tuning of Informatica Applications
- Ability to translate functional specifications into detailed technical design specification
- Excellent communication and interpersonal skills. Have interacted and communicated with end user on a day to day basis for requirements gathering and user training
- Expert in providing End User Training in Informatica MDM, IDQ applications.
TECHNICAL SKILLS
EIM: Informatica MDM 10.2/10.1/9.7.1 , IDD, SIF, IDQ
Application Servers: JBoss 6.1/6.2/6.4, WebLogic
BPM Tools: ActiveVOS
Data Modeling Tools: CA Erwin Workgroup Editions
ETL: Informatica Power Center 10.1/9.6/9.5/8.6
Scheduling Tools: Control M, Autosys
Languages: SQL/PL SQL, HTML
RDBMS: Oracle 11g/10g/9i/8i, (SQL), MS SQL Server 2012/2008/2000/2005 , Teradata and DB2 UDB
OS: Windows 2016/2012/2008 , RHEL 6, UNIX 5.3/6.1 and Sun Solaris
PROFESSIONAL EXPERIENCE
Confidential, NY
Informatica Consultant
Responsibilities:
- Assessment of current environment to understand infrastructure, internal and external connections
- Provide Project Plan for Power Center upgrade from 9.6 to 10.1(Parallel Upgrade)
- Cross check PAM document for certified and supported versions software’s
- Provided external applications latest version to install / upgrade in the current environments
- Backup the current repositories, restore and Upgrade
- Configure the Application Services, Connections, Security
- Created a training document on 10.1 New Features - new Managed File Transfer, Admin Console, Scheduler Service
Environment: Informatica Power Center 9.6.1/10.1, Informatica MDM 9.7/10.2, JBoss 6.4, Oracle 11g, Informatica Data Quality 9.6.1 Windows Server 2012, Java 1.7 45+
Confidential, MN
MDM Consultant
Responsibilities:
- Worked with Architect in performing Data Model review and did changes to suit the business
- Configured Data Model in MDM hub and defined relationships and lookup values
- Created Base objects, staging tables, landing tables and defined foreign key relationships among the base objects and Hierarchy setup for all the Well data.
- Defined the MDM Development Methodology and performed Match and Merge Rules after a detailed analysis of different source data.
- Created Match Paths, Match Columns for Match and Merge Process.
- Defined Search Strategy and Rules using Match Rule Sets for Match and Merge Process for complex scenarios.
- Performed Data Steward Activities like manual Merge/Unmerge and updating data.
- Created subject area groups, subject areas, subject area child, IDD display packages and search queries.
- Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to different environments.
- Provided training to various business users on the product and how to use the IDD and other required needs
- Installation and Configuration of Oracle Database on Linux Platform
- Creation of Hub Store by creating tables spaces, creating schemas and importing metadata
- Installation and configuration of JBOSS
- Installation of MDM 9.7 and importing the hub, IDD configurations
- Run the readiness script preparing for upgrade
- Upgrade Master and ORS databases by running the scripts
- Upgrade Hub, Cleanse server to the latest version
- Resolve Post Upgrade issues
- Validate all the applications making sure working as expected
Environment: Informatica MDM 9.7.1, Oracle 11g, Address Doctor, Informatica Power Center/Analyst 9.5.1, OBIEE 11.1.1.7.0 , Weblogic, JBOSS, Java 1.7 45+, Linux and Windows
Confidential, Time Square, NY
MDM consultant/ Admin
Responsibilities:
- Installed Informatica MDM 9.7.1 in SQL Server in Sand Box environment
- Applied hotfix 2,3 for Informatica MDM 9.7.1 in SQL environment
- Worked with business team for new requirements and enhancements to existing requirements
- Worked on all MDM Admin activities like creating data sources, creating users, creating roles, promoting the code to all non-Production environments, applying hot fixes/patches to the environment in all non-Production environments
- Defined and developed the ETL process to load the data into the landing tables during the land process using Informatica Power Center
- Configured the Automation process for Land, Stage and Load Process (Batch Group Process)
- Completed 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
- Worked on Security Access Manager (SAM) for creating roles and assigning users
- Created and Implemented IDD applicationto search Devices by creating subject area groups, subject areas, subject area child
- Created manual merge tasks for Data stewards and managers for managing manual merge tasks
- Created MDM query’s and stored procedures for IDD application
- Worked on all production issues in MDM and IDD
- Worked on all administration issues in Production and Non-Production environments
- Worked on Repository manager to migrate the code between Dev to QA or QA to Prod environments
Environment: Informatica MDM Multi-domain 9.7.1, JBoss EAP 6.1, Informatica Power center 9.1, SQL Server, Redwood Scheduler
Confidential
MDM Developer
Responsibilities:
- Create the Master and ORS Database on Oracle database
- Configure the WebSphere by adding parameters to JVM arguments and to support IDD
- Install the Hub Server on both boxes without running the Post Install Script
- Configure the configuration files to replicate the Cluster environment
- Manually create Buses, JMS Providers, Queues, Data sources for schemas, connection factories and test on the app server and restart app server
- Repackage the and Deploy the hub server ear file on the nodes
- Install cleanse server and manually deploy the ear files and start the servers
- Register the databases and process servers
- Validate hub console and IDD logins
- Configure LDAP for authentication
- Product Demo, POC and Solution Recommendation for tracking Absences
- Successfully 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
- Implemented the approval process by enabling and disabling the buttons for subject areas in IDD, according to business rules and requirements
- Supported the IDD applications and resolved issues faced by the users
Environment: Informatica MDM 9.7.1, Oracle 11g, OBIEE 11.1.1.7.0 RHEL 6, Java 1.7 45+
Confidential
ETL developer
Responsibilities:
- Designing, developing and testing Different Mappings according to Requirements.
- Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Lookup, Sequence generator, Router and Joiner.
- Designed mappings for slowly changing type-1 and type-2 dimensions.
- Written complex SQL queries to pull the data from application systems to load fact tables.
- Created sessions and workflows to load and test the dimensions and fact tables.
- Created native and ODBC connections to connect to source and target databases.
- Prepared ETL mapping documents and unit test documents.
- Created and scheduled Workflows, Configured email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
- Involved in code reviews and peer reviews.
- Involved in User testing in getting approval for ETL CUT.
- Implemented SDLC process to push the code onto higher environments.