Job Title: PL/SQL Developer

Pay Range: 15-18 lakhs per annum

Duration: UP to 1-year contract with likely extension

Notice Period: NEED TO START ASAP - ONLY ACCEPTING CANDIDATES WHO CAN JOIN WITHIN TWO WEEKS OF OFFER

Interview Process: Priority scheduling for candidates who message on LinkedIn with resume

Job Summary:

Seeking a skilled PL/SQL Developer to manage bulk data loads, exception handling, reporting/dashboard development, and date/string functions.

Key Responsibilities:

• Bulk Data Loads: Optimize bulk data loading using BULK COLLECT and FORALL; manage direct-path inserts.
• Exception Handling: Implement robust error handling with predefined and user-defined exceptions.
• Reporting/Dashboard Development: Develop interactive dashboards and reports using Oracle BI Publisher and APEX.
• Date/String Functions: Utilize PL/SQL date and string functions for data manipulation.

Qualifications:

• Bachelor's degree in Computer Science or related field.
• Proven experience as a PL/SQL Developer.
• Strong knowledge of Oracle database architecture and PL/SQL programming.
• Proficiency in SQL and PL/SQL performance tuning.
• Familiarity with data warehousing and ETL processes.
• Experience with version control systems and agile methodologies.

We are responsible for client reporting and internal program analytics for all care management products. We work with Product and Data Science teams to develop metrics for reports and dashboards. We also partner closely with several teams to develop the data feeds that drive impactful analytics. We are positioned to make a difference for the business and the customers.

What you will do

• Build detail & summarized data structures within reporting & analytics data layer to support development of complex and comprehensive dashboards & reports
• Work independently and collaboratively with data engineers, data scientists, data visualization team, and subject matter experts to design backend database objects
• Evaluate and interpret documented technical requirements and translate those into software deliverables.
• Develop database software components (procedures, packages, functions, etc.) that meet documented requirements.
• Identify and execute unit test cases required to validate software components.
• Peer review development deliverables for team members to confirm standards and best practices.