Oracle Developer / Oracle Lead

Job Description

Oracle PL/SQL / Oracle SQL - MUST (Should have Basic understanding of concepts and features of Oracle PLSQL , SQL – Joins, SQL Loader, External Table, UTL_FILE, Cursors, Exception Handling, Collections, Forall & save exceptions, Triggers, Oracle Queues, ORDS APIs, Performance Tuning, Analytical Functions, ETL , Unix Commands, Package utilities over standalone methods, Simple queries, Explicit Cursor Functionality and scenario (eg. Query to match the timeframe and get most stable price, Scenario to tune the performance for Deleting the records, Development Tools, SQL – Correct the data (eg Female to Male and Male to Female), Equi and Non-equi joins, Oracle Forms / Reports, Pro C / UNIX Shell Scripting, foreign key constraints, SQL – Analytical function use. Must be excellent in writing SQL Queries and Good in PLSQL Concepts, has worked on variety of oracle PLSQL tasks and knows the basics of them, should have skills to write solution as per requirement, Should be able to answer for some scenario based logical questions, Able to write normal sub-query and simple pl/sql block, Able to write the code snippet for the problems UNIX - Basic UNIX commands MUST have Knowledge of Basic SQL & PLSQL queries Tables, constraints, indexes, views, sequences and synonyms Packages, procedures, functions, triggers and using cursors, ref cursors, dynamic SQL with bind variable, bulk dml using pl/SQL arrays, nested tables and v-arrays.

Required Skills