No of Positions: 6
Location:
Bangalore,Hyderbad,Delhi ,Gurgaon,Mumbai
Tentative Start Date:
April 30, 2023
Work From :
Onsite
Rate : $ 13
-
15 (Hourly)
Experience :
5 to 10 Year
Required Skills
Description:
Good hands on SQL and PL/SQL with specific on below areas
SQL
1. Joins - INNER, LEFT, RIGHT, FULL, CARTESION join of two or more tables
2. Aggregate Functions - COUNT, MIN, MAX, AVG, FIRST, LAST, LISTAGG
3. Analytic Function - LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, ROW_NUMBER
4. View and Materialized Views - Basics of creating and maintaining views
5. Hierarchical queries - Data retrieval from table having hierarchical data
6. Oracle SYS tables - Basic knowledge on Oracle metadata tables
7. Privileges - How Role/Object level privileges works
8. Complex Queries - Nested queries, inline views, co-related subqueries
9. Data Types - Different types of oracle defined data types and their usage (especially CLOB, BLOB, LONG)
10.Table Partitioning - Basic knowledge on table & index partitioning
11. Oracle Functions NVL, NVL2, DECODE, GREATEST, COLLESCE,
12. Candidate should know the concept of Oracle sharding
PL/SQL
1. PL/SQL Objects - Create and maintain objects like procedures, functions, packages , types, triggers,
2. Recursion - Loops (FOR, WHILE DO), Nested blocks, conditional logic (IF, CASE statements)
3. Exception handling - Knowledge on how to manage run time oracle defined/user defined errors
4. Collection & Records - Ways of using collection and records in PL/SQL blocks
5. BULK operation - Knowledge on performing operations on bulk
Delhi
Bengaluru
Gurgaon
Bengaluru
Bengaluru
Bengaluru
Gurgaon
{{list.to_email}}
{{jobapplydata.email}} |
{{jobapplydata.phone}} |
