SUMMARY

• 8 years of experience in Data warehousing using Informatica as an ETL tool.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving System Analysis, Design, Development and Implementation.
• Well experienced in design and implementation of Informatica data quality, both development and configuration
• Experience in Informatica master data management development to obtain golden records.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• 4 plus years of experience in understanding the architecture and business process in Informatica MDM 9.1/ 9.5.1/9.7.1 and also responsible for the developing, enhancing and supporting the MDM and Informatica Data Director (IDD) platforms and related data integration applications.
• Hands - on experience with Informatica MDM Hub Console like working with Data Mappings from Landing, staging and to Base Objects, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation and involved in customizing and configuring IDD applications.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Expertise in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation
• Excellent at Relational Database Management System (RDBMS) concepts.
• Wide range of experience in Software development, Project management, Data Integration, Master Data Management and Quality assurance
• Experience in Data Extraction, Transformation and Loading data using Informatica Power Center 9.5.1/9.1.1/8. x/7.x.
• Worked on tools like Repository Manager, Workflow Manager, Workflow Monitor, Designer consists of objects like Mapping Designer, Transformation Developer, Mapplet Designer, Source Analyzer and Target Designer, Admin console and Data Administration.
• Experience in designing complex mappings using Source Qualifier, Update Strategy, Expression, Sequence Generator, Aggregator, Filter, Joiner, JAVA, Router, Connected Lookup, Unconnected Lookup, Normalizer, Rank, XML, Sorter, Transaction Control and Union to load data into different target types from different sources like Flat files (Delimited files and Fixed width files) like text files or CSV files, XML, Oracle, IBM Mainframe, Cobol files, SQL server, DB2, Teradata, Netezza.
• Experience in managing Slowly Changing Dimensions (SCD) Type 1, Type 2 and Type 3, Data Marts, OLAP, OLTP and Change Data Capture (CDC).
• Worked on Workflow Manager by creating Sessions/tasks, Workflows, Worklets, reusable tasks like Sessions, Command, Email and Non-Reusable tasks like Decision, Event Wait and Event Rise.
• Good at Pre-SQL and Post-SQL at session level in Informatica.
• Knowledge on Data Cleansing, Data Staging, Data profiling, Error Handling, Session log files, Workflow log files and Performance optimization like Pushdown Optimization (PDO), session partitioning, which troubleshoots the bottleneck problems at different levels like source, target, mapping, session and system.
• Worked on different databases like Teradata, Oracle, SQL Server, MS Access.
• Good Knowledge of Data Warehousing/Data Modeling using ERwin, staging tables, stored procedures, Functions, cursors, Dimension tables, Fact tables, Surrogate Key, Primary keys, Foreign Keys, Star Schema, Snow Flake Schema, Triggers and Normalization/Denormalization.
• Experienced in performance tuning like creating indexes at database level.
• Good Knowledge of writing PL/SQL procedures.
• Experience in using Oracle Development tools such as Tool for Oracle Application Development (TOAD).
• Hands on experience in writing Simple/Complex SQL Queries sing Sub queries and multiple table joins using left, right, inner joins.
• Experience in UNIX Shell Scripting and batch scripting for parsing files.
• Experience in using the Informatica command line utilities like PMCMD, PMREP to execute workflows.
• Good communication skills both verbal and written, hardworking, self-motivated, ability to work independently or co-operatively in a team, eager to learn and ability to grasp quickly.
• Working experience in using Oracle 11g/10g/9i/8i, SQL Server 2008/2005/2003/2000 , PL/SQL
• Responsible for interacting with business partners to identify information needs and business requirements for Reports.
• Good understanding of dimensional models, slowly changing dimensions, star & snowflake schemas.
• Experienced with Agile SDLC methodology.
• Hands on experience in Oracle, SQL and PL/SQL Development i.e. Stored Procedures, Functions, Triggers and Packages Development using SQL Developer, SQL *Loader and TOAD Development tool, & working knowledge of SSIS, SSMS.
• Experience with TOAD to test, modify and analyze data, create indexes, and compare data from different schemas

TECHNICAL SKILLS

Databases: Oracle 10g/9i/11i/R12, DB2, SQL server 7.0/2000/2005/2008 , MS Access 2000/2005, Teradata v2r6/v12

Languages: Transact- SQL, PL/SQL, HTML, C, C#

Operating Systems: Windows NT/98/2000/XP/Vista/2003, Linux, Unix, MS-DOS, Sun Solaris.

ETL Tools: Informatica Power Center 9.5/9.x/8.x/7.x, Informatica Power Exchange, Informatica Data Quality Suite 8.5, SQL Server Integration Services (SSIS), SQL Server DTS, Cognos Data Manager

Data Modeling Tools: Microsoft Visio 2000/2003

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, SQL server profiler

Web Technologies: HTML, CSS, XML, Java-Script

Other Tools: Microsoft Office, MS Visio

MDM Tools: Informatica MDM

PROFESSIONAL EXPERIENCE

Senior Informatica MDM Developer

Confidential, Austin, TX

Responsibilities:

• Worked with ETL Developers in creating External Batches to execute mappings, Mapplets using Informatica workflow designer to integrate Shire’s data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• 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 (BVT) 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.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• 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.
• Created mappings using Informatica Power center and loading data into pre-landing tables.
• Created Unit Test Case Document, Detailed Design Document, Supplementary Document and Knowledge Transfer Document.
• High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role
• Finally, Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica MDM 9.1.0, Informatica Power Center 9.1, Oracle 11g/10g, Toad, JBoss 5.1.0, Address Doctor 5, IDD, Windows server 2003, Unix.

Senior Informatica MDM Developer

Confidential, NY

Responsibilities:

• Experience in MDM design, development, support and operations with Informatica MDM tool suite.
• Extensive knowledge and experience in implementing MDM services and capabilities.
• Cleated mappings and clench functions to load staging tables in MDM.
• Created base objects, relations ships using MDM.
• Configured relation among table to obtain LKP.
• Configured Match/merge in MDM to obtain golden records.
• Configured validation and trust.
• Related queries and packages in hub console, configured batch group to load the jobs.
• Configured auto merge, manual merge and created applications using IDD
• As an MDM Developer, responsible for the developing, enhancing and supporting the Informatica MDM platform and related data integration applications.
• Worked with data stewards and business analysts to design, develop, and configure business rules for data standardization, match and merge.
• Designed and developed the mappings for bringing the data from different sources like Flat files and Relational tables into MDM Hub i.e. landing tables.
• Implemented Informatica MDM new source workflow, including data profiling, configuration specification and coding, match rules tuning.
• Developed Data Mappings from Landing, staging and to Base Objects, and then applied Match and Merge processes to identify the Golden record.
• Obtained golden records using Informatica master data management hub console.
• Identified duplicates and changed the MDM processes to prevent and cleanup the current data
• Implemented DEA address compliance changes in MDM Hub console and corresponding ETL landing changes.
• Building of MCM Interactions in CDW from different channels such as Email, Direct Mail, Web etc.
• IMS Prescriber data analysis and co-ordination with IMS for data errors in the DEA data feed
• Re-architected Publish layers by removing redundancy, old business rules and consolidating the business rules
• Involved in the POC to evaluate the feasibility and effort of implementing Informatica MDM
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Interpreted logical and physical data models for Business users to determine common data definitions.
• Created scripts to automate the process of fetching execution statistics from Informatica session logs and mailing it to the concerned parties.
• Implemented the concept of slowly changing dimensions to maintain current and historical data in the dimension.
• Developed UNIX Shell Scripts to Alter/Create Indexes, Truncate tables using Pre and Post session command tasks.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
• Developed various Ad-hoc mappings for various business needs.
• Involved in migration of Informatica ETL Code, Database objects and flat files through from development to different environments.

Environment: Informatica Power Center 9.5/9.1, Informatica IDQ 9.1, Informatica MDM, Oracle 11g/10g, Unix Shell Script, IBM Tivoli Workload Scheduler, TOAD, PL/SQL, Teradata, SQL Assistant, WinScp, Putty, Microsoft Tools

Informatica MDM Developer

Confidential, Chicago, IL

Responsibilities:

• Perform Designs and Analysis on business systems applications, systems interfaces, databases, reporting, or business intelligence systems
• Good exposure in Informatica MDM where data Cleansing, De-duping and Address correction were performed.
• Involved in Informatica MDM hub configuration, IDQ cleanse function implementation, Hierarchy Configuration in MDM hub.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• 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.
• Configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Created Sessions/Batches in Informatica server manager to execute mappings.
• 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 for searching the data.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application
• Deliver new systems functionality supporting corporate business objectives.
• Translate requirements and high-level design into detailed functional design specifications.
• Wrote stored procedures, functions, and database triggers in SQL Server 2008.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Interpreted logical and physical data models for Business users to determine common data definitions.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Implemented the concept of slowly changing dimensions to maintain current and historical data in the dimension. Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
• Developed various Ad-hoc mappings for various business needs.
• Facilitate/lead design reviews of functional design with other members of the technical team, communicating design, requirements, feature set, functionality and limitations of systems/applications.

Environment: Informatica Power center 9.0/8.6, Informatica MDM, oracle 11g/10g, Unix, Unix Shell Script, Dollar Universe, OBIEE 10.1, TOAD, Teradata, SQL Assistant.

Informatica MDM Developer

Confidential, New York, NY

Responsibilities:

• Designed the Architecture for the MDM Project.
• Involved in business requirement meetings with analysts for the source to target (staging) mappings.
• Performed land process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store.
• Created mappings using different cleanse functions to load Cleansed data from landing to staging tables.
• Configure Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties for base objects.
• Created entity objects, entity relationships and profile for hierarchy using Hierarchies workbench.
• Involved with Informatica team members in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Created different Query Groups for Security IDD and Data Distribution.
• Created Display and PUT enabled packages for IDD.
• Configure Subject Area and Subject Area Groups for Security IDD.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Worked on MDM workflow manager.
• Interacted with the Business Team to understand the requirements and prepared technical documents for implementing the solutions as per Business needs.
• Involved in the Migration of code from MDM 9.1 to MDM Hub 9.7 and involved in upgrade to 9.7.1.
• Worked closely with ETL data architect for performing land batch process to populate data from external source system to landing tables in hub.
• Performed ETL mappings & ran sessions and workflows to execute the Land Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
• Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
• 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.
• Worked on shell scripts for Autopsy’s batch scheduling jobs.
• Profiled the data using Informatica Analyst tool to analyze source data (Departments, party and address) coming from Legacy systems and performed Data Quality Audit.
• Created On-demand and Ad-hoc data profiling (column level) and created DQ rules in Informatica Developer tool executing through powercenter workflow.
• Created mappings using Informatica Powercenter and loading data into prelanding tables.
• Created Unit Test Case Document, Detailed Design Document, Supplementary Document and Knowledge Transfer Document.

Environment: Informatica MDM Hub 9.5.1/9.7.1 , IDD, Informatica Powercenter 9.5.1, Informatica Analyst 9.5.1, Eclipse, Oracle 11g, Unix, Toad.

Informatica Developer

Confidential, Sacramento, CA

Responsibilities:

• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Teradata
• Developed complex mapping using Informatica PowerCenter tool.
• Extracted data from Oracle, Flat file, Excel files and performed complex joiner, Expression, Aggregate, and Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Extensively used PL/SQL, TOAD programming in backend and front-end functions, procedures, packages to implement business rules.
• Integrated various sources into the Staging area in Data warehouse
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Created pre and post SQL scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static, Dynamic and Persistent.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Used Parameters in Pre-SQL, Post-SQL, Source Filter, Target-schema, Source-schema, source table name, target table name, SQL override etc.
• Interacted with business analysts for clarification of the code and attended meeting to resolve many issues.

Environment: Informatica Power Center 9.0/8.6, Informatica Power Exchange, Oracle 11g/10g, UNIX, Unix Shell Script, DB2, TOAD, WinScp.

ETL Developer

Confidential

Responsibilities:

• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Teradata
• Developed complex mapping using Informatica PowerCenter tool.
• Extracted data from Oracle, Flat file, Excel files and performed complex joiner, Expression, Aggregate, and Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Developed the transformation logic, identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.
• Used Workflow Manager for Workflow and Session Management, database connection management and scheduling of jobs to be run in the batch process.
• Developed complex Informatica Mappings, Mapplets and reusable Transformations for different types of tests in pharmaceutical research studies on daily and monthly basis.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Created pre and post SQL scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static, Dynamic and Persistent.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Experience in Performance tuning using Push Down Optimization, Partitioning etc.

Environment: Informatica Power Center8.1.0, Oracle, SQL Server, Win XP, UNIX, UNIX Shell Script, TOAD.

Confidential

Informatica Developer

Responsibilities:

• Participated in requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables.
• Worked with Informatica Power Center Mapping Designer, Workflow Manager, Workflow Monitor and Admin Console.
• Used Source Qualifier, Aggregator, Lookup, Expression, Stored Procedure Transformations.
• Extensively worked on various stages like ODBC, Transformer, Sequential file, Hashed file, Join, Lookup, Lookup file set, Filter, Router, Rank, Sort, Aggregator, Copy, Dataset, Merge and Remove duplicates, pushdown optimization.
• Developed and documented Informatica Mappings/Transformations, and Informatica sessions in a detail design document.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based on commit interval.
• Created Sessions and Batches to run Workflows.
• Responsible for writing unit test cases and performing the unit test.
• Worked with the QA team in order to determine the data validation and performed the data validating at the source and the target database level.
• Involved in Production support and trained the other developers to handle issues
• Documented the ETL process and also issues encountered during UAT and production support for ease of future maintenance.
• Installed and configured Informatica server in windows 2000 environment.
• Created new roles and gropes and added users to the system.
• Created test scripts for both etl testing and plsql testing
• Developed ETL technical specs, Visio for ETL process flow and ETL load plan, ETL execution plan, Test cases, Test scripts etc.
• Developed and scheduled various pre and post-sessions commands and workflows for all mappings to load data from source files to target tables.
• Created one time mappings and workflows for better understanding and easy to use.
• Worked with Variables and Parameters in the mappings.
• Created reusable transformations and Mapplets and used them in mappings
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Involved in performance tuning for sources, targets, mappings and sessions.

Environment: Informatica Power Center8.1.0, Designer, Workflow Manager, Workflow Monitor, Oracle, Flat files, PL/SQL, SQL*Plus