Professional Summary:

• Extensive Software experience in System Analysis, Design, Development, Implementation and Testing of Client/Server and Web applications and this includes Insurance and Financial Domains.
• Strong ETL data integration experience using Informatica PowerCenter 9.1/8.6, Repository Admin Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Knowledge of Matadata Manager, Informatica Data Quality, B2B-Data Transformation , Data Exchange, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet Designer, Workflow Designer, Task View, Gantt Chart View, Mapplets, Shortcuts, Informatica Power Connect for SAP/Siebel, and ETL.
• Solid experience in Ralph Kimball Methodology, Bill Inmon Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, FACT tables, Dimension tables.
• Excellent experience using Oracle 10g/9i/8i/7.x, Teradata ,SQL, PL/SQL, SQL Plus.
• Excellent interpersonal skills.
• Team Player with ability to work independently and manage/lead ETL Teams.
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle 11x/10g/9i, SQL Server 2008/2005, Teradata, DB2, MSSQL, Excel sheets, Flat Files, Sybase, COBOL files and XML files.
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Expertise in using UNIX and writing Perl and UNIX shell scripts.

Professional Experience:

Confidential

Informatica Developer

Responsibilities:

• Responsible for Business meetings, conversion of business rules into technical specifications
• Developed ETL mappings based on the Functional Requirements
• Extracted data from Oracle, SQL Server and Sybase database tables, generated Position and Balance files dynamically and FTPed to PrimeView for report generation
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Worked with various active and passive transformations in Informatica PowerCenter
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer
• Developed UNIX shell scripts to run the workflows and automated the scripts to run daily loads using Control-M scheduler
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level
• Extensively worked with Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• Worked with re usable objects like Re-Usable Transformation and Mapplets
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables and Mapping Parameters
• Handled various loads like Intra Day Loads, Daily Loads, Weekly Loads, Monthly Loads, and Quarterly Loads using Incremental Loading Technique
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor
• Extensively worked with the Debugger for handling the data errors in the mapping designer

Environment: Informatica PowerCenter 9.1, Teradata, Oracle 10g, SQL Server 2005, Sybase, Flat Files, Control-M, Rapid SQL, Quality Center, UNIX, Windows XP

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica PowerCenter 8.1 to extract data from various sources and load in to staging database.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Extensively used ETL to load data from multiple sources to Staging area Oracle 9i using Informatica PowerCenter 8.1 Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load
• Designed Logical and Physical Modeling using Erwin Data Modeler tool.
• Did data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
• Created data stores, project, jobs, and data flows using Data Integrator
• Created complex Cognos reports using calculated data items, multiple lists in a single report. Prepared functional and technical documentation of the reports created for future references.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• In charge of converting data using SQL Server 2005 using SSIS
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designing mapping templates to specify high level approach.
• Involved in creating/modifying reports using BusinessObjects and Web Intelligence.
• Developed PL/SQL scripts to move historical data from ERP sources to BOW.

Environment: Informatica PowerCenter 8.1, Teradata, Oracle 10g/9i,PL/SQL, TOAD, SQL Plus, Erwin, Windows, UNIX HP UX, Control M.

Confidential

Informatica Developer

Responsibilities:

• Designed and developed ETL process using Informatica tool.
• Worked with various Active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation
• Extensively worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator, and Lookup Transformation
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager
• Responsible for extracting data from Oracle, Sybase, and Flat files
• Responsible for the Data Cleansing of Source Data
• Responsible for Performance Tuning in Informatica PowerCenter
• Extensively worked with both Connected and Un-Connected Lookups
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, Std Deviation in the Aggregator Transformation
• Extensively made use of sorted input option for the performance tuning of aggregator transformation
• Extensively used SQL Override function in Source Qualifier Transformation
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation
• Worked with Update strategy transformation using functions like DD INSERT, DD UPDATE, DD REJECT, and DD DELETE

Environment: Informatica PowerCenter 8.1 Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer,Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer ,Oracle 10g, SQL, PL/SQL, Teradata, Flat Files, Autosys, Star Team, UNIX, Windows XP

Confidential

Responsibilities :

• Requirement gathering from end users and conversion of functional specifications into technical specifications
• Responsible for creation of database objects such as tables, views, materialized views, indexes, stored procedures, functions and packages.
• Developed PL/SQL procedures to pull data from different tables into a flat table.
• Built Packages and scheduled them on timely basis.
• Troubleshooted performance issues and bugs within packages using dbms output, debugger, explain plan and TKPROF.

Environment: Oracle 9i, SQL, PL/SQL, SQL Loader, Windows 2000