OnBenchMark Logo

PLSQL Developer

No of Positions  No of Positions:   6

location Location: Bangalore,Hyderbad,Delhi ,Gurgaon,Mumbai

date Tentative Start Date:   April 30, 2023

Work From Work From : Onsite

rate Rate : $ 13  -  15 (Hourly)

experience Experience : 5 to 10 Year

Job Applicants : 8
Job Views : 514
You have successfully applied. Company will contact you soon.
Name : {{jobapplydata.name}}
Company Name : {{jobapplydata.cname}}
Email  {{jobapplydata.email}} |   Send Email   {{emaildata.total}}
Phone {{jobapplydata.phone}} | Call
You have successfully applied. Need to upgrade your plan to view contact details of client. Upgrade Plan
Job Category : Information Technology & Services
Duration : 6-12  Month
Key Skills Required Skills
SQL PL/SQL
Description

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

Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

Loading