Additional Details
| Designation |
PL/SQL Developer |
| Function Area |
IT Software - DBA |
| Industry |
|
| Job Type |
Full-time | 10am-7pm |
| Benefits |
|
| Posted On |
July 8, 2023 |
| Company |
Private |
| Educational |
Graduate |
| Desired Skills |
|
| Qualifications |
Graduate |
| Responsibilities |
PL/SQL Developer |
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
