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
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  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 5.2k Reviews

Video summary

36 Oracle Senior Consultant Jobs

Senior Consultant

Oracle India Pvt. Ltd.

3.7

based on 5.2k Reviews

3-8 years

₹ 15 - 23.5L/yr (AmbitionBox estimate)

Kolkata, Mumbai, New Delhi + 4 more

1 vacancy

Senior Consultant

Oracle

posted 5d ago

Job Role Insights

Flexible timing

Key skills for the job

Medical Coding Computer Science Supply Chain Management Oracle Agile Coaching UNIX

+ 3 more

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

What Senior Consultant at Oracle are saying

3.7

Rating based on 160 Senior Consultant reviews

Anonymous · Engineering - Software & QA in Bangalore / Bengaluru

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