Senior Software Engineer - Oracle Forms & Reports

Path Solutions; Chennai District; On-site; INR 900,000 - 1,100,000; Full time

Job summary

Path Solutions in Chennai seeks a Senior Oracle Forms & Reports Developer with 5+ years of hands-on experience to design, develop and maintain enterprise applications. You will optimize PL/SQL and SQL, build robust database objects, and assist with upgrades from older Forms/Reports to 12c/14c.

Collaboration with QA, BAs, and development teams is essential for successful UAT and production support. The role requires strong debugging skills, experience with external integrations (Java, web

Qualifications

• 5+ years of Oracle Forms and Reports development experience.
• Advanced skills in Oracle SQL and PL/SQL, including triggers, packages, procedures and functions.
• Experience with multiple Oracle DB versions and performance tuning.

Responsibilities

• Design, develop, and maintain Oracle Forms (10g–14c) and Oracle Reports.
• Develop and optimize PL/SQL packages, procedures, functions, and triggers.
• Analyze requirements and translate into technical specifications.
• Migrate/upgrade legacy Forms/Reports to 12c/14c and tune performance.
• Collaborate with QA, BA, and cross-functional teams for testing and UAT.

Skills

Oracle Forms & Reports development

PL/SQL programming

SQL query optimization

Unix/Linux scripting

Agile/Scrum

Tools

SQL Developer

TOAD

Job description

Job Summary

Role Summary: We are seeking a skilled Oracle Forms and Reports Developer who brings a wealth of experience in Oracle D2K, SQL, PL/SQL, and enterprise application development. The successful candidate will demonstrate a proven track record in designing, developing, enhancing, and maintaining robust business applications utilising Oracle Forms (versions 10g/11g/12c/14c) and Oracle Reports. This role requires hands-on expertise in building and optimising database-driven solutions, with the ability to translate complex business requirements into effective technical solutions. The ideal applicant should be adept at developing and fine-tuning PL/SQL packages, procedures, functions, triggers, and views, ensuring efficient and reliable performance. Experience with performance tuning of PL/SQL code and SQL queries is essential. The candidate should also possess solid skills in debugging and troubleshooting application issues across Oracle Forms, Reports, and PL/SQL programmes. Additionally, the role demands proficiency in migrating and upgrading legacy Oracle Forms/Reports applications to newer platforms (such as 12c/14c), as well as designing and modifying data models, tables, indexes, and other key database objects. Familiarity with integrating Oracle Forms and Reports with external systems (including Java components, web services, and CSV/XML outputs) will be highly valued. Effective collaboration with QA teams, Business Analysts, and other cross-functional stakeholders for system testing and user acceptance testing is also a critical aspect of this position.

Job Details

• Job Title: Senior Software Engineer - Oracle Forms & Reports
• Years of Experience: 5 to 7 years
• Location: Chennai

Responsibilities

• Responsible for designing, developing, and maintaining applications utilizing Oracle Forms (10g/11g/12c/14c) and Oracle Reports.
• Develop and optimize PL/SQL packages, procedures, functions, triggers, and views in alignment with application requirements.
• Analyze business requirements and translate them into comprehensive technical specifications.
• Perform performance tuning of PL/SQL code and SQL queries to ensure optimal efficiency.
• Diagnose and resolve issues within Oracle Forms, Reports, and PL/SQL programs.
• Execute migration and upgrade activities for Oracle Forms/Reports applications to current versions (12c/14c).
• Create and revise data models, tables, indexes, materialized views, and other database objects as needed.
• Integrate Oracle Forms & Reports seamlessly with external systems, including Java components, web services, and CSV/XML outputs.
• Collaborate effectively with QA, Business Analysts, and cross-functional teams to facilitate system testing and user acceptance testing (UAT).
• Deliver production support, conduct root cause analysis, and carry out ongoing performance optimization.

Requirements

• 5+ years of Oracle Forms and Reports development experience
• Advanced skills in Oracle SQL and PL/SQL (triggers, packages, procedures, functions, query optimization)
• Experience with Oracle Database versions 10g to 23ai
• Strong grasp of database design, normalization, and data modeling
• Skilled in debugging and troubleshooting PL/SQL
• Familiar with deployment tools like SQL Developer and TOAD
• Proficient with Unix/Linux scripts and automation
• Comfortable working in Agile/Scrum teams
• Insurance sector experience preferred
• Experience with Premia or Beyontec products an advantage

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.