3.2 years experience as an ODI(Oracle Data Integrator) Developer in IT

Gangareddy

Mobile no: +919********* Email:************@*****.***

PROFESSIONAL SUMMARY:

3.3 years of experience in Information Technology in ODI 10g &11g (Oracle Data

Integrator).

Worked on technologies like Oracle, Oracle Data Integrator.

Have experience in data Extraction, Loading and Transformation in data ware house

environment.

Designed and developed interfaces to load the data from multiple sources like

Relational databases, flat files into oracle database.

Developed packages, scenarios using interfaces and variables.

Good knowledge about Topology, Designer, Operator in Oracle Data Integrator.

Debugging the master jobs and packages by using operator navigator.

Implemented SCD Type2 on Dimension tables.

Good Understanding about ODI Architecture.

Worked with knowledge modules like LKM, IKM and CKM.

Good Knowledge about Standalone Agent and J2EE Agent.

Delivered the assignments before the deadlines.

Ability to work individually as well as in a team with excellent problem solving skills.

Knowledge on data ware housing concepts like schemas and approaches.

EDUCATION QUALIFICATION:

Completed Bsc from Kakatiya University.

PROFESSIONAL EXPERIENCE:

Working as an ODI Developer in Marlabs Software Private Limited, Bangalore since

September 2011to till date.

Technical Skills:

ETL Tools Oracle Data Integrator (ODI) 11g.

RDBMS Oracle 11g

Operating Systems Windows XP/7

Programming PL&SQL.

SQL Developer.

Oracle Tools

Project #1:

Client : Burbank, Australia.

Role : ODI Consultant.

Duration : April2012 to till date.

Technologies: Oracle Data Integrator 11g, Windows, Oracle11g.

Description:

Burbank is a high profile real estate development company. It is a largest home builder in

Australia. Burbank offers financial services like home loans and mortgage finance. This project is

designed for maintaining complete information about customers and home sales data.

Burbank has best track record in building, land development, financial lending and marketing. It

wins multiple awards every year. It offers great home and land packages and best investment

opportunities.

Roles& Responsibilities:

Analyzed Functional & technical design documents.

Created master & work repositories and configured ODI connections for source and target

systems in topology.

Extensively used ODI (Oracle Data Integrator) ELT tool to create Data ware Housing OLAP

model.

Experience in ODI designer, Topology, Operator and ODI Tools.

Performance Tuning in Oracle Data Integrator.

Worked with multiple sources such as Relational database, Flat files for Extraction,

Transforming and Loading data into target tables.

Optimized the knowledge modules to improve the functionality of the process.

Developed packages, scenarios using interfaces and variables.

Debugging the master jobs and packages by using operator navigator.

Monitoring the execution logs in operator.

Experienced in Working with Load Plans and Scenarios.

Implemented Send E mail to the DBA on interface execution failure.

Used ODI commands like OdiFileMove, odiFileAppend,odiFilecopy etc.

Participated in all phases of project development, testing, deployment and support.

Good knowledge in creating File to DB and DB to DB related interfaces.

Working knowledge of Knowledge Modules (LKM, IKM, JKM and CKM).

Implemented SCD type1 and SCD type2.

Have knowledge about Changed Data Capture.

Performed unit testing at various levels of ELT flows.

Execute test cases with multiple data sets to attain exact test results and capture faulty

construction.

Project #2:

Client : ETRADE, US.

Role : ODI Developer.

Duration : October 2011 to March 2012.

Technologies: Oracle Data Integrator 11g, ODI 10g, Windows, Oracle11g.

Description:

ETRADE is an innovative financial services company offering easy to use online brokerage,

investing and related banking solutions. Etrade allows individuals to take control of their futures by

providing the products, tools, services they need to meet their long term investing goals.

Responsibilities:

Experience in development of ELT and ETL Mapping in Oracle Data Integrator.

Worked with multiple sources such as Relational databases, Flat files like Csv, Txt for

Extraction, Transforming and Loading data into target tables.

Created new models for the data sources – flat files, Oracle.

Did reverse engineering for the data sources and targets.

Monitoring the Execution Logs in operator navigator.

Debug the sessions by utilizing the log of the sessions.

Loading metadata from flat file source system into RDBMS target system.

Resolved ODI related issues faced by the team members.

Debug the sessions by utilizing the log of the sessions.

Contact this candidate