SUMMARY

• Over 9 years of professional IT experience in Analysis, Design, Development, Testing and Implementation of various Data Warehousing and Software Applications.
• Over seven years of extensive experience on Informatica Power Center with strong business understanding and knowledge of Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, XML, UDB, Oracle, Sybase, SQL Server.
• Experienced in logical and physical data modeling of staging and warehouse environments using Data modeling tools like Erwin, Rational Rose and Oracle Designer.
• Extensively involved in ETL Data warehousing using Informatica Power Center 7.x/8.x/9 Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse
• Very strong in writing SQL Joins, Nested Queries, Unions, Multi - table joins
• Experience in scheduling the batch jobs using workflow monitor, ESP, Tivoli, Autosys and FTP methods.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly changing (SCD) Type1/2/3 dimension mappings.
• Expertise in using SQL*LOADER to load Data from external files to Oracle Database.
• Experience in Optimizing the Performance of SQL scripts and Oracle database/application tuning.
• Excellent in coding using SQL, SQL*Plus, PL/SQL, Procedures/Functions, Triggers and Packages.
• Developed Batch Jobs using UNIX Shell scripts to automate the process of loading, pushing and pulling data from different servers.
• Good experience in performing and supporting Unit testing, System Integration testing (SIT), UAT And production support for issues raised by application users.
• Diverse background with fast Learning and creative Analytical abilities with good Technical, Communication and Interpersonal skills

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter9/8.x/7.x PowerExchange / PowerConnect.

RDBMS: Oracle11g/10g/9i, SQL Server 2000/2005/2008

Operating System: HP UNIX,IBM AIX 4.3/4.2, Windows NT/2000/XP/7

Job Scheduling Tools: TIDAL, Tivoli 7x, Autosys 4.5, Mainframe, Control M.

Defect Management tools: HP Quality Center 9.1, Test Director 7x, Remedy 7x, IBM Rational ClearQuest, WinCvs

Languages: SQL, PL/SQL, Unix Shell Scripting, XML, C, C++, C#, JavaScript.

Modeling Tools: ER Studio, Erwin 4.1,UML

Database frontend tools: Oracle PLSQL Developer, Aqua Data Studio 8.0.7, Quest Toad for Oracle, DB Artisan.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Developer

Responsibilities:

• Involved in complete understanding of business requirement and involved in analyzing the sources to load in Oracle warehouse.
• Designed Sources to Targets mappings from Excel/Flat files to Oracle using Informatica Power Center.
• Responsible for working with DBA and Informatica admin for project coordination.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Implemented slowly changing dimension Type 1 and Type 2 forChange data capture.
• Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily
• Doing Change Requirement for complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Involved in unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Coordinate with business team, get the requirements from them and then coordinate with offshore team to get the work done, keeping timeline in mind.
• Involved in team weekly and by monthly status meetings.

Environment: Informatica Power Center 9.1/8.6, UNIX scripting, Oracle 10g, Quality Toad, PL/SQL (Stored Procedures, Triggers, Packages), WinCvs.

Confidential

Sr. Informatica Developer

Responsibilities:

• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Implemented slowly changing dimension Type 1 and Type 2 forChange data capture.
• Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily
• Doing Change Requirement for complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Involved in complete understanding of business requirement and involved in analyzing the sources to load in Oracle warehouse.
• Designed Sources to Targets mappings from Mainframe, Flat files, to Oracle using Informatica Power Center.
• Responsible for working with DBA and Data Modellers for project coordination.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, workflows for the mapping to run daily based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Involved in unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Involved in team weekly and by monthly status meetings.

Environment: Informatica Power Center 9.1/8.6, UNIX scripting, Oracle 11g, Mainframe.

Confidential - Bridgewater, NJ

Sr. Informatica Production Support

Responsibilities:

• Involved in complete understanding of business requirement and involved in analyzing the sources to load in Oracle warehouse.
• Designed Sources to Targets mappings from SQL Server, Excel/Flat files, Xml Files to Oracle using Informatica Power Center.
• Responsible for working with DBA and Data Modellers for project coordination.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Implemented slowly changing dimension Type 1 and Type 2 forChange data capture.
• Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily
• Doing Change Requirement for complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, worklets, workflows for the mapping to run daily, biweekly based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Involved in unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Involved in team weekly and by monthly status meetings.

Environment: Informatica Power Center 9.1/8.6, Unix scripting, MS SQL server 2005, Oracle 10g, Quality Toad, PL/SQL (Stored Procedures, Triggers, Packages)

Confidential, Memphis, TN

Sr. Informatica Developer

Responsibilities:

• Involved in Requirement Analysis, ETL Design and Development for extracting the data which is stored in different sources like Oracle, SQL Server, Sybase.
• Analyzed, designed and developed an environment that would facilitate the use of Informatica to transform data coming from Igrasp oltp into Adim datamarts.
• Developed complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, worklets, workflows for the mapping to run daily, biweekly based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Created and executed unit test cases for various scenarios for all the mappings, workflows and scripts.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas
• Involved in unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly and monthly reports.
• Worked on modification of UNIX shell scripts.
• Involved in team weekly and by monthly status meetings.

Environment: Informatica PowerCenter 9.1/8.6, Unix scripting, MS SQL server 2005, Oracle 10g, Quality Center 9.0, Toad, PL/SQL (Stored Procedures, Triggers, Packages),Erwin, MS Visio, Windows XP

Confidential, Columbus OH

ETL Informatica Developer

Responsibilities:

• Involved in Requirement Analysis, ETL Design and Development for extracting the data which is stored in different sources like Oracle, SQL Server.
• Analyzed, designed and developed an environment that would facilitate the use of Informatica to transform data coming into Adim datamarts.
• Developed complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, worklets, workflows for the mapping to run daily, biweekly based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Created and executed unit test cases for various scenarios for all the mappings, workflows and scripts.
• Involved in unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly and monthly reports.
• Worked on modification of UNIX shell scripts.
• Involved in team weekly and by monthly status meetings.

Environment: Informatica PowerCenter8.5, Oracle10g, Toad, SQL, PL/SQL (Stored Procedure, Trigger, Packages), Erwin, MS Visio, Windows 2000, UNIX.

Confidential, Windsor, CT

ETL Informatica Developer

Responsibilities:

• Performed major role in understanding the business requirements to design and load data into data warehouse.
• Design of Logical and Physical schema generation.
• The business requirements were transformed into ETL metadata for the Aggregate tables.
• Involved in designing the process for getting the data from all systems to Data warehousing system.
• Imported various Application Heterogeneous Sources, created Targets and Transformations using Informatica Power Center 8.1.
• Involved in the design and development of Aggregate mappings and tuned for better performance.
• Developed complex mappings using heterogeneous sources and targets in different Relational Databases and flat files.
• Optimized/Tuned queries, stored procedures and mappings for better performance and efficiency.
• Developed various shell scripts for different purposes. For example, starting workflow, balance checks, reset sequence generators, purge database tables.
• Developed shell scripts for workflow scheduling.
• Extensively worked with Informatica Workflow Manager to Design and Develop workflows and workflow dependencies.
• Moved the Informatica objects between various environments and testing the sessions and mappings.
• Developed Technical Specs, and Release manuals.
• Provided post production support for TDW.
• Provided 24 *7 production support during all the production release weeks.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and USER testing.

Environment: Informatica Power Center 8.1, Oracle10g, SQL Loader, PL/SQL, MS Access, Windows XP/2000/NT, TOAD 7.0 and Erwin 4.0

Confidential

Data Warehouse/Database Consultant

Responsibilities:

• Involved in design & development of operational data source and data marts in Oracle
• Reviewed source data and recommend data acquisition and transformation strategy
• Designed ETL process using Informatica Designer to load the data from various source databases and flat files to target data warehouse in Oracle
• Also involved in Mass data loads, refreshing the data in various applications, Performance evaluations, modifying the existing code to accommodate new features.
• Used various Transformations like Aggregator, Router, Expression, Source Qualifier, Filter, Lookup, Joiner, Sorter, XML Source qualifier, Stored Procedure and Update Strategy.
• Worked extensively on Flat Files, as the data from various Legacy Systems are flat files.
• Have setup Test and Production Environment for all mappings and sessions.
• Created and configured Sessions in Workflow Manager and Server Manager.
• Debugged the sessions using Debugger and monitored Workflows, Worklets and Tasks by Workflow Monitor.
• Extensively used SQL & PL/SQL for Transformations.
• Developed Oracle stored procedures, packages and triggers for data validations.

Environment: Oracle 8i, SQL, PL/SQL, SQL*Loader, TOAD, Windows 2000.