Job Description
Key Responsibilities
- Analyze the logic of Oracle Forms to understand the data flow and business logic contained within each form.
- Call APIs from Oracle Forms via wrappers as needed instead of relying solely on the built-in modifications directly onto the tables.
- Test each screen to ensure that no data is duplicated and the end-user will have no disruptions of their work due to the modifications.
- Analyze packages and processes to understand the logic and replace certain modifications for REST API calls.
- Test the packages to verify that the functionality isn't compromised.
Must-have Skills
- Oracle PL/SQL:
- Triggers
- Dynamic SQL
- Cursors
- Stored Procedures
- Package Managing
- Views
- Oracle Forms:
- Form Triggers
- Knowledge of the data flow within Oracle Forms
- Use of API and tools for consulting API: