Staff Consultant- PL/SQL Developer

Overview

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.
  
  
  

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 - 5 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
  
  
  

• 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
  
  
  

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.
  
  
  

• 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.
• How do you rate yourself in Oracle programming?
• 6 & above/10 is good
• Do you have expertise in SQL tuning in your projects?
• Yes
• What tool you use for SQL tuning?
• Explain Plan
• What do you check for in Explain Plan?
• Check for the execution where the cost is higher
• Do you have hands-on development experience?
• Yes, I have used it. I have good exposure in using and contributing to it.
• What all objects you have created in Oracle?
• Stored Procedures, Packages, Triggers, Functions, Complex Queries using joins from multiple tables
• What is the difference between Procedure and Function?
• Function can be called within a query whereas Procedure cannot be called within a query.
• Experience in data modelling?
• Know the fundamentals of data modelling (tables, views, data types, index, etc.,)
• Experience in Banking domain :
• Yes
  

Covered under Job Description Section

Qualifications

Career Level - IC1

About Us

Only Oracle brings together the data, infrastructure, applications, and expertise to power everything from industry innovations to life-saving care. And with AI embedded across our products and services, we help customers turn that promise into a better future for all. Discover your potential at a company leading the way in AI and cloud solutions that impact billions of lives.

True innovation starts when everyone is empowered to contribute. That’s why we’re committed to growing a workforce that promotes opportunities for all with competitive benefits that support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing accommodation-request_mb@oracle.com or by calling 1-888-404-2494 in the United States.

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.