Oracle Developer

Pune, MAHARASTRA, India
September 6, 2023
800000₹ - 1200000₹ / year
Full Time

Apply for this job

Email *
Upload your Photo *
Browse

1 MB is max

Phone Number *

Paste youtube link here

Browse

Upload file .pdf, .doc, .docx

Education


Education 1

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

Related Jobs