Professional Summary:

• Having 3+ years of ETL tool experienceon Warehousing in analysis, designing and developing mappings using Informatica Power Center.
• Experience in the Data warehousing using Data extraction, Data transformation and Dataloading.
• Experience in Development of Mappings by using needed Transformations with Informatica tool.
• Extensively used Informatica client tools - Source analyzer, Warehouse designer, Mapping designer, Mapplet designer, Repository manager and Workflow manager.
• Experience in performance tuning of sources, transformations, targets, mappings, worklets, workflows, and sessions.
• Extensively worked on Session partitioning techniques using different Informatica Partitioning techniques to optimize the load times.
• Possess complete Domain and Development Life Cycle knowledge of Data warehousing.
• Proficient in using Informatica Workflow manager, Workflow monitor, Repository manager, PMCMD (command line client utility) to create, schedule and control workflows, tasks and sessions.
• Good knowledge on Data warehousing concepts like Star schema, Dimension and Fact tables.
• Experience SQL and PL/SQL like joins, views, sub-queries, stored procedures, triggers etc.
• Having strong knowledge on UNIX and Shell scripting.
• Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Highly result oriented and driven for success.

Academic Qualification:

• B.Tech

Technical Skills:

ETL Tools : Informatica Power Center 8.x/7.x.
Database : Oracle 9i/10g.
Operating Systems: Windows NT, 2000/2003 Server, XP and UNIX.
Programming : SQL and PL/SQL.

Work Profile:

• Currently working with Accenture, Bangalore as an ETL Developer from Mar 2010 to Till Date.
• Worked as an ETL Developer for CSC, Chennai from Apr 2008 to Feb 2010.

Projects in detail:

Project : Insurance Claims System
Client: Confidential, USA
Role : ETL Developer
Environment : Informatica 8.6.0, Oracle 10g, Windows NT Server

Project Description:

The immediate goal of the project is to provide an executive leadership with standardized and timely information to the business users, which will help them to make strategic decisions regarding to the business. All the metrics developed will be displayed on a dashboard presentation (reports) that will help to the business users to make the Ad-hoc reports.

• Extensively worked in the performance tuning of programs, ETL procedures and processes. Error checking and testing of the ETL procedures and programs using Informatica session log.
• Data migration from one environment to another environment using ETL Informatica tool.
• Using ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
• Created mappings to implement change data capture (CDC) logic for some of the dimensions using informatica power center.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
• Worked extensively on Oracle database 10g and flat files as data sources.

Project : Critical Data Management
Client: Confidential
Role : ETL Developer
Environment : Informatica 8.1.1, Oracle 9i, Windows XP

Project Description:

This project is to provide different reports and support business queries for making intelligent banking decision based on data available in various branches across the country collected over a period of time. Bank wants to have tool, which will help it analyze the current business trends and to make predictions for future business trends. Bank is especially focused on getting the analytic information about targeted customer group, loss making schemes, session wise financial analysis …etc. The bank wants to aggressively launch new product for its loan and deposit customer in a very competitive market for which it wants the edge in identifying key customer on various age group to lure them to buy their product.

• Designed the Mapping Technical Specifications on the basis of Functional Requirements.
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
• Involved into source code review, the mappings created by my team members.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Tested the Informatica mappings with manual testing and assisted QA team.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target. Aggregator, Lookup, Expression, update Strategy, Joiner, Router, processes, test cases, and error control routines Sequence generator etc transformations in the mappings.
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions.

Project : Sales Data Mart
Client: Confidential, USA
Role : ETL Developer
Environment: Informatica 7.1.1, Oracle 9i, Windows XP

Project Description:

Confidential, is an upscale department store chain in the United States. This project deals with the distribution of historical sales, financial and marketing data to brokers, customers and financial centers on daily basis. The end users for analyzing the sales of the Nordstrom Company use the Data Mart. This information is being used by a group of business analysts and senior managerial personnel. Informatica was used as an ETL tool for extracting the Data from various sources running on Oracle 9i databases and load into Data Warehouse.

• Analysis of the specifications provided by the clients
• Preparation and review of ETL Specifications.
• Working on Informatica tool - Source analyzer, Warehouse designer, Mapping designer, Mapplets and Transformations.
• Involving in developing the mappings using different transformations in Power Center designer.
• Creating the Sessions, Worklets and Workflows with respective mappings in Power Center Workflow manager.
• Loading the data from respective databases into Data warehouse.
• Created Informatica mappings to build business rules to load data. Most of the transformations were used like the Source qualifier, Expression, Aggregator, Lookup, Filter, Joiner, Sequence Generator, Update strategy and Router.
• Involved in creating test case scripts for Unit testing.