Oracle F&R and PL / SQL Developer

Job Requirement

• 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.
• Having exposure to JavaScript and ReactJS 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: 6th Floor, Block 2, The Lords Plot Nos. 1 & 2, (NP), Northern Extn Area, Thiru Vi Ka Industrial Estate, Ekkatuthangal, Guindy, Chennai - 600032.