Oracle F & R and PL / SQL Developer

Job Summary

Oracle FR and PL / SQL Developer - Oracle Consulting Services | USA | 99% Customer Retention | Doyensys

Job Requirements

• Project Role: Oracle Forms Reports Developer
• Project Role Description: Oracle Forms Reports developer is responsible for maintenance, development and support of a existing custom ERP application built using Oracle Forms. Coordinate with the business users and understand the requirements and provide suitable solution.60% Development and 40% of support activities
• Work Experience: 3 to 5 yrs
• Work location: Chennai/Trichy

Technical Expertise - Must Have Skills

• Experience in Oracle Forms and Reports
• Should be familiar with various triggers, events , canvas, master child forms, record groups , build-ins, properties etc., in Forms and reports
• Experience in SQL / PLSQL concepts
• Experience in writing Procedure / Function / Packages Datatypes, Constraints , index
• Experience in the user of Cursors / Collections / Exception handling.
• Having exposure to JavaScript and ReactJS will be an added advantage.

Good To Have Skills

• Experience in production support and troubleshooting will be an added advantage.
• Unix Shell Scripting knowledge (Optional)

Key Responsibilities

• Very good PL/SQL development experience with complex stored procedures, packages, triggers, file operations, exceptions, and very solid debugging skills.
• Experience in query tunning.
• Experience in Ref cursor, Oracle collections and Materialized view.
• Strong Oracle forms development experience with different canvases, Master-detail relations, Dynamic Record Groups, LOV s, form triggers and debugging the forms application.
• Knowledge of Unix shell scripting.
• Self-driven and good problem-solving skills.
• Work in teams and independently if required.
• Experience in Agile scrum.
• knowledge in GIT.

Professional Attributes

• Should be able to work independently with minimal supervision.
• Should be willing to work in EST timing based on project requirements
• Communication should be excellent as the position requires direct interaction with business users from US.

Educational Qualification

B.E, B.TECH, Masters or Any graduation

Additional Information

• Job Location: Chennai

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.