Experience Required: 4-15 Years
Location: Bangalore/ Hyderabad/ Chennai/ Pune/ Kolkata/ Gurgaon
Detailed JD
Candidate must have at least 5-8 years of relevant experience in Oracle SQL/PLSQL
Must be good in communication, approachable and proactive.
Must be good in hands-on;
SQL;
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
Hierarchical queries : Data retrieval from table having hierarchical data
Oracle SYS tables : Basic knowledge on Oracle metadata tables
Privileges : How Role/Object level privileges works
Complex Queries : Nested queries, inline views, co-related subqueries
Data Types : Different types of oracle defined data types and their usage (especially CLOB, BLOB, LONG)
Table Partitioning : Basic knowledge on table & index partitioning
Oracle Functions : NVL, NVL2, DECODE, GREATEST, COLLESCE,
Candidate should know the concept of Oracle sharding
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
V 0.0.1