Application Developer

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
- 4+ 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:

- 4+ 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

Career Level - IC2

---