Oracle PL/SQL Developer (Remote)
Job Details
Pl/sql developer
Location: Remote
Client-Conduent
W2/fulltime
Job Description:
• At least 1+ years of experience in DB projects
• Experience as an Oracle PL/SQL Developer.
• Strong skills in Oracle server-side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, Job, Schedulers, PL/SQL Web-services, Java Stored Procedures and Oracle AQ.
• Hands on experience on XML generation inside PL/SQL components.
• Strong Skills in data analysis, data modeling, development, testing and documentation.
• Strong skills on automating jobs using UNIX Shell scripts to run all the SQL files in a directory by invoking SQL *Plus.
• Hands on writing Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets, Arrays & Queues.
• Strong Skills in Exception Handling extensively debug PL/SQL Code, DDL, DML and display the error messages in the application.
• Experience in creating Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.