EXPERIENCE SUMMARY:

• Informatica Certified in MDM Hub with about 5 years of IT experience in Informatica MDM, Power Center, IDD, IDQ, Active VOS, Oracle, SQL, Software Development Life Cycle (SDLC) analysis, design, development, testing, maintenance and quality assurance
• Experience in Master Data Management concepts, methodologies and ability to apply this knowledge in building MDM solutions.
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian)
• Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation
• Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects
• Experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign key relationships, lookups, query groups, queries/custom queries and packages.
• Rendering experience in Designing & developing multiple cleansing and standardization scenarios usingAddress Doctor and Trillium
• Expertise in creatingIDDapplication as per the business needs and Bulk Import integration by creating the subject area and subject area groups
• Expertise ImplementingHierarchy ManagerModule in addition to Match/Merge/ Unmerge which aids in depicting various hierarchies
• Worked with SIF API to interact with real time applications
• Experience in designingmappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
• Experience in designing and developing Informatica mappings for data loads that include Source Qualifier, Aggregator, Unconnected Lookup, Connected Lookup, Filter, Router, Update Strategy etc.
• Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica server
• Installed and Configured Smart Search in all the environments
• Enabled Searchable columns as per the business need
• Oracle 11g (Database set - up, installation and configuration, environment creation) and PL/SQL development Experience in Agile, Waterfall and UML Methodologies
• Good Exposure to development, testing, debugging, implementation, documentation and production support
• Responsible for ongoing support of existing application

TECHNICAL SKILLS:

EIM Tools: Informatica MDM 10.2/10.1, IDD, SIF, IDQ, Informatica power center,Active VOS, Provisioning Tool.

Languages: SQL, C#, C++, HTML, XML, .Net, Python, Java

Databases: Oracle 12c/11g/10g, MySQL, SQL Server 2016 R2, Microsoft Access

OS: Windows (Windows NT/2000/XP Professional), Unix, Linux, Mac OSX

Servers: JBoss 6.4, WebLogic

PROFESSIONAL EXPERIENCE:

INFORMATICA MDM DEVELOPER

Confidential, AZ

RESPONSIBILITIES:

• Successfully upgraded MDM from 9.7.1 HF5 to MDM 10.2 HF2
• Solved high priority address issues in the production by modifying existing Address Doctor mapping.
• Analyzed and Participated in cleanup of data and developed new functions to be used in mapping.
• Added new source systems by creating new landing tables, Base Objects, staging tables, mappings, Batch group, cleanse functions by analyzing requirement specifications and participated in Business meetings to capture the Business requirements for effective implementation
• Fixed various IDD issues like match and merge, IDD search results etc.
• Implemented IDD Bulk Import functionality for importing data via Excel into MDM. Developed Excel VBA code for Import Template that makes less work for Business while entering data in excel.
• Implemented SIF API’s in Post Load Hub User Exits for Bulk Import where Creator column was updated by data in excel.
• Implemented new child and grandchild to existing IDD applications and implemented SIF API’s in IDD User Exits for various business scenarios.
• Worked on various IDD User Exits and hub cleanse functions and displayed error/warning messages and performed backend related processes.
• Attended Business meetings and suggested MDM solutions for various Business scenarios.
• Created a new manual match rule and Oracle script for a Business scenario where records were added to IDD merge queue on a certain condition.
• Developed an Oracle stored procedure to get the latest golden record for use by Business.

Environment: Informatica Multidomain MDM 10.2 HF1, Oracle 11g, SQL Developer, IDD, Toad, Erwin, Eclipse Kepler Service Release 2, Jasper Studio.

INFORMATICA MDM DEVELOPER

Confidential, Minneapolis, MN

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
• 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 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
• 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, Oracle 11g, Management Studio, Eclipse, JBoss 6.4, Power Centre, Unix, IDD.

INFORMATICA MDM DEVELOPER

Confidential

RESPONSIBILITIES:

• Integrated Customer data from different sources to create a Customer Master Data to get best version of truth as golden record
• Successfully completed the Hub configuration phase to deployment of the project.
• Defined standard interfaces, Data Profile, metadata acquisition, data migration, validation, pre-landing processing and Reference Entities
• Defined the landing tables, staging tables, and configured base objects
• Defined foreign-key relationships, lookups, query groups and queries
• 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.
• 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.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• 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.
• Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.

Environment: Informatica Multidomain MDM 10.1, Informatica Power Center 9.6.1, Informatica Data Quality 9.6.1, Web logic 12c, Oracle 11g, SQL Developer, Service Now, App works, Perforce

ORACLE DEVELOPER

Confidential

RESPONSIBILITIES:

• Actively participates in cross-functional feature teams, which may include Architecture, Development, Quality Assurance, Product Management, Project Management, and Hosting Infrastructure & Operations team members
• Designs, develops and tunes PL/SQL in our high-volume database environment
• Adds new and refactors existing ETL data warehouse processes
• Analyzes and resolves complex technical issues for Tier 3 Production Support of Oracle databases and PL/SQL in support of ETL batch processes
• Communicates effectively with business leaders project progress, status and roadblocks
• Works with remote teams in different time zones or on different continents
• Passionately seeks continuous process improvement
• Experience designing and developing SQL
• Understanding of diverse software engineering methodologies, such as agile, waterfall and iterative
• Experience with UNIX command line and shell scripting
• Willingness to learn, develop, and contribute in a fun, fast-paced team environment
• Energetic and passionate self-starter who brings interpersonal skills and creative problem-solving skills to the team
• Excellent written and verbal communication skills, including the ability to produce communication that is easily consumable by the target audience
• Considers success from the team perspective by committing and holding yourself and others accountable
• Experience in school or current job with RDBMS
• Experience in a 11g Oracle Development environment

Environments: Oracle 11g, SQL Developer.