ETL Developer Resume Profile

Career Objective:

To convert every opportunity into achievement in the area of Application Development and Support.

Summary:

An IT professional with 4.3 years of experience in IT industry in Informatica and Data Warehousing.
Currently working as an ETL Developer as Technology Analyst for BP Project in Infosys
Strong Knowledge of Informatica ,Data Warehouse Concepts
Worked on Informatica Power Center tool for data conversion from variety of source systems. Dealt with various transformation logic like Lookup, Aggregator, Joiner, Source Qualifier, Router, Expression, Update Strategy, Filter and more while designing and developing complex mappings and mapplets.
Knowledge Hands on experience on Unix, writing SQL queries.
Excellent analytical skills in understanding the client Organizational Structure
Knowledge of working with tool like Toad.
Excellent communication and interpersonal skills.

Technical Skills:

Soft Skills and Strength:

Quick learner with good analytical and problem solving skills, motivated to success with the desire to tackle challenging problems.
An energetic and focused team player
Strong interpersonal and communication skills with ability to maintain effective working relationships.
A result-oriented person.

Professional Experience:

As a part of this programme, Alaska region will migrate data from Passport system to new Backbone SAP Maximo system

Responsibilities:

A ETL Developer Development:

Designing the mapping Once requirements are given
Creating QA Question log w.r.t requirement
Understanding the Requirement
Developing the mapping,session,Worklow ETL Data Flow
Performing the Unit Testing
Creating Design Document
Executing the Workflows
Unit Test case preparation, Coding and Unit Testing.
Involved in Preparing and maintaining process documents Code Review, Test Cases, Migration Document and Design Document .
Involved in Code Migration
Quality check for code and Test Results.

Confidential

Devon is among the nation's leading U.S.-based independent gas and oil producers and independent processors of natural gas and natural gas liquids In North America.
The Data Warehouse Data Mart DWDM is the database in the USA-only legacy Business Intelligence BI solution that is accessed by end customers in: ad hoc Business Objects reporting pre-built Business Objects reporting and legacy business applications such as the financial portion of Automated Variance Reporting AVR . DWDM will continue to serve up data for consumption, but it will no longer get data directly from the legacy Enterprise Data Warehouse EDW it will get master data from dynamic views layered over the Operational Data Store ODS and transaction data from the Landing Area both of which ultimately source from SAP . After the Jan-2012 go-live, the DWDM will continue to be a USA-only solution going forward..

Responsibilities:

B ETL Developer Development:

Designing the mapping
Developed Jobs through Tidal for Scheduling
Developed Unix Scripts
Extraction order, Source to Target Mapping.
ETL Process flow and dependencies.
Unit Test case preparation, Coding and Unit Testing.
Involved in Preparing and maintaining process documents Code Review, Test Cases, Migration Document and Design Document .
Quality check for code and Test Results.

Confidential

Responsibilities:

ETL Developer Development:

Designing the mapping
Developed Appworx Chains and modules
Developed Unix Scripts
Extraction order, Source to Target Mapping.
ETL Process flow and dependencies.
Unit Test case preparation, Coding and Unit Testing.
Technical and data flow Documentation for the above listed applications and Manage Perform Work Product Review for each deliverable from Offshore.
Involved in Preparing and maintaining process documents Code Review, Test Cases, Migration Document and Design Document .
Quality check for code and Test Results.
Suggesting best practices to ETL developers to improve performance of the code.
Deployment of new releases on live.