Specialist - Oracle Forms & Reports

Lennox India Technology Centre; Chennai District; On-site; INR 800,000 - 1,400,000; Full time

Job summary

A technology firm in Chennai is seeking an experienced Oracle Forms Analyst to support its NDS ERP system. This role involves application support, analysis of business requirements, and development of Oracle Forms, Reports, and PL/SQL solutions. The ideal candidate will have over 8 years of experience and a degree in Information Systems or a related field. Successful applicants will be integral in ensuring system reliability and performance while working within a collaborative environment.

Qualifications

• 8+ years of experience supporting Oracle Forms–based ERP systems.
• Strong hands-on experience with Oracle Forms, Oracle Reports, and PL/SQL.
• Proficiency in SQL and Oracle database concepts.

Responsibilities

• Provide daily application support for the NDS ERP system.
• Analyze business requirements and translate them into technical solutions.
• Design, develop, and maintain Oracle Forms, Reports, and PL/SQL packages.

Skills

Oracle Forms

Oracle Reports

PL/SQL

SQL

Analytical skills

Problem-solving skills

Education

Bachelor’s degree in Information Systems or related field

Job description

The Oracle Forms Analyst – NDS ERP Analyst is responsible for the analysis, development, maintenance, and support of the NDS Enterprise Resource Planning (ERP) system built on Oracle Forms, Reports, and PL/SQL. This role supports mission‑critical business processes by ensuring system reliability, performance, data integrity, and alignment with business requirements. The analyst works closely with business partners, functional analysts, DBAs, and technical teams to enhance and sustain the NDS ERP platform.

Key Responsibilities

• Provide daily application support for the NDS ERP system, including issue analysis, troubleshooting, and resolution
• Analyze business requirements and translate them into technical solutions within the NDS ERP framework
• Design, develop, and maintain Oracle Forms, Oracle Reports, and PL/SQL packages, procedures, and triggers
• Perform enhancements, bug fixes, and minor redesigns to existing NDS ERP modules
• Ensure data integrity, system stability, and performance across ERP functions
• Support ERP releases, patches, and version upgrades, including regression testing and validation
• Collaborate with functional users to understand workflows, document requirements, and recommend system improvements
• Conduct root‑cause analysis for production issues and implement long‑term corrective solutions
• Maintain technical documentation, design specifications, and support procedures for NDS ERP components
• Ensure compliance with organizational standards for security, auditing, and change management
• Participate in on‑call or after‑hours support as required for critical system operations

Required Qualifications

• Bachelor’s degree in Information Systems, Computer Science, or a related business field (or equivalent experience)
• 8+ years of experience supporting Oracle Forms–based ERP systems
• Strong hands‑on experience with Oracle Forms, Oracle Reports, and Oracle PL/SQL
• Proficiency in SQL and Oracle database concepts
• Experience supporting custom ERP modules and complex business logic
• Familiarity with full SDLC processes, including requirements, development, testing, and production support
• Strong analytical, troubleshooting, and problem‑solving skills
• Ability to work effectively with both technical teams and business stakeholders
• Must be willing to work in shift from Office ( Chennai) Monday to Friday