Iris Software Pvt Ltd Looking for Capacity Offer – Database PLSQL at Noida Full Time

Job Summary

Standard Iris JD:

Primary Skills

Hands on in Oracle version 19c and 21c
Strong coding knowledge in PLSQL (Bulk Collect, Recursion, Loops (FOR, WHILE DO), Nested blocks, Exception Handling)
Strong Coding knowledge in SQL (Analytical functions, View and Materialized Views, Sys tables and Privileges)
Good understanding of Performance tuning concepts like Access Paths, Join methods, Partitioning, etc.

Secondary Skill :-
Awareness about Oracle data various dictionary and their significance.
Complex Queries : Nested queries, inline views, co-related subqueries
Awareness about Hierarchical queries

,