Application Developer - PLSQL

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

Responsibilities

Covered under Job Description

About Us

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s challenges. We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.

We know that true innovation starts when everyone is empowered to contribute. That’s why we’re committed to growing an inclusive workforce that promotes opportunities for all.

Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and 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.