PLSQL Developer

Job description:

Employment Type: Full-Time
Experience: 2 to 5 Years
Location: Navi Mumbai (Local Candidates Preferred)
CTC:

• 2–3 Years: ₹3.5 LPA (Based on skills and performance)
• 3–5 Years: ₹5.4 LPA (Based on skills and performance)
• 5-8 Years: Up to ₹7.5 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: ₹300,000.00 - ₹750,000.00 per year

Ability to commute/relocate:

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

Work Location: In person