Oracle Forms SME

Experience: 10 years to 15 years

Job Description:

We are looking for an experienced Oracle Forms SME to support the analysis, reverse engineering, and migration of legacy Oracle Forms applications to modern Python/Django web applications

Key Responsibilities:

•              Analyze existing Oracle Forms applications, triggers, workflows, and embedded business logic. 

•             Review PL/SQL packages, procedures, functions, database triggers, and SQL queries.

•              Identify dependencies between Forms modules, database objects, reports, and external interfaces.

•              Document existing application functionality, business rules, and technical dependencies.

•              Support mapping and migration of legacy functionality to Python/Django applications.

•              Collaborate with business analysts, architects, developers, and QA teams.

•              Validate database operations, data integrity, and functional parity during migration.

•              Troubleshoot complex application and database issues.

Required Skills:

•              Strong hands-on experience with Oracle Forms 4.5/6i/10g/11g/12c.

•              Expertise in Oracle Database, SQL, and PL/SQL.

•              Good understanding of Forms triggers, LOVs, record groups, canvases, and data blocks.

•              Experience with Oracle Reports, stored procedures, packages, and database performance tuning.

•              Strong skills in legacy application analysis, reverse engineering, and technical documentation.

•              Ability to work closely with Python/Django development teams.

•              Oracle Jobs & Reports

Preferred: and NOT MANDATORY.

•              Experience in Oracle Forms modernization or migration projects.

•              Experience in enterprise application transformation and data migration.

•              Pro c Knowledge

•              Shell Scripts