Oracle

Application Developer - PLSQL

Posted On

Aug. 11, 2025

Location

Bengaluru, Karnataka

Experience Level

Professional

Job Type

Permanent

Apply By

Aug. 31, 2025

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

Jobs at Bengaluru

Oracle

Senior Performance Engineer

Professional

Bengaluru, Karnataka

Application Developer - PLSQL Apply Now

Job Description

Jobs at Bengaluru

More Jobs at Oracle

Actively Recruiting Companies at Bengaluru, Karnataka

Application Developer - PLSQL