Job Title: PL/SQL DeveloperPay Range: 15-18 lakhs per annumDuration: UP to 1-year contract with likely extensionNotice Period: NEED TO START ASAP - ONLY ACCEPTING CANDIDATES WHO CAN JOIN WITHIN TWO WEEKS OF OFFERInterview Process: Priority scheduling for candidates who message on LinkedIn with resumeJob 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 doBuild detail & summarized data structures within reporting & analytics data layer to support development of complex and comprehensive dashboards & reportsWork independently and collaboratively with data engineers, data scientists, data visualization team, and subject matter experts to design backend database objectsEvaluate 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.
Job Title
PL/SQL Developer