Oracle Forms SME

Kumaran; Chennai; On-site; INR 2,400,000 - 4,000,000; Full time

Job summary

Kumaran Systems in Chennai is seeking an experienced Oracle Forms SME to lead the analysis, reverse engineering, and migration of legacy Oracle Forms applications to modern Python/Django web applications.

The candidate should master Oracle Forms 4.5/6i/10g/11g/12c, Oracle Database, SQL and PL/SQL, and document dependencies while coordinating with business analysts and developers to ensure functional parity during migration.

Qualifications

• 10–15 years of experience in Oracle Forms and related technologies.
• Strong hands-on experience with Oracle Forms 4.5/6i/10g/11g/12c.
• Expertise in Oracle Database, SQL, and PL/SQL.
• Knowledge of Forms triggers, LOVs, record groups, canvases, and data blocks.
• Experience with Oracle Reports, stored procedures, packages, and performance tuning.
• Ability to work with Python/Django development teams.

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.

Skills

Oracle Forms versions

Oracle Database

PL/SQL

Forms triggers

Oracle Reports

Reverse engineering

Technical documentation

Python/Django integration

Data migration

Tools

Python

Django

Oracle Reports

Job description

Kumaran Systems: Engineering Future-Ready Transformations Since 1992, Kumaran Systems has been helping enterprises bridge the past and the future, reimagining legacy systems and embracing AI-led possibilities. With over 34 years of delivery excellence, we specialise in re-engineering core applications, driving cloud transformation, and building automation-first, GenAI-enabled ecosystems across the Banking and Financial Services, Insurance, Telecom, and Automotive sectors. We help organisations not just upgrade their systems but reimagine what’s possible.

Why Kumaran?

We blend engineering discipline with AI innovation, helping clients modernise with confidence, automate with clarity, and scale with purpose. Our global delivery model ensures agility, responsiveness, and seamless collaboration, with clients always at the heart of every engagement. At Kumaran, we don’t just solve problems, we engineer future-ready transformations.

Job Description

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

The candidate should have experience in Oracle Forms (Legacy Migration), specialised in different versions from legacy versions to 12c.

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.

Preferred: and NOT MANDATORY.

• Experience in Oracle Forms modernization or migration projects.
• Experience in enterprise application transformation and data migration.

Kumaran Systems is an Equal Opportunity Employer and does not discriminate on the basis of race or ethnicity, religion, sex, national origin, age, veteran disability or genetic information or any other reason prohibited by law in employment.