SUMMARY

• 6+ years of IT experience and wide range of experience in software development, Architecture, Design, Data Integration, Data Warehousing, Business Intelligence, Master Data Management and Quality assurance.
• 4+ years of experience in Informatica MDM (Siperian) Hub, Hierarchy Manager, Informatica Data Director, designing of Cleanse functions and Match rules, MDM User Exits.
• 2+ years of experience in ETL Data Warehousing, Informatica PowerCenter 7.x/8.x/9.x, Transformations, designing ETL mappings and workflows.
• MDM Developer with experience in implementing, development, maintenance and troubleshooting on Informatica MDM solutions, Metadata Management, data quality, data integration.
• Good understanding in entity relationship and Data Models.
• Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD &Data Modeling.
• Experience in consulting, strategy formulation, direction setting, defining data governance and Stewardship processes for MDM solutions.
• Extensive experience in Informatica Designer to create complex mappings using different Transformations to move data to a Data Warehouse
• Experience in integration of various data sources like Oracle, SQL server and MS access, flat files, and XML files.
• Proficient in building ETL interfaces using Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Administrator and Central Management Console.
• Experience in designing ETL landscape and architecture, functional and technical design specifications, Data Modelling, Operational Data Store design, Star schema and Snowflake schema.
• Expertise in writing Oracle PL/SQL Stored Procedures/Functions/Packages and cursors Triggers.
• SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by creating Explain Plan, SQL hints for query and indexing the required columns.
• Develop, execute ETL test plans, Document ETL processing and generate required metadata.
• Experience with UNIX commands, VI editor and writing Shell scripts.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS

Software/Tools: Informatica MDM 9.1/9.5, Informatica Power Center

RDBMS: Oracle 11g/9i/8i, SQL, MySQL, PL/SQL developer10.0.3, Sybase 11.1, MSSQL Server 2008,,2012

Operating Systems: Windows Server, Red hat Linux

Languages: C, Basic Java, Shell scripting

Performance Simulator: HP Load Runner

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Informatica MDM Developer

Responsibilities:

• Informatica MDM Hub Console development.
• Design and create BO, staging/landing tables, mappings, transformations.
• Coordinate MDM program activities for the Member and Provider data domains.
• Conduct source system analysis, and data profiling for lifecycle management.
• Define measurable metrics and the minimal required attributes for each domain or subject area to support a robust and successful deployment of a MDM platform.
• Define requirements for data matching and merging rules, survivorship criteria and data stewardship workflows that can be deployed in the endorsed MDM tool.
• Thorough understanding of deterministic and probabilistic matching methodologies and master data hierarchy management.
• Collaborate with the Enterprise Architecture teams (data integration, data architecture, business intelligence) to develop and deliver MDM solutions.
• Work with Architecture Review Board and Change Approval Board for technical reviews and approvals through the system development life cycle.
• Lead the service module starting from requirement gathering, design, development using Service Integration framework.
• Use the Schema tool to configure a consolidated data model, including relationships.
• Configure landing and staging tables.
• Test mappings and run staging jobs.
• Configure Trust Rules.
• Configure/Run LOAD jobs .
• Define match columns for fuzzy and exact match/Define match rules/Configure merge settings.
• Identify user exits for the Stage, Load, Match, Merge and Unmerge processes as well as other user exits.
• Use cleanse functions, constants and conditional execution components to build mappings and re-usable cleanse components.
• Configure delta detection and audit trail settings.
• Updating the IDD and Hub design documents.
• Provided Assistance to QA and Testing team for testing.

Environment: Informatica MDM 9.7.1, Informatica PowerCenter 9.x, Oracle 10g, PL/SQL, SQL*Plus, XML, JBoss Application Server

Confidential, Savannah, GA

Informatica MDM Developer

Responsibilities:

• Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development, QA, Pre-Prod and Prod Environments.
• Created various Landing tables, staging tables, base objects.
• Developed Mappings between landing and staging tables.
• Loaded data in to landing tables.
• 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.
• Used the entity types as subject areas in IDD.
• 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.
• Designing, Implemented the Inbound & Outbound interfaces to send data to MDM System to the sources.
• Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to Dev, QA, Pre-prod and prod environment.

Environment: Informatica MDM 9.6, Informatica PowerCenter 9.x, Oracle 10g, PL/SQL, SQL*Plus, XML, Java, JBoss Application Server

Confidential, Memphis, TN

Informatica MDM Developer

Responsibilities:

• Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development, QA, Pre-Prod and Prod Environments.
• Involved in gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.
• Used Informatica Power Center for loading data into landing tables
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• 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 on data.
• Created Unit Test Case document.

Environment: Informatica MDM 9.1.0, Informatica PowerCenter 9.x, Oracle 10g, PL/SQL, SQL*Plus, XML, Java, JBoss Application Server

Confidential, Portland, OR

Informatica Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 8.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor), SQL, PL/SQL

Confidential

Informatica ETL Developer

Responsibilities:

• Understand the functional / Business requirement.
• Create mappings/sessions/workflows as per the design.
• ETL Tuning - SQL, Stored Procedures, Informatica Mappings to meet the SLA's.
• Created Informatica mappings using Source Qualifier, Expression, Lookup, Aggregate, Update Strategy, Joiner, Normalizer, XML transformations and Filter transformations.
• Developed Mapplets and Transformations
• Identifying and Removing Bottlenecks in order to improve the performance of Mappings and Workflows
• Worked on creating the UNIX shell scripts, scheduling the sequence of jobs in batches.
• Create the Unit test documents and perform unit testing.
• SIT/UAT support.

Environment: Informatica Power Center 8.6, Oracle 10g/9i, UNIX, SQL, PL/SQL