Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 1K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

RATE NOW!
- ABECA 2025
  
  RATE NOW!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Engaged Employer

Oracle

Compare

3.7

based on 5k Reviews

1063 Oracle Jobs

Senior Consultant-ETL/ODI

Oracle India Pvt. Ltd.

3.7

based on 5k Reviews

3-5 years

₹ 9.5 - 27.5L/yr (AmbitionBox estimate)

Mumbai, Bangalore / Bengaluru

Senior Consultant-ETL/ODI

Oracle

posted 15d ago

Job Role Insights

Flexible timing

Key skills for the job

Medical Coding SQL Oracle ETL Testing Informatica PLSQL

+ 17 more

Job Description

Intermediate consulting position operating independently with some assistance and guidance to provide quality work products to a project team or customer that comply with Oracle methodologies and practices. Performs standard duties and tasks with some variation to implement Oracle products and technology to meet customer specifications.

3 - 6 years of ETL development experience with minimum 3+ years using Oracle Data Integrator (ODI) for batches implementation.

Strong understanding of SDLC, OLAP, OLTP, data warehouse, datamart development, fact and dimensional design methodology.

Experience in database design, relational and dimensional data modelling.

Should have experience of interacting with customers in understanding business requirements, translating them into ETL specifications and high/low level design documents.

Strong knowledge of ELT/ETL concepts with hands-on experience working with latest ODI version with various transformations.

Ability to design and develop ODI mappings, packages, load plans, user functions, variables and sequences.

Experience working with multiple source/target systems such as Oracle, XML files, flat files, MS SQL Server, etc.

Experience in invoking web services through ODI, error handling, data migration using ODI.

Exposure to CDC/Journalizing implementations and customizing knowledge modules as per the requirement.

Experience of creating PL/SQL packages, procedures, functions, triggers, views, MVs and exception handling for retrieving, manipulating, checking and migrating complex datasets.

Should be able to tune existing ODI mappings and optmize SQL queries using best suitable technique.

Experience with shell scripting is mandatory.

Exposure to scheduling tools like ControlM, Autosys will be an advantage.

Must have good verbal and written communication skills, strong interpersonal, analytical and problem-solving abilities.

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

Preferred candidate from a financial industry.

Career Level - IC2

Responsibilities

Developer with standard assignments are accomplished without assistance by exercising independent judgment, within defined policies and processes, to deliver functional and technical solutions on moderately complex customer engagements.

Skills:

Employment Type: Full Time, Permanent

Read full job description

Oracle Interview Questions & Tips

Prepare for Oracle Senior Consultant roles with real interview advice

What people at Oracle are saying

3.8

Rating based on 149 Senior Consultant reviews

Anonymous · Software Development in Bengaluru

Likes

company provides free medical consultations

Dislikes

No salary hikes/Appraisals, managers won't inform why no hike has been provided even after company has shown good performance & added a lot of new customers

Read 149 reviews

Senior Consultant salary at Oracle

reported by 2.2k employees with 2-13 years exp.

₹9.8 L/yr - ₹26.5 L/yr

10% less than the average Senior Consultant Salary in India

View more details

What Oracle employees are saying about work life

based on 5k employees

80%

89%

78%

73%

Flexible timing

Monday to Friday

No travel

Day Shift

View more insights

Compare Oracle with

SAP

4.2

Compare

MongoDB

4.0

Compare

Salesforce

4.1

Compare

IBM

4.1

Compare

Adobe

4.0

Compare

Google

4.4

Compare

Wipro

3.7

Compare

Amazon

4.1

Compare

TCS

3.7

Compare

Accenture

3.9

Compare

Cognizant

3.8

Compare

Microsoft Corporation

4.1

Compare

Oracle Financial Services Software

3.6

Compare

JPMorgan Chase & Co.

4.1

Compare

Capgemini

3.8

Compare

Red Hat

4.3

Compare

SAS

4.4

Compare

Zoho

4.3

Compare

Deloitte

3.8

Compare

Cisco

4.2

Compare

Similar Jobs for you

ODI Developer at Fusion Plus Solutions Inc

Hyderabad / Secunderabad

3-6 Yrs

₹ 4-8 LPA

ODI Developer at Oracle India Pvt. Ltd.

Bangalore / Bengaluru

3-5 Yrs

₹ 5-7 LPA

ODI Consultant at Infosys Limited

Bangalore / Bengaluru

2-5 Yrs

₹ 4-7 LPA

ODI Developer at UST

Thiruvananthapuram

3-5 Yrs

₹ 6-9 LPA

Senior Consultant at Oracle India Pvt. Ltd.

Mumbai, Bangalore / Bengaluru

3-5 Yrs

₹ 5-7 LPA

Senior Consultant at Oracle India Pvt. Ltd.

Mumbai, Bangalore / Bengaluru

3-5 Yrs

₹ 5-7 LPA

Senior Consultant at Oracle India Pvt. Ltd.

Mumbai, Bangalore / Bengaluru

3-5 Yrs

₹ 5-7 LPA

Senior Consultant at Oracle India Pvt. Ltd.

Mumbai, Bangalore / Bengaluru

3-5 Yrs

₹ 5-7 LPA

Administrator at Infosys Limited

Bangalore / Bengaluru

3-6 Yrs

₹ 5-8 LPA

Application Developer at Accenture Solutions Pvt Ltd

Pune

5-10 Yrs

₹ 7-12 LPA

Oracle Bangalore / Bengaluru Office Locations

View all

Bangalore / Bengaluru (6) Mumbai (2)

Bangalore Office

Oracle Technology Park No 3 Bannerghatta Road Bengaluru, KARNATAKA, 560 029 Bangalore

Bangalore Office

Global Axis Plot #152/1, EPIP Zone Whitefield Bengaluru, KARNATAKA, 560 066 Bangalore
560 066