EXPERIENCE SUMMARY:

• Over 6 years of IT experience in Software Development Life Cycle (SDLC) analysis, design, development, testing, maintenance and quality assurance with implementation of software applications in MDM.
• Over 4+ years of experience working in Informatica Master Data Management (MDM) Developer.
• 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.
• 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
• Helping business to understand the Match rules configuration and decide the trust factor and Configure match/merge rules
• Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects
• Rendering experience in Designing & developing multiple cleansing and standardization scenarios using Address Doctor
• Expertise in Implementing Hierarchy Manager Module in addition to Match/Merge/Unmerge which aids in depicting various hierarchies
• Worked with SIF API to interact with real time applications
• Experience in designing mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
• Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica server
• Experience in Testing with ETL Tools - SSIS/SQL Server - BI and Reporting.
• Experience on ETL design, development and unit testing estimations based on business requirements
• Enabled Searchable columns as per the business need
• Good Exposure to development, testing, debugging, implementation, documentation and production support
• Responsible for unit testing of the work done.
• Used SQL*Plus to perform DML operations for small updates.
• Excellent communication and interpersonal skills and an attitude to learn the new cutting-edge technologies.
• Ability to quickly analyze and come-up with an efficient industry standard solution for a given problem

TECHNICAL SKILLS:

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

Languages: JavaScript, JSP, SQL, C#, C++, HTML, XML, and .Net

Testing Tools: JIRA, HP Quality Center, QTP, Bugzilla

Frameworks: AngularJS, J2EE

Databases: Oracle 11g/10g, MySQL, Database SQL command

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

Servers: JBoss 6.4, WebSphere (WAS), Tomcat

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Informatica MDM Developer

Environment: Informatica MDM Multi-domain 9.7.1, JBoss EAP 6.1, Informatica Power center 9.1, SQL Server, Redwood Scheduler

Responsibilities:

• Designed, Installed, configured core Informatica Master Data Management (MDM) Hub components such as Informatica Master Data Management (MDM) Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter & Data Modeling.
• Designed the Data Model, Landing Table, & Staging Tables and configured base objects.
• Configured batch jobs using batch group utility.
• Created the Master Data Management (MDM) Hub Console configurations like Stage Process configuration, Load Process Configuration.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined Trust and Validation rules and Configured Match Set Rules for getting the matches in order to eliminate the duplicate records.
• Expertise in creating Mappings.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Configuration and creation of landing and staging tables for newly added sources.
• Added new sources to the existing MDM implementation.
• Create mappings to load data in to the staging tables.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Good understanding in entity relationship and Data Models.
• Developed Hierarchies using Hierarchy Manager in the Hub as per the needs.
• Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file.
• Implemented cleansing functions such as pre-defined functions (STRING Functions, Logic Functions, Math Functions, Data Conversion Functions) for effective consistent master data records.
• Developed Informatica Data Director (IDD) applications and queries used for Data Steward Analysis.
• Created Queries & Packages to view the data in IDD, Data Manager or Merge Manager.
• Preparing the test plan and test strategies for ETL application
• Exposure to Testing Life cycle and understand end-to-end data validation for ETL & BI systems
• Experience in SQL Database and ETL testing and working with Business Intelligence environment

Confidential, Houston, TX

Informatica MDM Developer

Environment: Informatica MDM Multi-domain 10.2, JBoss EAP 6.4, Oracle.

Responsibilities:

• Worked on staging and loading process using the batch viewer for initial and adhoc loads.
• Created base objects, staging tables, landing tables and defined foreign key relationships among the base objects and Hierarchy setup for all the data.
• Defined the Foreign Key relationships and provided lookup information for the columns in the staging tables .
• Configured Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match/Merge and cascading unmerge Process.
• Created Match Paths, Match Columns for Match and Merge Process.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• 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.
• Modified few match rules based on performance.
• Loaded the data into the landing tables using SQL scripts and used the batch viewer to run the Stage and Load process.
• Data governance application for Informatica MDM Hub that enables business users to effectively create, manage, consume and monitor master data using IDD (Informatica Data Director).
• Developed IDD applications for different business teams with different requirements
• Configured hierarchies and relationships for Assets, Customers, Entities, Financial Entities and product domains
• Created subject area groups, subject areas, subject area child, IDD display packages and search queries.
• Performed Unit Testing, worked with Quality team on System Testing.
• Created MDM query’s and packages for IDD application.

Confidential

Informatica MDM Developer

Environment: Informatica Multi Domain MDM 9.5, PL/SQL, Oracle 10g

Responsibilities:

• Using Informatica MDM suite of tools - design, develop, optimize and support MDM processes, including performance tuning of existing processes
• Work is performed in a typical office environment
• Define, configure and optimize various MDM processes including landing, staging, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries, cleanse functions, batch groups and packages using Informatica MDM
• Define, configure and optimize various MDM processes and stages including data ingestion/acquisition, standardization/enrichment, and data provisioning using MDM tools
• Created document with MDM data model, source system definition, data mapping and cleansing requirements, trust score and matching rule definitions.
• Worked with data steward team for designing, documenting and configuring Informatica Data Director (IDD) for supporting management of MDM data.
• Involved in implementing the land process of loading the customer data set into Informatica MDM from various source systems.
• Hands on experience in utilizing Hierarchy 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 with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Created Mappings to get the data loaded into the Staging tables during the Stage Process
• Coordinated with Business Leads in making them understand Match & Merge and incorporated their requirements and ideas.
• Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules.

Confidential

Junior SQL Developer

Environment: SQL*Plus, SQL*Loader, MS Word, MS Excel, MS SQL Server 8.0, MS, MS Access.

Responsibilities:

• Strong SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, CTE's, Cursors, Views, Indexes, Triggers and Functions • Strong experience of DDL, DML, T-SQL, views, stored procedure.
• Identifying long running queries, packages etc., implementing appropriate tuning methods.
• Created permanent tables, temporary tables and table variables.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation • Used Joins to write queries that retrieve data from more than one table.
• Collect requirement from non-technical client and convert the requirement to the logical design.
• Responsible for data modelling designing EERD with inclusion of constraint like completeness, disjoint and referential integrity.
• Design and develop the relational database and implement it using SQL.
• Normalize the database to third normal form to remove dependency.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Responsible for cleansing the data, performing ETL using SSIS.
• Design the control flow and write query to execute between process when required to perform certain task or manage the data destination.
• Stage the data by cleansing and monitoring them.
• Designed, created and maintained the database.
• Used tools like SQL *Loader to load the data into the database tables from flat files and excel sheets.