Role & responsibilities -

Total Exp 2 to 6Years

Job locations Mumbai or Pune

Work Mode Work from Office .

Clover Infotech Pvt Ltd for Oracle PLSQL requirement

Company Details - For more details you can visit the website at www.cloverinfotech.com

- Candidate should have good communication.
- Should be confident to understand the requirement and implement independently.
- Should have good knowledge in advance PLSQL
- Should have exposure on collection, processing data using bulk collect concept
- Should have knowledge of bulk exception, save exception , user defined exceptions concepts.
- Expertise in creating complex query using correct joins.
- Knowledge in Materialized view , Oracle schedular
- Should have knowledge in basic performance tuning concepts like reading explain plan, creating indexes, partitioning the table.
- Knowledge on Shell script, Sql loader, Integration REST APIs, File-based, JAVA would be an added advantage
- Type of joins (Equi join,



left join, right join, full join & dross join)
- Procedure, function, package
- package overloading
- type of iterations like FOR LOOP, DO WHILE etc
- bulk collection and bulk bindings
- merge statement
- ref cursor
- current of clause
- triggers & instead of trigger
- easy view & materialized view
- table partitioning and their types
- analytical functions
- Exception handling and their types
- PLSQL data types - ASSOCIATIVE ARRAY, NESTED TABLE & VARRAY
- Rollback,commit & rollback to save point.

Interested candidates can share details on [email protected]

share details -

total exp -

ctc -

ectc -

notice period -

current location -

Are you okay to relocate to Mumbai or Pune - (Yes/No )

Are you okay for F2F interview 2nd Round -Yes/NO

📌 PLSQL Developer (Navi Mumbai)
🏢 Clover Infotech
📍 Navi Mumbai