Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Oracle Team. If you also belong to the team, you can get access from here

Oracle Verified Tick

Compare button icon Compare button icon Compare
filter salaries All Filters

32 Oracle Senior Consultant Jobs

Senior Consultant

3-8 years

₹ 15 - 23.5L/yr (AmbitionBox estimate)

tooltip
This is an estimate of the average salary range for this position. It has not been reviewed by the company, and the actual salary may differ.

Kolkata, Mumbai, New Delhi + 4 more

1 vacancy

Senior Consultant

Oracle

posted 18hr ago

Job Role Insights

Flexible timing

Job Description

PL/SQL Developer - Oracle, SQL Tuning
Our Team
We work for one of the largest multi-national banks (Client) with presence across the globe. We work on Supply Chain Finance domain and is one of the industry leading solution for the Client. We are responsible for the enhancements to the existing platform to cater to the growing business needs based on industry trends, either functionally or technically.
The solution implemented is a global application spanning across 3 regions and 20+ countries with a single code base, with multi-lingual support.
Looking for Oracle PL/SQL developers who would be responsible for:
  • Understanding the requirements from the Functional Team
  • Estimating the development efforts
  • Developing the functionalities based on Agile/ Water-Scrum-Fall model
  • Ensuring the queries written are optimized to handle performance and volume.
  • Assisting in defect fix during System Testing, SIT, UAT and Non-Regression Testing.
Your Opportunity
You will be responsible for applying your extensive hands-on knowledge of Oracle SQL, PL/SQL features to develop functional requirements. You would be responsible for the entire development life cycle viz., development till production implementation.
Your Qualifications
  • Any Computer Science based graduation
  • 3+ years in software development
  • Excellent hands-on coding and design skills in Oracle SQL, PL/SQL with exposure to analytical functions and data modelling.
  • Expertise in Query fine-tuning to ensure optimized execution
  • Experience in Banking Domain
  • Knowledge of UNIX is an added advantage
Our Ideal Candidate
  • Preferably from Banking domain
  • Hands-on development experience in writing Oracle queries, stored procedures, packages that are fine-tuning to be of good performance and handle high volume.
  • Aspire to learn new tools as per the project need
  • Exposure to Agile methodologies
Your Responsibilities
As an integral part of the development team you will be responsible for the following -
  • Understand the business requirements from the functional team
  • Estimate the development efforts for the assigned functions.
  • Develop the functionalities based on Agile/ Water-Scrum-Fall model
  • Write optimized Queries or Packages that can handle high volume and performance
  • Perform peer-review of code written by other developers
  • Assisting in defect fix during System Testing, SIT, UAT and Non-Regression Testing.
  • Additionally, contribute to the upliftment of existing design/ code for alternates that can help in flexibility and scalability.
Filtration criteria:
  • 3-5 years of experience in Oracle SQL, PL/SQL development
  • Pure development experience to be considered (to avoid support expertise where the requirement is more monotonous)
  • Experience in Query fine-tuning (not database tuning) for writing optimized code.
Screening Criteria Questionnaire
  • How do you rate yourself in Oracle programming
  • 6 above/10 is good
  • Yes
  • Explain Plan
  • Check for the execution where the cost is higher
  • Yes, I have used it. I have good exposure in using and contributing to it.
  • Stored Procedures, Packages, Triggers, Functions, Complex Queries using joins from multiple tables
  • Function can be called within a query whereas Procedure cannot be called within a query.
  • Know the fundamentals of data modelling (tables, views, data types, index, etc.,)
  • Yes
  • Do you have expertise in SQL tuning in your projects
  • What tool you use for SQL tuning
  • What do you check for in Explain Plan
  • Do you have hands-on development experience
  • What all objects you have created in Oracle
  • What is the difference between Procedure and Function
  • Experience in data modelling
  • Experience in Banking domain
Career Level - IC2
Covered under Job Description

Employment Type: Full Time, Permanent

Read full job description

Oracle Interview Questions & Tips

Prepare for Oracle Senior Consultant roles with real interview advice

Top Oracle Senior Consultant Interview Questions

Q1. What is difference between writing rule in Excel and word in oracle policy automation
Q2. What is what if analysis in oracle policy automation?
Q3. How to test huge XML in debugger in OPA?
View all 9 questions

What Senior Consultant at Oracle are saying

3.7
 Rating based on 159 Senior Consultant reviews

Likes

company provides free medical consultations

  • Work-life balance - Good
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

  • Promotions - Bad
  • +1 more
Read 159 Senior Consultant reviews

Senior Consultant salary at Oracle

reported by 2.1k employees with 2-13 years exp.
₹9.1 L/yr - ₹25 L/yr
11% less than the average Senior Consultant Salary in India
View more details

What Oracle employees are saying about work life

based on 5.2k employees
80%
89%
78%
73%
Flexible timing
Monday to Friday
No travel
Day Shift
View more insights

Oracle Benefits

Submitted by Company
Career development and internal mobility
Health and well-being
Financial security
Benefits that suit your lifestyle
Submitted by Employees
Work From Home
Cafeteria
Gymnasium
Health Insurance
Free Transport
Team Outings +6 more
View more benefits

Compare Oracle with

SAP

4.2
Compare

MongoDB

3.8
Compare

Salesforce

4.0
Compare

IBM

4.0
Compare

Adobe

3.9
Compare

Google

4.4
Compare

Wipro

3.7
Compare

Amazon

4.1
Compare

TCS

3.7
Compare

Accenture

3.8
Compare

Cognizant

3.8
Compare

Microsoft Corporation

4.0
Compare

Oracle Financial Services Software

3.5
Compare

JPMorgan Chase & Co.

4.0
Compare

Capgemini

3.7
Compare

Red Hat

4.3
Compare

SAS

4.4
Compare

Zoho

4.3
Compare

Deloitte

3.8
Compare

Cisco

4.1
Compare

Similar Jobs for you

Software Developer 4 at Oracle India Pvt. Ltd.

Kolkata, Mumbai + 5

3-5 Yrs

₹ 37.5-45 LPA

Principal Software Developer at Oracle India Pvt. Ltd.

Bangalore / Bengaluru

8-13 Yrs

₹ 40-45 LPA

Senior Consultant at Oracle India Pvt. Ltd.

Kolkata, Mumbai + 5

3-8 Yrs

₹ 40-45 LPA

Senior Engineer at Motherson Technology Services

Hyderabad / Secunderabad

7-9 Yrs

₹ 16-50 LPA

Software Developer 4 at Oracle India Pvt. Ltd.

Kolkata, Mumbai + 5

8-12 Yrs

₹ 37.5-45 LPA

Software Developer 4 at Oracle India Pvt. Ltd.

Kolkata, Mumbai + 5

3-5 Yrs

₹ 37.5-45 LPA

Senior Member of Technical Staff at Oracle India Pvt. Ltd.

Kolkata, Mumbai + 5

8-13 Yrs

₹ 40-45 LPA

Senior Java Software Engineer at Altruista Health

Bangalore / Bengaluru

5-9 Yrs

₹ 25-40 LPA

Lead Software Engineer at Kimberly-Clark Corporation

Bangalore / Bengaluru

7-12 Yrs

₹ 30-35 LPA

Senior Member of Technical Staff at Oracle India Pvt. Ltd.

Kolkata, Mumbai + 5

3-5 Yrs

₹ 27.5-32 LPA

Oracle Bangalore / Bengaluru Office Locations

View all
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

Senior Consultant

3-8 Yrs

Kolkata, Mumbai, New Delhi +4 more

18hr ago·via naukri.com

Senior Consultant

3-8 Yrs

Kolkata, Mumbai, New Delhi +4 more

18hr ago·via naukri.com

Oracle EPM FCCS Consultant (Sr Consultant)

4-9 Yrs

Noida, Pune, Bangalore / Bengaluru

6d ago·via naukri.com

Senior Consultant

8-13 Yrs

Bangalore / Bengaluru

6d ago·via naukri.com

Fusion Technical Sr Consultant/Principal

3-8 Yrs

Bangalore / Bengaluru

13d ago·via naukri.com

Senior Consultant For IAM

5-8 Yrs

Bangalore / Bengaluru

13d ago·via naukri.com

Fusion Technical Sr Consultant/Principal (Data migration)

6-10 Yrs

Bangalore / Bengaluru

13d ago·via naukri.com

Cloud Presales Senior Consultant

8-13 Yrs

Mumbai

14d ago·via naukri.com

Senior Consultant - Oracle AIA Developer

6-11 Yrs

Hyderabad / Secunderabad, Pune, Bangalore / Bengaluru

14d ago·via naukri.com

Oracle Fusion HCM Functional (Sr Consultant/Principal/Sr Principal)

5-10 Yrs

Kolkata, Gandhinagar, Chennai

15d ago·via naukri.com
write
Share an Interview