Lead I - Software Engineering

0 years

0 Lacs

Posted:1 day ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Role Description

Role(s):

PL/SQL & API Developer

Role Location(s):

Offshore

Planned Start Date:

1/12/2026

Planned End Date:

7/10/2026

Project Overview:

The Project-Specific Training Automation (PSTA) initiative is focused on improving how project-specific training requirements are assigned and managed for study team members. The project will deliver a streamlined, standardized process supported by an internal application that helps ensure team members receive the correct training based on their role and study involvement. The goal is to reduce manual effort, improve consistency, and make it easier for teams to manage and track training needs across projects.

Role Scope / Deliverables:

The contractor will provide development services involving Oracle PL/SQL, Oracle APEX, and integration components required to support data exchange between an Oracle Database and the Learning Management System (LMS). Work will be performed in collaboration with the CRG IT development team, following established coding, documentation, version-control, and review standards. All deliverables must be original, testable, maintainable, and aligned to project architecture and guidelines.

Responsibilities

  • API Integration Development
  • Develop PL/SQL packages, procedures, and functions to support secure, reliable REST-based integrations with the LMS.
  • Implement logic for extraction, transformation, loading, error handling, and retry logic.
  • Structure data according to LMS API requirements.
  • Oracle APEX Development
  • Support development or enhancement of APEX UI components including pages, forms, reports, validations, and process logic.
  • Align work with functional requirements and existing Study Inventory architecture.
  • Testing & Code Review
  • Conduct unit testing of all deliverables.
  • Participate in peer code reviews and provide technical feedback.
  • Ensure performance, maintainability, and compliance with coding standards.
  • Documentation & Compliance
  • Provide documentation for all code, integrations, and APEX components.
  • Follow CRG IT quality, security, and validation expectations.
Deliverables
  • Complete PL/SQL integration packages supporting LMS REST API interactions.
  • APEX UI components aligned with functional requirements.
  • Unit test cases and execution results for all assigned work.
  • Peer review feedback and incorporated revisions.
  • Final source code and documentation stored in the required repository.

Key Skills

  • Oracle PL/SQL (must-have / non-negotiable)
  • Experience with LMS APIs (SumTotal / Cornerstone REST APIs strongly preferred)
  • Hands-on REST API integration experience, including:
  • JSON request/response handling
  • Authentication mechanisms
  • Error handling and retries
  • Understanding and interpreting third-party API documentation
  • Oracle APEX development experience
  • Ability to collaborate with internal SMEs to align on LMS data model and requirements
  • Strong debugging and performance tuning skills
  • Experience delivering maintainable, well-documented code in a regulated (validated) environment preferred

Skills

plsql,pl/sql,rest api,json,oracle apex,debugging,

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
UST logo
UST

IT Services and IT Consulting

Aliso Viejo CA

RecommendedJobs for You

hyderabad, telangana, india

chennai, tamil nadu, india