Oracle PL/SQL Developer

Overview

Employment Type: Full-Time
Experience: 2 to 5 Years
CTC:

• 2–3 Years: ₹4.8 LPA (Based on skills and performance)
• 3–5 Years: ₹6.0 LPA (Based on skills and performance)
• 5+ Years: Up to ₹7.8 LPA (Based on skills and performance)

Job Summary:
We are looking for an experienced Oracle Forms and Reports Developer to design, develop, and maintain Oracle applications and reports. The ideal candidate should have strong expertise in SQL, PL/SQL, Oracle Forms 11g/12c, Reports 11g/12c, and performance tuning, with a focus on delivering robust and scalable solutions.

Key Responsibilities:

• Develop, enhance, and maintain Oracle Forms 11g/12c and Reports 11g/12c.
• Write and optimize complex SQL queries, joins, stored objects, triggers, and functions.
• Develop and manage PL/SQL procedures, functions, triggers, packages, and cursors.
• Implement Exception Handling and various Cursor types effectively for robust application performance.
• Work with UTL packages for file handling, email processing, etc.
• Execute DML operations and manage data manipulation requirements.
• Perform ETL activities, including data extraction, transformation, and loading between systems.
• Collaborate with teams to implement integrations via Oracle Fusion Middleware.
• Conduct SQL performance tuning and query optimization to enhance application efficiency.
• Troubleshoot, debug, and resolve application issues in a timely manner.

Required Skills:

• Strong hands-on experience with Oracle Forms 11g/12c and Reports 11g/12c.
• Proficiency in SQL Query writing, Stored Objects, Joins, and Triggers.
• Sound knowledge of PL/SQL including functions, procedures, exception handling, and cursor usage.
• Experience with UTL packages (UTL_FILE, UTL_MAIL, etc.).
• Practical understanding of DML statements and database operations.
• Exposure to ETL processes and data migration activities.
• Familiarity with Oracle Fusion Middleware is desirable.
• Strong SQL Tuning and performance optimization skills.

Qualifications:

• Bachelor's Degree in Computer Science, IT, or related discipline.
• Oracle certifications are an advantage.

Desired Attributes:

• Problem-solving mindset with attention to detail.
• Ability to handle complex application requirements independently.
• Good communication and documentation skills.
• Team player with a willingness to learn and grow.

Job Type: Full-time

Pay: ₹200,000.00 - ₹750,000.00 per year

Schedule:

• Day shift
• Morning shift

Ability to commute/relocate:

• Navi Mumbai, Maharashtra: Reliably commute or planning to relocate before starting work (Required)

Education:

• Bachelor's (Required)

Location:

• Navi Mumbai, Maharashtra (Required)

Work Location: In person