Job Description
● 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
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)
● 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
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)
💡 Quick Summary
Seeking a career-building opportunity? The PL|SQL Developer |Fresher position is now open for candidates interested in the Fresher Jobs sector. This role in Mumbai offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Fresher Jobs is a plus.
