Job Description

We are looking for a skilled Oracle PL/SQL Developer to design and develop database-driven workflow solutions

supporting employee onboarding and training processes.

The role focuses on building robust backend logic, workflow orchestration, and system integrations, ensuring

seamless onboarding experiences and efficient task management across business stakeholders.

Roles & Responsibilities

Key Responsibilities

Database Development & Workflow Logic

 Design and develop PL/SQL packages, procedures, and triggers to support onboarding workflows

and task orchestration

 Build database-driven business logic to manage sequencing and dependencies of onboarding

activities

 Ensure data integrity, performance optimization, and scalability of database solutions

Workflow & Role-Based Processing

 Implement role-based task management:

o Hiring Managers to manage employee onboarding activities

o Academy Managers to control and schedule training programs

 Develop logic to dynamically assign and track onboarding tasks based on roles and workflows

System Integration

 Integrate onboarding platform with internal systems such as Learning Management Systems (LMS)

 Enable automatic assignment of induction and compliance training courses based on onboarding

workflows

Job Scheduling & Automation

 Create and manage batch jobs using AutoSys (JIL scripts)

 Configure job dependencies (predecessor/successor relationships) to process employee data from

upstream systems

 Ensure reliable and efficient data processing pipelines

Requirements & Design Collaboration

 Collaborate with functional and business teams to gather requirements

 Translate business requirements into technical designs and database solutions

 Participate in design reviews and provide recommendations for system improvements

Page 5 of 3

Required Skills & Experience

 Strong experience in:

o Oracle PL/SQL (packages, procedures, triggers)

o Database design and performance tuning

 Hands-on experience with:

o Workflow-driven applications and task orchestration

o AutoSys job scheduling and JIL scripting

o Java understanding

 Experience integrating enterprise systems (e.g., LMS or HR systems)

 Strong understanding of:

o Data processing pipelines and batch job dependencies

o Role-based access and workflow management

 Ability to convert business requirements into scalable technical solutions

About the job