Oracle Lead

Impetus Technologies

India

Hybrid

INR 600,000 - 900,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Impetus Technologies is seeking a skilled Oracle PL/SQL Developer to design and develop database-driven workflow solutions supporting employee onboarding and training. The role requires strong experience in PL/SQL and database design.

Key responsibilities include developing PL/SQL packages, implementing role-based task management, and integrating systems like Learning Management Systems. The ideal candidate should be capable of translating business requirements into technical designs.

Qualifications

  • Strong experience with Oracle PL/SQL, packages, procedures, and triggers.
  • Hands-on experience in workflow-driven applications and task orchestration.
  • Experience integrating enterprise systems like LMS or HR systems.

Responsibilities

  • Design and develop PL/SQL packages, procedures, and triggers.
  • Implement role-based task management for onboarding activities.
  • Integrate onboarding platform with internal systems like LMS.

Skills

Oracle PL/SQL
Database design
Performance tuning
Workflow-driven applications
AutoSys job scheduling
Java understanding

Job description

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:
    • Hiring Managers to manage employee onboarding activities
    • 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
Required Skills & Experience
  • Strong experience in:
    • Oracle PL/SQL (packages, procedures, triggers)
    • Database design and performance tuning
  • Hands-on experience with:
    • Workflow-driven applications and task orchestration
    • AutoSys job scheduling and JIL scripting
    • Java understanding
  • Experience integrating enterprise systems (e.g., LMS or HR systems)
  • Strong understanding of:
    • Data processing pipelines and batch job dependencies
    • Role-based access and workflow management
  • Ability to convert business requirements into scalable technical solutions
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

PLSQL lead
PLSQL lead

Infosys • Bengaluru

On-site
INR 1,200,000 - 2,200,000
Oracle Developer
Oracle Developer

Comunus Technologies • Mumbai

On-site
INR 900,000 - 1,500,000
Oracle PL/SQL Developer
Oracle PL/SQL Developer

Weekday AI • Bengaluru

On-site
INR 500,000 - 1,000,000
Oracle PL/SQL Developer
Oracle PL/SQL Developer

Closing Gap • Chennai District

On-site
INR 800,000 - 1,400,000
Oracle PL/SQL Developer
Oracle PL/SQL Developer

Recmatrix Consulting • Bengaluru

On-site
INR 800,000 - 1,200,000
Lead - Oracle Developer
Lead - Oracle Developer

Anoud Technologies LLC • Chennai

On-site
INR 2,500,000 - 4,000,000
Oracle PL/SQL Developer
Oracle PL/SQL Developer

The Closing Gap • Chennai

On-site
INR 600,000 - 900,000
Oracle PL/SQL Developer
Oracle PL/SQL Developer

Infotel UK Consulting • Maharashtra

On-site
INR 1,500,000 - 2,500,000
Hiring: Oracle Developer (PL/SQL)
Hiring: Oracle Developer (PL/SQL)

Aabasoft Inc. • Ernakulam

On-site
INR 800,000 - 1,400,000
Oracle PL/SQL Developer
Oracle PL/SQL Developer

InfoBeans • India

On-site
INR 1,200,000 - 1,800,000