Post Job Free

Resume

Sign in

B.Tech with 3.5 yrs experience in informatica

Location:
Bangalore, KA, India
Salary:
5.5L
Posted:
November 01, 2012

Contact this candidate

Resume:

NAGARJUN Email: fs47a3@r.postjobfree.com

Mobile: +91-903*******

Professional Summary:

Having 3.5 years of IT Experience in Designing, Development and Implementation of Data Warehouses with ETL Tool using Informatica Power Center 7.1.1/8.6.

Extensively worked on Informatica Designer Components Source Analyzer, Transformations Developer, Mapplet and Mapping Designer.

Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.

Developed mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter and Router etc.

Having good knowledge in Informatica Metadata and Repository Management, was directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse

Developed Sessions and workflows in Informatica Workflow Manager.

Good knowledge in running, monitoring and testing the objects using Informatica client tools such as Workflow Manager, Workflow Monitor, and Debugger.

Worked extensively in independent and team oriented environment

Strong logical and problem solving skills and ability to quickly adapt to new technologies by self-learning.

Proven communication skills during coordination with business teams, other teams during requirement gathering.

Having good knowledge on Star and Snowflake Schemas.

Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks

Working with WIPRO Technologies, Bangalore from Feb 2011 to Till date.

Worked at IBM, Bangalore from May 2009 to till Jan 2011.

B.Tech from Jawaharlal Nehru Technological University in the year 2009.

ETL Tools : Informatica 8.6/7.1

Application Tools : Toad, Winsep, Putty

Languages : SQL, UNIX Shell programming

Databases : Oracle 9i/10g

Operating Systems : Windows 2K7/XP, UNIX

Project #1 : PHCS_BI

Client : Presbyterian Health Care System, USA

Period : Jan 2012 - Till Date

Role : Developer

Environment : Informatica 8.6 Oracle 10g,Windows XP and Unix

Description

This Data Warehouse is constructed to stage the Sales & Distribution and Inventory related data for Presbyterian Health Care System. These applications cater to provide data to various marketing groups of a major pharmaceutical company. The project comprises of various applications across various platforms. The data is received from different frontend applications is processed and then loaded in PHCS_BI for further analysis and processing.

Responsibilities

Understanding the Business Requirements and Develop an ETL process to load data from source to target.

Extensively used informatica power centre for loading the data from sources involving flat files to target as relational table.

Mainly involved in ETL developing to Extract, Transform and Load the data into stage area and data mart.

Extensively used different transformations like Source Qualifier, Expression, Lookup, Filter, Update Strategy, Router, Normalizer, and Sequence Generator to develop Data Mart from staging area.

Creation of sessions for mapping and validate the session.

Schedule and monitor the sessions work flows using informatica work flow manager and work flow monitor, daily basis.

Identify the bugs in existing mapping by analyzing the data flow.

Responsible for test case writing and testing.

Preparing Minutes of Meeting with Client

Project #2 : Promotional Sales Data Mart (PSDM).

Client : H.M. Grocery store, UK S

Period : Feb 2011-Jan 2012

Role : Developer

Environment : Informatica 8.6,Oracle 10g,Windows XP and Unix

Description

This Data Mart is based on the advertisement Management System and the Retail Sales System. The main object of this Data Mart is to provide integrated information on Retail Sales System and promotional sales metrics. The Transformation System and the Warehouse are both hosted on Windows NT servers using Oracle 8i as RDBMS. Promotional Sales Fact, with several dimensions namely Customer Product, Store, Location, Promotion, and Time. Aggregate tables are built to improve query performance. The Objective of this project is to create a data mart for the analysis of Sales information in the company. This project involved designing and creating a data mart to fulfil their business study & analysis requirement.

Responsibilities

Extensively used informatica power centre to create mappings,sessiojn and workflows as per business requirements..

Mainly involved in ETL development, unit testing and shell scripting.

Extensively used different transformations like Source Qualifier, Expression, Lookup, Filter, Update Strategy, Router, Normalizer, and Sequence Generator to develop Data Mart from staging area.

Creation of sessions for mapping and validate the session.

Schedule and monitor the sessions work flows using informatica work flow manager and work flow monitor, daily basis.

Using Target Load Plan to optimize the performance of the server.

Identify the bugs in existing mapping by analyzing the data flow.

Responsible for test case writing and testing.

Project #3 : Corporate Information Warehouse

Client : Deluxe Inc, USA

Period : May 2010-Jan 2011

Role : Developer

Environment : Informatica 8.6,Oracle 10g,Windows XP and Unix

Description

Deluxe Corporation is a Financial Organization in US and Canada which has products like Paper cheques, Electronic cheques, ATM and small business for the Banks and Organizations. The data warehouse maintains the client information like Client Name, Client Address and the details about which programs the client has been enrolled.The scope of the project is to build a Data Warehouse with a bottom up approach from the existing Data Mart. The main objective of the project is to help the senior and middle level management of the organization to improve the sales and get the knowledge of the new business opportunities.

Responsibilities

Analysis of the specifications provided by the clients.

Designing and making changes to the Informatica mappings.

Developing Informatica mappings and Business Objects Reports.

Preparation of Documentation for Informatica mappings and Business Objects Reports and execute the transition for the post production support for all the projects.

Project #4 : SSP5 Datamart

Client : GE Energy, USA

Period : July 2009 to May 2010

Role : Developer

Environment : Informatica 8.6,Oracle 10g,Windows XP and Unix

Description

The scope of the GEE HR Data Mart Project is to design and implement a Human Resources Data Mart that is sourced from the three (3) production instances of Oracle HRMS (Americas, Europe and Asia poles) via the standard extract files provided by GE Corporate.

Responsibilities

Analysis of the specifications provided by the clients.

Designing and making changes to the Existing mappings.

Developing sessions and workflows

Preparation of Documentation for mappings which developed by myself..

Testing - Unit Testing.



Contact this candidate