1. Having experience in Oracle SQL & PLSQL Development with minimum 10 to 12 years of experience.
2. Experience in developing Procedures, Functions, Triggers, Cursors and Packages.
3. Experience in using advanced features like BULKCOLLECT, FORALL and Ref cursors.
4. Good exposure to SQL queries and handling Exceptions in PLSQL.
5. Good exposure to writing dynamic functions, procedures and packages.
6. Worked with Tools like SQL*Plus and SQL Developer.
7. Expertise in Dynamic SQL, Collections, cursors, Exception handling.
8. Experience in stored procedures, functions and packages as per the business Requirement. Loaded external files Data into Oracle Tables using SQL Loader.
9. Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes and optimize procedures and packages.
10. Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
11. Development experience of materialized views for data replication in distributed environments.
12. Good to have: Knowledge Oracle database administration tasks include configuration management, backup/recovery, performance optimization, and space management.

Required candidate skill set:

Experience in Oracle SQL & PLSQL Development.
Procedures, Functions, Triggers, Cursors and Packages.
Good exposure to writing dynamic functions, procedures and packages.
Worked with Tools like SQL*Plus and SQL Developer.
Version control systems like SVN Git
Expertise in Dynamic SQL, Collections, cursors, Exception handling.
Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
5 Years of experience

Compensation details :

CTC 10L to 14L with other company benefits

Interested candidate can send their resume to hr@isbsindia.in