Reference # 18-01180 Title Oracle pl / SQL
Location OAKS, PENNSYLVANIA
Position Type Full Time/Contract
Experience Level Full Time/Contract
Start Date / End Date 21-06-2018 --- 30-11--0001
Description
 NIIT
OAKS PA

PRIMARY RESPONSIBILITIES:
Develop, test and support solutions utilizing Oracle RDBMS
Work with Product Owner and Scrum Master to assess impact and provide estimates.
Provide support and on-the-job training to less experienced team members
Interact with client on scrum calls to understand requirement
Work on Support & Maintenance items
 
REQUIRED SKILLS
5+ years of experience in Oracle PL/SQL
Strong development skills in SQL & PL/SQL
-          Good in SQL functions and writing nested queries
-          Collections
-          Proficient in writing procedures, functions and packages
-          Handling of external files /data using data load
-          Partitioning
-          Indexes
-          Guidelines for SQL tuning
-          Basic Analytical functions
Strong development skills in Advance SQL & Advance PL/SQL
-          Proficient in understanding and writing complex queries
-          Analytical Functions
-          Error Handling
-          Pragmas
-          Performance Tuning
Understanding of Data architecture structures
Exposure to data modeling techniques
Good communication skills
Self-starter capable of working independently

DESIRED SKILLS
Agile work experience
Prior experience of IT implementation in BFS