PL/SQL Developer (Fresher)

Overview

● 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

Education Qualification:

Preferred certifications:

PL/SQL Developer Certified Associate

Qualification:

B.Tech/M.Tech/MS/BE/B.SC IT

Preferred Location: (Mumbai) Thane, Mulund, Bhandup, Vikroli, Ghatkopar, Kurla and Powai

Notice Period: We need Immediate Joiner.

Job Types: Full-time

Job Type: Full-time

Pay: ₹5,000.00 - ₹7,000.00 per month

Benefits:

• Flexible schedule

Schedule:

• Day shift
• Monday to Friday
• Morning shift
• Weekend availability

Supplemental Pay:

• Performance bonus

Ability to commute/relocate:

• Mumbai, Maharashtra: Reliably commute or planning to relocate before starting work (Required)

Experience:

• total work: 1 year (Preferred)