Oracle Hiring for ODI Developer at BENGALURU, India Full Time

Job Description

Work with Oracle’s world class technology to develop, implement, and support Oracle’s global infrastructure.

As a member of the IT organization, assist with the design, development, modifications, debugging, and evaluation of programs for use in internal systems within a specific function area.

Duties and tasks are standard with some variation. Completes own role largely independently within defined policies and procedures. BS or equivalent experience in programming on enterprise or department servers or systems.

Responsibilities

Overall Experience 5-7 years

Minimum 4-5 years hands on with end to end DWH Implementation experience using ODI.

Should have experience in developing ETL processes – ETL control tables, error logging, auditing, data quality, etc. Should be able to implement reusability, parameterization, workflow design, etc.

Expertise in the Oracle ODI toolset and Oracle PL/SQL,ODI

knowledge of ODI Master and work repository

Knowledge of data modelling and ETL design

Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc

Packaging components, database operations like Aggregate pivot, union etc.

using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects

Design and develop complex mappings, Process Flows and ETL scripts

Must be well versed and hands-on in using and customizing Knowledge Modules (KM)

Experience of performance tuning of mappings

Ability to design ETL unit test cases and debug ETL Mappings

Expertise in developing Load Plans, Scheduling Jobs

Ability to design data quality and reconciliation framework using ODI

Integrate ODI with multiple Source / Target

Experience on Error recycling / management using ODI,PL/SQL

Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.

Experience of creating PL/SQL packages, procedures, Functions , Triggers, views, Mat Views and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle

Experience in Data Migration using Sql loader, import/export

Experience in SQL tuning and optimization using explain plan and Sql trace files.

Strong knowledge of ELT/ETL concepts, design and coding

Partitioning and Indexing strategy for optimal performance

Must have Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.

Should have experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High and Low level design documents.

Experience in understanding complex source system data structures preferably in Financial services (preferred) Industry

Ability to work with minimal guidance or supervision in a time critical environment.

Work with Oracle’s world class technology to develop, implement, and support Oracle’s global infrastructure.

As a member of the IT organization, assist with the design, development, modifications, debugging, and evaluation of programs for use in internal systems within a specific function area.

Duties and tasks are standard with some variation. Completes own role largely independently within defined policies and procedures. BS or equivalent experience in programming on enterprise or department servers or systems.

About Us

Innovation starts with inclusion at Oracle. We are committed to creating a workplace where all kinds of people can be themselves and do their best work. It’s when everyone’s voice is heard and valued, that we are inspired to go beyond what’s been done before. That’s why we need people with diverse backgrounds, beliefs, and abilities to help us create the future, and are proud to be an affirmative-action equal opportunity employer.

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans status, age, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.