We provide IT Staff Augmentation Services!

Etl Developer Resume

Experience Summary

  • 7 years of overall IT experience involving Design, Development, Analysis and implementation using standard SDLC methodologies.
  • Core competencies include design and development of ETL(Informatica) and reporting(OBIEE- developing repository and building Dashboards/Reports).
  • Expertise in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository using Oracle BI Administration
    Tool.
  • Configured Answers (ad-hoc querying, reports/analyses ), Interactive Dashboards with drill-down capabilities (charts/tables/graphs), ibots/agents (alerts) and administered Web Catalog Objects (pages, folders).
  • Experience in Security Setup at both Object and Data levels.
  • Strong Knowledge of Data Warehouse Architecture and Star Schema, Snow flake Schema, FACT and Dimensional Tables.
  • Proficient in ETL processes of creating Source/Target definitions, building Mappings using various Transformations, creating and monitoring Sessions/Workflows.
  • Extensively used the four basic Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Expertise in different stages of handling data viz. requirement gathering, identifying data sources/targets , data cleansing, data loading.
  • Created ETL mappings, Mapplets, reusable transformations, sessions, workflows, scheduling of ETL process, worked on performance tuning of ETL mappings, debugged
  • mappings and Mapplets.
  • Strong conceptual background of RDBMS and access methods SQL, PL/SQL.
  • Has good experience in preparing software requirement specifications(SRS) and software design documents.
  • Performed Functionality and Performance testing for Informatica Power Center ETL tool, Client/Server.
  • Very Good Exposure to the entire Software Development Life Cycle.
  • Outstanding communication, analytical and presentation skills.
  • Ability to provide timely solutions and work within specified time frames.

Technical Skills

  • Reporting Tools
  • OBIEE 10g,OBIEE 11g
  • ETL Tools
  • Informatica Power Center 9.x/8.x
  • Operating Systems
  • Windows 7/98/XP, UNIX
  • Languages
  • SQL, PL/SQL
  • Tools & Utilities
  • Oracle, Teradata, SQL*Loader, TOAD, MS SQL Server 2000, DB2, Flat files, SQL.
  • Databases
  • Oracle 11g/10g,SQL Server 2000, DB2 UDB

Professional Experience

Project Title

Marketing Research and Analysis , CA

Confidential,

Duration

June 11 to Till date

Responsibilities

Designing the logics to be implemented at the RPD level and development of all layers of OBIEE Repository i.e. Physical, Business Model, and Presentation layer.
Implementation of data and Object level security.
Defining Multiple Dimension Hierarchies for the Dimension Logical Table and also Experience in creation of logical columns, hierarchies, level based measures in Business model.
Created hierarchy for product and customer dimension tables.
Implemented Usage Tracking.
Created around 500 metrics in RPD.
Created Reports with graphical representation such as Bar charts, pie charts.
Created the reports using prompts and filters.
Tested RPD performance

Role

OBIEE Developer

Confidential,

Oracle 11g,OBIEE 11.1.1.5

Project Title

CDF(Commercial Distribution Finance), CA

Confidential,

Duration

October 09 to May11

Responsibilities

Understand the Business Requirements.
Analyzing the requirement gathered from Business Users .
Designing the logics to be implemented at the RPD level.
Implementation of data and Object level security .
Created Reports, prompts and Filters using OBIEE.
Created dashboard pages and sections.
Implemented language translation for different users.
Implemented GE related branding.
Created Reports with graphical representation such as Bar charts, pie charts
Created alerts for reports.
Created bookmark Link, Prompted Links and Saved Customizations.
Formatted the Reports as per the Client requirement.

Role

OBIEE Developer

Confidential,

Oracle 10g,OBIEE 10.0.1.3.4,OBIEE 11g

Confidential

Duration

August 2008 to September 2009

Responsibilities

Understand the Business Requirements.
Analysing the requirement gathered from Business Users
Designing the logics to be implemented at the RPD level.
Created Reports, prompts and Filters using OBIEE.
Created dashboard pages and sections.
Implemented Shutterfly related branding.
Created Reports with graphical representation such as Bar charts, pie charts
Created alerts for reports
Created Links, Prompted Links and Saved customizations.
Formatted the Reports as per the Client requirement

Role

OBIEE Consultant

Business Area

Human Resource-Analytics

Confidential,

Duration

February 07 to July 08

Responsibilities

  • Extracted data from different source systems into the data warehouse.
  • Extensively used mapping and mapplet designer of Informatica Power Center.
  • Designed and implemented various transformations like Source Qualifier, Filter, Expression, Router, Aggregator, Sorter, and Lookup for loading the data into fact and dimension tables using mapping designer.
  • Performed unit testing.
  • Created and executed the sessions using Informatica workflow manager.
  • Maintained reference document for all source systems data locations.
  • Experience in Performance Tuning.
  • Created reusabletransformations and Mapplets.
  • Used Workflow manager for Creating, Validating, Testing and running the sequential and

concurrent Batches and Sessions.

  • Creating daily, weekly and monthly batches and scheduling them according to the precedence diagrams.
  • Designing the ETL Technical Specifications Documents.
  • Providing timely responses to all client requests.

Role

ETL Developer

Business Area

Duration

June 05 to January 07

Responsibilities

  • Understand the business requirements.
  • Imported various Sources, Targets, and developed Transformations using Informatica Power Center Designer.
  • Developed various Mappings with the collection of all Sources, Targets, and Transformations.
  • Designed, developed and deployed new data marts along with modifying existing marts to support additional business requirements.
  • Created functional specification Document for each module of the project.
  • Worked with complex mappings.
  • Used Workflow manager for Session Management, Database Connection Management and Scheduling of jobs.
  • Designed and Developed Transformations, Mappings and Sessions in Informatica to load target database and tuned mappings for improving performance.
  • Experience in Co-ordinating with Testing Team.
  • Created and Scheduled sessions and worklets using workflow manager to load the data into target database.
  • Worked with different data sources such as Oracle and Flat files.
  • Used Workflow manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions

Role

ETL Developer

Education : Bachelors in Electronics and Communications Engineering.

Hire Now