Oracle APEX / Integration Consultant

Tata Consultancy Services; New Delhi; On-site; INR 1,800,000 - 4,000,000; Full time

Job summary

Tata Consultancy Services is seeking an Oracle APEX Integration Consultant with 8–10 years of experience to design, develop, and maintain enterprise-grade integrations and APEX applications in India. You will work on REST and SOAP services, perform data transformations, and ensure secure, scalable cloud-based solutions.

You will collaborate with cross-functional teams to align integration patterns with business needs, optimize PL/SQL and database objects, and deliver reliable connectivity

Qualifications

• Strong expertise in Oracle APEX development with hands-on SQL, PL/SQL, Forms, Interactive Reports, and workflow-based app development.
• Experience designing and implementing integrations using Oracle Integration Cloud (OIC), REST APIs, and SOAP web services.
• Proficiency in API design, development, consumption, and integration orchestration across enterprise apps.
• Deep understanding of Oracle Database architecture, PL/SQL optimization, data modelling and validation.
• Experience with Oracle Fusion ERP APIs, Fusion REST Services, and SaaS extension frameworks.
• Knowledge of real-time, batch, and event-driven integration patterns.

Responsibilities

• Design, develop, and support Oracle APEX apps using Forms, Interactive Reports, workflows, and REST-enabled services.
• Build and manage enterprise integrations with OIC, ensuring connectivity between Fusion apps and external systems.
• Design, develop, and consume REST and SOAP web services with enterprise security standards.
• Develop API-based solutions involving data transformation, mapping, orchestration, and error handling.
• Collaborate with stakeholders to translate requirements into scalable technical solutions.
• Tune Oracle Database objects and PL/SQL programs to optimize performance.
• Integrate Oracle Fusion ERP modules using Fusion REST Services, FBDI, and other Oracle methods.
• Implement secure integrations using OAuth and token-based authentication.
• Support testing, deployment, production issue resolution, and continuous improvement.
• Prepare technical documentation and share Oracle APEX, OIC, and fusion integration best practices.

Skills

Oracle APEX

SQL

PL/SQL

Forms

Interactive Reports

Workflow-based development

Tools

Oracle Integration Cloud (OIC)

REST APIs

SOAP web services

Fusion REST Services

OAuth

JSON/XML processing

Performance tuning

Job description

Role : Oracle APEX Integration Consultant

Experience: 8-10 Years

Required Technical Skill Set

Oracle APEX (SQL, PL/SQL, Forms, Reports, Workflows)

REST & SOAP APIs

API Development & Integration

Oracle Database & PL/SQL

Oracle Fusion ERP APIs

Fusion REST Services

JSON/XML Processing

OAuth & Token-based Authentication

Performance Tuning & Debugging

SaaS Extensions & Cloud Integrations

Must-Have

Strong expertise in Oracle APEX development with hands-on experience in SQL, PL/SQL, Forms, Interactive Reports, and workflow-based application development.

Experience designing and implementing integrations using Oracle Integration Cloud (OIC), REST APIs, and SOAP web services.

Proficiency in API design, development, consumption, and integration orchestration across enterprise applications.

Strong understanding of Oracle Database architecture, PL/SQL optimization, data modelling, and data validation techniques.

Experience working with Oracle Fusion ERP APIs, Fusion REST Services, and SaaS extension frameworks.

Knowledge of integration patterns including real-time, batch, and event-driven architectures.

Hands-on experience with JSON/XML processing, data transformation, and secure integrations using OAuth and token-based authentication.

Ability to troubleshoot application and integration issues, perform performance tuning, and deliver scalable cloud-based solutions.

Good-to-Have

JSON/XML expertise

OAuth security knowledge

Exposure to BICC, FBDI and OTBI

Responsibility of / Expectations from the Role

• Design, develop, and support Oracle APEX applications, leveraging Forms, Interactive Reports, workflows, and REST-enabled services to address business requirements.
• Build and manage enterprise integrations using Oracle Integration Cloud (OIC), ensuring reliable connectivity between Oracle Fusion applications and external systems.
• Design, develop, and consume REST and SOAP web services while adhering to enterprise integration and security standards.
• Develop robust API-based solutions involving data transformation, mapping, orchestration, and exception handling across multiple applications.
• Collaborate with business stakeholders, functional consultants, and technical teams to analyze requirements and translate them into scalable technical solutions.
• Optimize Oracle Database objects, PL/SQL programs, and application performance through effective tuning, debugging, and best-practice implementation.
• Integrate Oracle Fusion ERP modules using Fusion REST Services, FBDI, BICC, and other Oracle-recommended integration approaches.
• Implement secure integration frameworks using OAuth, token-based authentication, and industry-standard security practices to protect enterprise data.
• Support application testing, deployment, production issue resolution, and continuous improvement initiatives to ensure operational stability and performance.
• Prepare technical documentation, contribute to knowledge-sharing activities, and provide guidance on Oracle APEX, OIC, and Fusion integration best practices across project teams.