AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
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
Compare
All Filters
32 Oracle Senior Consultant Jobs
Senior Consultant
3-8 years
₹ 15 - 23.5L/yr (AmbitionBox estimate)
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
Key skills for the job
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 descriptionOracle 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
asked in
Senior Consultant interview
Q2. What is what if analysis in oracle policy automation?
asked in
Senior Consultant interview
What Senior Consultant at Oracle are saying
Rating based on 159 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
- Promotions - Bad
+1 more
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
Flexible timing
Monday to Friday
No travel
Day Shift
Oracle Benefits
Submitted by Company
Career development and internal mobility Health and well-being Financial security Benefits that suit your lifestyle
Submitted by Employees
View more benefits 
Compare Oracle with
SAP
Compare
MongoDB
Compare
Salesforce
Compare
IBM
Compare
Adobe
Compare
Compare
Wipro
Compare
Amazon
Compare
TCS
Compare
Accenture
Compare
Cognizant
Compare
Microsoft Corporation
Compare
Oracle Financial Services Software
Compare
JPMorgan Chase & Co.
Compare
Capgemini
Compare
Red Hat
Compare
SAS
Compare
Zoho
Compare
Deloitte
Compare
Cisco
Compare
Similar Jobs for you
Oracle Bangalore / Bengaluru Office Locations
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
560 066
Oracle EPM FCCS Consultant (Sr Consultant)
4-9 Yrs
Noida, Pune, Bangalore / Bengaluru
Fusion Technical Sr Consultant/Principal (Data migration)
6-10 Yrs
Bangalore / Bengaluru
Senior Consultant - Oracle AIA Developer
6-11 Yrs
Hyderabad / Secunderabad, Pune, Bangalore / Bengaluru
Oracle Fusion HCM Functional (Sr Consultant/Principal/Sr Principal)
5-10 Yrs
Kolkata, Gandhinagar, Chennai
Share an Interview