PL/SQL Developer – Kanjurmarg West, Mumbai

Additional Details

Job Description

Job description:
SQL
● Joins: INNER, LEFT, RIGHT, FULL, CARTESIAN join of two or more tables
● Aggregate Functions: COUNT, MIN, MAX, AVG, FIRST, LAST, LISTAGG
● Function: LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, ROW_NUMBER
● View and Materialized Views: Basics of creating and maintaining views
● Hierarchical queries: Data retrieval from table having hierarchical data
● Complex Queries: Nested queries, inline views, correlated subqueries
● Table Partitioning: Basic knowledge on table & index partitioning

PL/SQL

● PL/SQL Objects: Create and maintain objects like procedures, functions, packages, types,
triggers.
● Recursion, Loops (FOR, WHILE DO), Nested blocks, conditional logic (IF, CASE
statements)
● Exception handling: Knowledge on how to manage run time oracle defined/user defined
errors
● Collection & Records: Ways of using collection and records in PL/SQL blocks
● BULK operation: Knowledge on performing operations on bulk

Requirements:
 Candidate must have at least 2 years of relevant experience in posgress SQL, SQL/PLSQL
 Must be good in communication, approachable and proactive
 Must have hands-on coding and development experience