informatica, oracle

Location:

Hyderabad, AP, India

Salary:

5lakh to 10 lakh

Posted:

April 19, 2014

Contact this candidate

Resume:

hema

Email-id:- ********@*****.***

resh(- +917*********

Career Objective:

To secure a challenging position in the corporate sector which

will give me enough opportunity to expand my technical and leadership

skills. I am ambitious to be part of a team that design and develop quality

software to achieve the organizational success.

Personal Skills:

> Highly committed, flexible and result oriented professional having

around 3+ years of experience in IT Industry.

> Strong knowledge on all Data Warehousing aspects including

architecture, design, ETL, and OLAP and In-depth knowledge in PL/SQL.

> Expertise in Analysis, Design, Development and Implementation.

> Working Experience in Informatica, PL/SQL, SQL.

Current Duties & Responsibilities:

> Understanding high-level data warehousing requirements of the

business.

> Primarily responsible for enhancement and maintenance of existing Data

warehouse Applications.

> Use effective technical skills to initiate meetings, develop agenda,

conduct and provide minutes so that all appropriate parties are kept

up-to-date regarding project status.

> Ensure success of the project by taking ownership of deliverables and

assist/perform analysis, testing or other tasks as necessary.

> Flexible and effective role as a team member.

> Excellent communication and interpersonal skills.

> Ambitious and hardworking in nature.

> Quickly adapting to the new environment and ability to learn.

> To work with positive attitude, analyzing all kinds of situation with

honest efforts.

> Fulfilling the specified task within its proper duration and never say

die attitude.

Technical Qualification:

Graduation: - Bachelor of science (M.S.Cs) From kakatiya

university, AP.

Software Skills:

. Operating System : WINDOWS 98/NT/2000/XP.

. Data Warehousing Tools: Informatica V6.1/V7.1.1/V8.6.0.

. Language & Tools : SQL, PL/SQL.

. Design Methods / Tools : Star/ Snow-Flake Schema, ERWin6.0.

. RDBMS : ORACLE 10g/11g.

. Others : Toad.

Employment Details:

. Present Employer : Tata Consultancy Services Pvt.Ltd,

Hyderabad

. Designation : ETL Developer.

. Duration : April 2010- Till date.

Project Handled:

Current Project

Project Name : MTM (Mark to Market)

Client : GE.

Role : Informatica Developer

Technology : Informatica Power Center

8.6.0, Oracle 10g, Windows, UNIX

Duration : Aprl'2012 - till date

Project Description:

A measure of the fair value of accounts that can change over

time, such as assets and liabilities. Mark to market aims to provide a

realistic appraisal of an institution's or companies current financial

situation.

The accounting act of recording the price or value of a security,

portfolio or account to reflect its current market value rather than its

book value.

When the net asset value (NAV) of a mutual fund is valued based on the

most current market valuation.

Role :

. Worked on Power Center client tools like Source Analyzer, Warehouse

Designer, Mapping Designer, Mapplet Designer and Transformation

Developer.

. Used ETL to extract and load data from Oracle, Flat Files to Oracle

DWH.

. Developed Informatica Mappings to capture data changes from the

operational sources systems into data warehouse and data marts (SCD

mappings).

. Created Various Complex Transformations such as Update Strategy,

Look Up, Filter and Router Transformations.

. Created basic and aggregate levels of Fact Table mapping and

optimized them for incremental Extraction and Aggregation using

Parameters and variables to pass values during workflow execution.

. Created and Monitored Work Flows using Workflow Manager and Work

Flow Monitor

Environment : Oracle 9i/SQL, Informatica 8.6.0,

Windows XP.

project#1

Project Name : PDM(Panasonic Data Mart)

Client : Panasonic.

Role : Informatica Developer

Technology : Informatica Power Center

8.6.0, Oracle 10g, Windows, UNIX

Duration : April'10 - Mar'2012

Project Description:

Panasonic Electronics & functional photography is a division or any

system that provides accurate response for its consumers. it provides

varied services which includes functional photography which includes,

telescopic digital equipment, LCD's etc. Panasonic provides custom

systems and within budget and with proven reliability. to attain and

support the analytical and ad hoc reports Panasonic contains an oracle

database which captures the sales requests and other related transaction

details. Initially the data will be cleansed by set of business rules in

the staging area and would be loaded into EDW.