PLSQL Developer

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
• simple 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 removed]

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