● 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: ₹25,000.00 - ₹40,000.00 per month Benefits: Health insurance Provident Fund 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)