SUMMARY

• 7+years of IT experience in analysis, design, development and implementation of Client/Server, Internet/Intranet, Data Warehouse/Data Mart & Business Intelligence applications
• Experience and strong business knowledge in domains like Finance, Insurance, Banking and Pharma.
• Extensive experience with ETL tool Informatica Power Center /Power Mart 9x/8x/7x, Power Exchange 9.x/8.xin designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions.
• Experienced in using Databases Oracle 11g/10g/9i, DB2, Sybase, Teradata, Netezza, SQL Server 2005/2008. Strong Experience on database interfaces like PL/SQL Developer, SQL Plus and TOAD.
• Extensive experience in designing and developing complex mappings from varied transformation logic likeUnconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing.
• Proficient with Informatica Data Quality (IDQ) for cleanup and massaging at staging .
• Experience in Configuration of Informatica MDM Data Director, Hierarchy Manager, Match/Merge process
• Hands - on experience with Informatica MDM Hub configurations - Data modeling Data Mappings (Landing, staging and Base Objects), Data validation, Match and Merge rules, writing and customizing user exits, customizing configuring Business Data director (BDD)Informatica data director (IDD)applications
• Experience in completeSoftware Development Life cycle(SDLC) including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
• Experience in Application Design, Data Extraction, Data Acquisition, and Data Mining Development, Implementations and Testing of Data warehousing and Database business systems.
• Extensively followed the advanced concepts ofRalph KimballandBill Inmon Methodologies.
• Extensive knowledge ofData Modeling, Data Conversions, Data integration and Data Migrationwith specialization in Informatica Power Center and Erwin.
• Expert onSlowly Changing Dimensions Type 1, Type 2andType 3for inserting and updating Target tables for maintaining the history.
• Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
• Implemented data warehousing methodologies for Extraction, Transformation and Loading usingInformatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console.
• Experience in working withUNIX Shell Scriptsfor automatically running sessions. Written number of shell scripts to run various batch jobs.
• Experience in working with Informatica web services components.
• Solid experience in writing SQL queries,Stored Procedures, Cursors, Indexes, and Views.
• Experience onDebuggerto validate the mappings and gain troubleshooting information about data and error conditions.
• Experience onpost-session and pre-session shell scriptsfor tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x, IDQ 8.x, MDM 9.x

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Sybase Power Designer 16/15, Erwin 3.5.2/ 3.X & Toad 8.0/9.1

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, Netezza 5.0/6.0, XML, TeraData, SQL Server 2000/ 2005/ 2008 & MS Access

Scheduling Tools: Autosys, Control-M, ESP

Reporting/OLAP Tools: Business Objects XI 3.1, OBIEE 10.1.X, Cognos

Programming: SQL, PL/SQL, VB, C, C++ & Java, SQL*Plus & SQL*Loader, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Informatica Developer/Lead

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Designed and developed ETL strategies and Mappings from source systems to target systems. ETL strategies were designed to cater initial and incremental load.
• Extensively used Power Center to design multiple mappings with embedded business logic. Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Worked with business SMEs on developing the business rules for cleansing. Used Informatica Data Quality (IDQ) tool for data cleansing by applying rules.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Installation of Informatica MDM hub.
• Resolved Inconsistent and Duplicate date to support strategic with Multidomain MDM.
• Perform Informatica MDM Design, Configuration and Implementation. Designing ETL Mappings, Informatica MDM User Exists, Match rules etc.
• Created relationships for the base objects which reflects from look up tables in MDM.
• Created complex mappings using Unconnected Lookup, Sorter, and Aggregator, Lookup and Router transformations for populating target table in efficient manner.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Worked on using Informatica web services.
• Created Mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning of the Informatica mappings using various components like Pushdown optimization, Parameter files, Variables and Dynamic Cache. Performance tuning using round robin, hash auto key, Key range partitioning.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, Worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV/QA/PRD environment.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
• Development of customizedPL/SQLprocedures functions and packages to load data into and extract data from staging tables and facts.
• Created, developed and tested reports using Business Objects Info View web intelligence and Universe designer. Interaction with users to meet their reporting needs.

Environment: Informatica 9.x, Oracle 11g/10g, MDM 9.x, IDQ 8.x, SQL Server 2008, Autosys, Business Objects XI 3.1, CVS with Eclipse, JIRA V4.1, PL/SQL, SQL Developer, Toad for SQL Server, Cognos, Microsoft Excel, Visio.XML.

Confidential, Raleigh, NC

Sr. Informatica Developer

Responsibilities:

• Extensively used ETL to load data from different source systems like Flat files into the Staging table and load the data into the target database.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and mapplets for data load to data warehouse and database.
• Multi source Extraction Transformation and Loading into the target structures using Informatica.
• Worked closely with multiple business units and a data solutions engineer to identify key information that will enhance business decision-making.
• Performance tuned mapping, sessions and database.
• Wrote stored procedures to accomplish tasks.
• Resolved Inconsistent and Duplicate Data to Support Strategic Goals with Multidomain MDM.
• Configured the match and merge rules and implemented in base objects in MDM.
• Created landing tables, stage tables and base objects in MDM and ran batch jobs which load data into base objects.
• Involved Data Flux Expression Language provides statements, functions, and variables for.
• Used Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
• Created sessions to move the data at specific intervals and on demand.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
• Debugged the mapping for failed session to fix data and code issues.
• As a part of daily loading into the warehouse, used UNIX shell scripting to triggers the workflows in a particular order.
• Involved in coding UNIX shell scripting to execute pre/post session commands.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Analyzed and Created Facts and Dimension Tables.
• Used different Data Warehouse techniques like Star-Schema, Snow-Flake Schema.
• Involved in the installation and configuration of Oracle Business Intelligence OBIEE 10.1.3.4.
• Developing multiple dimensions (drill down hierarchies), logical objects in business model & mapping layer and creating presentation catalogs in presentation layer.
• Informatica Data Quality was used for cleansing and matching the customer data. Real-time address cleansing was achieved using Informatica Power Connect for Web Services.

Environment: Informatica Power Center 9.1/9.0, Oracle 11g/10g, MDM, IDQ, Autosys Scheduler, Cognos, Web Services, DB2 6.1, XML, Erwin, SQL Loader, PL/SQL, UNIX, SOA.

Confidential, Omaha, NE

ETL Consultant

Responsibilities:

• Extensively involved in interacting with Project coordinators, Business Analysts and End-users to gather requirements.
• Prepared the ETL spreadsheet after identifying the Facts and Dimensions.
• Designed the Star Schema after identifying the Facts and Dimensions.
• Prepared the Fact Dimension Matrix Spreadsheet prior to the development of rpd for the required reports.
• Used the Informatica Power center designer to develop the required mapping based on the mapping document.
• Used the Informatica Power Center Workflow Manager to develop the required sessions for the mappings developed based load dependency.
• Performed change data capture (CDC) process using SCD-I and SCD-II implementations.
• Used the Workflow Manager to create tasks, sessions, worklets and batches.
• Debugged and fixed failed or faulty mappings.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Implemented the best practices for creating the mappings, sessions and workflows.
• Identified bottlenecks in the ETL process and restructured the mappings and sessions to improve the ETL performance.
• Used Control-M for scheduling jobs.
• Unit tested the mappings before including the developed sessions into the already existing batch.
• Integration tested the entire batch after including the individual sessions into the existing batch.
• Involved in configuring new jobs and importing the newly developed INFORMATICA sessions into DAC.
• Implemented the ETL processes using OWB 10gr2 to load data from sources system (SQL Server) into the staging.
• Developed mappings using OWB for data loading. Created Process flow, scheduled & monitored session.

Environment: Informatica Power Center 8.6,, IDQ, DAC, Control-M, Oracle 10g/9i, SQL Server 2005, Toad, Windows XP, Microsoft Word, Microsoft Excel, PowerPoint.

Confidential

Informatica Consultant

Responsibilities:

• Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of Siebel Analytics.
• Created and Tested Report in the Dashboard.
• Designed, Developed and Tested Data security and Dashboard security in Analytics.
• Migrated the Tested Code from Dev to QA and QA to Production of Repository, Dashboard Reports and Informatica mappings and workflow and DAC Entities.
• Designed the logical and physical data model for Siebel data warehouse to store OLAP data.
• Analytics Admin work: New Id creation, Account modification of existing users, Password reset and Deletion of accounts.
• High Level Design and Detail Design for Informatica.
• Used Informatica Mappings and Transformations to load data into the data mart.
• Created & Called Stored Procedures and functions using Informatica.
• Used Oracle Loader to Load Bulk Data.
• Created Worklets & Workflows to Schedule and Trigger Mappings.
• Used Look Ups to Identify Data as per the predefined Criteria / Business Rule.
• Designed, Created and used Mapplets for Repeated functionalities.
• Sourced Data from multiple databases & files.

Environment: Informatica power center 8.1, TIDAL, TeraData, SQL Server 2005 and TOAD.

Confidential

Informatica Developer

Responsibilities:

• Prepared ETL Mapping spreadsheet and Fact - Dimension Matrix. Repository Design.
• Used Designer to develop the mappings based on ETL Mapping Spreadsheet.
• Debugged and implemented the best practices in mappings, sessions for data extraction and loading from source to target databases.
• Checked the source, target and mapping bottlenecks to tune the ETL process performance.
• Worked on the Siebel Analytics Admin Tool to configure the business model based on the end user requirements.
• Created Logical dimensions, columns, and Logical Joins. Set levels to support drill-down, and aggregation over Columns.
• Used Time series Wizard for time comparison measures in the business model.
• Created all the Reports as per requirements using Siebel Analytics answers.

Environment: Informatica Power mart 6.1.2, Siebel Analytics 7.5, Oracle 9i, PL/SQL, UNIX, TOAD.