The Oracle PL/SQL Developer role is responsible for designing, developing, and optimizing database solutions that support business and product requirements. This role requires deep expertise in Oracle SQL and PL/SQL, strong analytical capability, and the ability to translate complex functional requirements into scalable technical solutions. The individual will work closely with stakeholders and clients to understand requirements, prepare technical and functional specifications, and deliver high-quality solutions within planned timelines. Experience in the insurance domain will be an added advantage, along with openness to learning Majesco product functionality and related tools such as Dev Studio.
Key Responsibilities- Develop, maintain, and enhance complex SQL and PL/SQL programs, including stored procedures, packages, functions, triggers, views, and materialized views
- Work extensively on advanced PL/SQL programming concepts such as bulk handling, pipelined functions, analytical queries, collections, object types, and ref cursors
- Analyze complex requirements and break them down into structured technical solutions and delivery plans
- Perform performance tuning, profiling, and monitoring of slow-performing SQL queries and database programs
- Prepare technical and functional specification documents based on business and system requirements
- Collaborate with internal teams and clients to gather, clarify, and refine requirements
- Participate in code reviews, unit test plan reviews, and other quality review processes to ensure robust and reliable delivery
- Identify, track, and escalate issues that may impact development, testing progress, or delivery timelines
- Contribute to design and implementation activities with a strong focus on functionality development
- Continuously build understanding of Majesco product functionality and related development frameworks, including Dev Studio
- Strong experience in Oracle Database with advanced SQL and PL/SQL knowledge
- Expertise in developing complex SQL queries and PL/SQL-based database components
- Hands-on experience with performance tuning and optimization of SQL and PL/SQL code
- Strong analytical and logical thinking skills, especially in data analysis and understanding functional code
- Experience in functionality development, design, and implementation
- Ability to prepare technical and functional specifications from business requirements
- Experience in client communication for requirement gathering and clarification
- Insurance domain experience will be a significant advantage
- Willingness to learn new tools, frameworks, and Majesco product functionality
- Ability to work effectively in quality-focused environments with active participation in review processes
- Strong analytical thinking
- Ownership and problem-solving mindset
- Learning agility and openness to new tools
- Curiosity to understand product functionality deeply
- Ability to simplify complex requirements into clear delivery plans
Skills Required
- Advanced Oracle Database, SQL and PL/SQL knowledge (stored procedures, packages, functions, triggers, views, materialized views)
- Hands-on experience with advanced PL/SQL concepts (bulk handling, pipelined functions, analytical queries, collections, object types, ref cursors)
- Experience with performance tuning, profiling, and monitoring of SQL and PL/SQL code
- Ability to analyze complex requirements and produce technical and functional specification documents
- Experience in functionality development, design, implementation, and participating in code/review and testing processes
- Experience in client communication for requirements gathering and clarification
- Strong analytical and logical thinking skills
- Familiarity with Majesco product functionality and Dev Studio or willingness to learn them
- Insurance domain experience
Majesco Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Majesco and has not been reviewed or approved by Majesco.
-
Leave & Time Off Breadth — Flexible or unlimited PTO, paid holidays, and strong support for remote work are widely highlighted. Time-off policies feel generous and practical for work-life balance.
-
Healthcare Strength — Health insurance is considered solid and comparable to larger tech firms, with a global EAP also emphasized. Core medical coverage appears to be a dependable part of the package.
-
Career-Linked Recognition & Rewards — An employee recognition program and structured development paths (iLearn, CLIMB) are prominently featured. These elements add non-cash value alongside base pay.
Majesco Insights
What We Do
Majesco is the partner P&C and L&A insurers choose to create and deliver outstanding experiences for customers. We combine our technology and insurance experience to anticipate what’s next, without losing sight of what’s important now. Over 350 insurers, reinsurers, brokers, MGAs, and greenfields/startups rely on Majesco’s SaaS platform solutions of core, digital, data & analytics, distribution, and a rich ecosystem of partners to create their next now. As an industry leader, we don’t believe in managing risk by avoiding change. We embrace change, even cause it, to get and stay ahead of risk. With 900+ successful implementations we are uniquely qualified to bridge the gap between a traditional insurance industry approach and a pure digital mindset. We give customers the confidence to decide, the products to perform, and the follow-through to execute. For more information, please visit www.majesco.com.
