SUMMARY:

• A senior Informatica MDM, IDD, SIF, User Exits, Hierarchy manager Developer with very strong professional background in Investment Banking and finance domain and over 10 + years of industry experience in the software engineering, processes and methodologies, and management.
• Expertise and working experience in establishing the process, methodology standards at all phases of an Enterprise Data ware - house.
• Ability to work in a fast paced environment and willingness to stretch and achieve aggressive goals.
• 8 + years of experience in Informatica MDM, Informatica power center ETL Development.
• Expertise in Installing and Managing Informatica MDM, Metadata Manager and Informatica Data Quality, Informatica power center.
• Experience in code deployment of Informatica MDM. Coordination with Developers and Domain experts Building Business Glossary, Traceability and Data Lineage in Metadata Repository.
• Experience in Informatica MDM Installation, Upgrade, BugFix and Migration of data.
• Involved in the full development lifecycle from requirements gathering through development and support using Informatica MDM, Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor. Experience working in complex, cross-functional and geographically dispersed team environments.
• Strong experience in Development of Informatica MDM on UNIX/Windows, Migration of repositories, and up gradation of repositories. Professional Experience in ETL Architecture using Informatica MDM 9.1/10.1.
• Experience in Designing and developing mappings from various transformation logics like, Source Qualifier, Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Union, Joiner, Transaction Control and Update Strategy.
• Experience in overall Big Data (HADOOP) processes and architecture, performed build, tested and deployed activities related to Big Data implementations.
• Knowledge of Big data systems including Hadoop, HDP components, HDFS, Hive, Pig, Amazon Web services, Ambari Clustering, Ranger security policies, Yarn, Oozie, Zookeper, and Map reduce2.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, transformations and sessions
• Over 5+ years of strong Data Warehousing experience usingInformatica MDM (Mapplets, Source Analyzer, Mapping Designer, Transformations).
• Extensive experience in the areas of Data Warehouse, ETL (extraction, transformation and loading), BI (Business Intelligence) and related areas.
• Designed, developed and tested complex ETL workflows and related processes.
• Experience in Installation of Informatica MDM 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
• 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

TECHNICAL SKILLS:

EIM Tools: Informatica MDM Multi-Domain, IDD, SIF

Application Server: Jboss, Weblogic, ISS 8

Project Planning: Microsoft Project Plan

Languages: Shell Scripting (K-Shell, C-Shell), PL/SQL

Databases: Oracle11g/10g/9i/8i/7x, SQL Server Integration Services (SSIS), DB2,UDB 7.2, My SQL 5.0/4.1, MS Access 2003/2000/97/7.0. Editors ( SQL Navigator, Toad)

Operating Systems: UNIX, HP, Sun Solaris 2.x/7/8, Windows 7/XP/2000/98,Win NT

ETL: Informatica Power center 9.x/8.x/7.x

Data Modeling: ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables, Normalization, Denormalization.

Reporting Tools: Business Objects XI, Crystal Reports 10, Crystal Reports 2008

PROJECT EXPERIENCE:

Confidential, North Carolina,USA

Informatica MDM Developer and lead

Responsibilities:

• 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
• Supporting role towards Business Analyst and Team lead in requirement phase, peer review and preparing high level design.
• Developed the code based on Low level design - includes more detail information tables, database and data flow.
• Created ETL jobs and mappings with the help of Informatica power center to integrate the data from different hetrogeneous sources like flat files, csvs, ms sql database, oracle database.
• Development include two crucial jobs - Pre-landing job and Landing job in ETL. Jobs perform pass through mappings for moving data from staging to landing tables.
• MDM development includes creating Base object tables, staging tables and landing tables as per requirement in LLD.
• Created individual mappings (i.e. Stage jobs) for moving data from landing table to staging tables. Staging tables are like raw table, history records, prl table - Delta detection(Incremental) and reject table.
• Configuring the trust and validation in base object columns as per business requirement.
• Ran the load jobs for moving data from Staging tables to base object tables. Base object tables more like Bo tables, xref tables history tables etc.
• Configured Trust and created Queries & package to integrate the Turst score.
• Involved in creating various Match rules. Two match rules, Fuzzy match will be set based on token known as tokenization and Exact match will give exact record information.
• Also configured many merge rules (Auto merge and Manual merge). However we had data stewards who will handle the manual merge activity by manual intervention.
• Published the records to downstream applications with help of ETL power center with the help of message queue.
• Configured IDD for client usage on web application. Clients can access the master record and update the information directly in base object.
• Setup SIF for java application communication and interfacing the IDD as required.
• Created User exit features extending the functionality and features of MDM HUB.
• Design and development test scenarios for unit and integration testing, as well as positive and negative testing and generating the test data as per test cases.
• Preparation of test cases and code review document, debugging the defects identified and fixing them
• Updating the code into production with proper version.
• Preparing UTC document, Analysing the existing code, modification towards the codes.
• Working with informatica MDM mappings, work flows and dataflows and interacting with hadoop hive.

Environment: Informatica Multidomain MDM 9.5.0, JBoss 5.1, Oracle 11g R2, Address Doctor 5, IDD, SIF, Toad, SQL*Loader, Windows Server 2008

Confidential

Informatica MDM Developer

Responsibilities:

• Produced detailedMDMdesign specifications consistent with the high-levelMDMdesign specifications.
• Coordinated with ETL team for performing batch process to populate data from external source systems to landing tables in theMDMhub.
• Analyzed the source systems data for identifying integrity issues and incorporated the same in Systems and Trust.
• Configured Landing, staging tables and Base Objects.
• Design, document and configure the InformaticaMDMHub to support loading, cleansing of data.
• Worked on data cleansing and standardization using the cleanse functions in InformaticaMDM.
• Defined Match rules in Match and Merge settings of the base tables by creating Match Path Components, Match Columns and Rule sets.
• Configured match rule set property by enabling search by rules inMDMaccording to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness ofMDMon data.
• Created static lookups, dynamic lookups, queries, packages and query groups.
• Customized User Exists for various scenarios.
• Used Hierarchy tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles.
• Developed extensions and customizations to the services (SIF) tier of InformaticaMDMHub.
• Created roles, users for roles, and assigned privileges to roles using Security Access Manager.
• Performed import and export of metadata and promote incremental changes between environments from development to testing phase.
• Extensively worked on Informatica Power Center, InformaticaDeveloper, DB2 and XML files.
• Maintained data matching logic and Address Doctor dictionaries.
• Exported IDQ mappings (plans) to power center as mapplets.
• Created Rules on profiled data and used the same to data quality mappings.
• Provided reports for data matching on pattern analysis and provide insight to data quality errors.
• Developed framework for staging environment to handle the transactions efficiently. Made sure that the staging environment supports all kinds of downstream requirements by designing it to handle the records with various status messages.
• Documented all the mapping logics and all interfaces requirements both in functional and technical level and uploaded to share point portal to achieve smooth production support.
• Document the business requirements for the Cognos BI reports and derive Cognos report requirements from already existing report templates.
• Trained other teams in the organization on using B2B transformation with XMap service and decoding the complex WSDLs.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management ofMDMdata.
• Responsible for creating user groups, privileges and roles to the users using Security Access Manager.
• Deployed newMDMHub for portals in conjunction with user interface on IDD application.
• Worked on integrating Hierarchies created inMDMHub Console and IDD.
• High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role
• Implemented Search feature, Add/Update feature and Task Assignment feature in IDD for Admin user.
• Implemented Post Landing, Pre-Staging, Save Handler User Exits using Eclipse Mars and integrated those user exits withMDMHub Console using User Object Registry module.
• 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).
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management ofMDMdata.
• Performed GAP analysis on priorMDMsolution including the data model and the user interface

Environment: Informatica MDM Hub 9.1, Web logic, Address Doctor, Oracle 11g, MS Visio 2010, Windows XP, T-SQL, Toad

Confidential

ETL Developer

Responsibilities:

• Worked on Informatica Power Center 9.1 tool - Source Analyzer, Data Warehousing designer, Mapping &Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance.
• Participated in deployment planning and in deployment of the system to production
• Facilitated business user smoke testing of the production system by setting up test data.
• Involved in production support duties including monitoring of nightly batches.
• Responsible for updating business stakeholders and OLTP/OLAP application support teams about the status of various ETL sessions and the impact of failed sessions on data availability.
• Responsible for debugging failed ETL sessions and taking steps to mitigate impact to business users.
• Extensively used informatica Informatica Data Quality tool (IDQ Developer) to create rule based data validations for profiling
• Created dictionary tables using IDQ analyst tool for data validations
• Implemented B2B informatica parsers to convert PDF documents to XMLs through Informatica
• Involved in code review sessions to bring the team’s attention to best practices and to identify areas of improvement.
• Responsible for implementing action items identified during code review sessions focused towards improving data quality and performance.
• Involved in performance tuning of sessions that work with large sets of data by tweaking block size, data cache size, sequence buffer length and target based commit intervals.
• Developed sessions and batches to move data at specific intervals and on demand using workflow manager.
• Worked on different modules of the project for successful execution
• Have created / developed different types of profiles like Column level profiling, Summary profiles, drill down profiles, Score cards, reports etc. using IDE.
• Have created Match, and Merge rules, developed address validations etc. and developed address validations to countries like US, and also developed reusable error handling rules using IDQ.

Environment: Informatica power center 8.6/7.X, IDQ Developer, Oracle 11g, PL/SQl,Toad, DB, UNIX, Informatica B2B, Windows,SQl.