Oracle Developer

Job Description

We are urgently hiring for Oracle Developer for Pune location(Immediate Joiner).

Oracle database 11g/12c, SQL,pl/sql, procures, Databse functionns,

• Strong understanding of a relational database.
• Hands-on experience on different versions of Oracle database like 11g, 12c and 19c.
• Experience developing database applications with all stages of Software Development Life Cycle (Requirement Gathering, Analysis, Design, Development, Unit Testing, Production Deployment).
• PL/SQL Objects : Create and maintain objects like procedures, functions, packages , types, triggers, Cursors, Dynamic SQL, Recursion, Loops, Nested blocks, conditional logic (IF, CASE statements).
• Collection & Records : Ways of using collection and records in PL/SQL blocks.
• Oracle Functions : NVL, NVL2, DECODE, GREATEST, COLLESCE etc.
• Hierarchical queries : Data retrieval from table having hierarchical data.
• BULK operation : Knowledge on performing operations on bulk.
• Exception handling : Knowledge on how to manage run time oracle defined/user defined errors.
• Joins : INNER, LEFT, RIGHT, FULL, CARTESION join of two or more tables.
• Aggregate Functions : COUNT, MIN, MAX, AVG, FIRST, LAST, LISTAGG.
• Analytic Function : LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, ROW_NUMBER.
• View and Materialized Views : Basics of creating and maintaining views.
• Complex Queries : Nested queries, inline views, co-related subqueries.
• Basic knowledge on Oracle Architecture and performance tuning.
• Responsible to understand existing PL/SQL scripts and define the flow of the project.
• Effectively co-ordinate for UAT/PROD stakeholders to identify, solve & mitigate any technical challenges.
• Responsible for trouble shooting the performance issues on the application backend.
• Good analytical and problem solving skills, ability to meet deadlines, handle multiple tasks and flexible in work schedules.

Skill Expertise Level:

• Database Query (Expert , Mandatory)
• SQL (Expert , Mandatory)
• Excellent Communication Skills (Expert , Mandatory)
• Agile Development (Intermediate ,Preferred)

Experience:

• 5 – 7 Years

Salary:

• 800000 – 1200000 PA

No of Interviews:

• 3

Job Type:

• Permanent Full Time

Consider Relocation:

• yes

Industry:

• Accounting | Banking | Financial Services