[Hiring] Senior Technical Consultant @Kapital Data

Role Description

Kapital Data is seeking a highly skilled and proactive Senior Technical Consultant to lead the implementation, enhancement, and automation of our Oracle Fusion Supply Chain Management (SCM) integrations. In this role, you will be the core technical driver for connecting and optimizing our Inventory Management and Order Management modules.

• Design & Develop Integrations: Architect, build, and maintain end-to-end real-time and batch integrations using Oracle Integration Cloud (OIC) to connect Oracle Fusion SCM (Inventory & Order Management) with upstream/downstream enterprise applications.
• Custom Reporting & Extracts: Develop complex BI Publisher reports, RTF templates, eText templates, and financial/operational data extracts to support business process automation.
• API Architecture & Discovery: Review, analyse, and map complex data structures using Oracle REST and SOAP APIs. Actively research Oracle technical documentation to independently identify and implement optimal API endpoints.
• Testing & Quality Assurance: Validate and debug integration payloads, mappings, and endpoints using testing tools like Postman and SoapUI.
• Database Optimization: Write and optimize SQL queries and PL/SQL blocks to extract data, validate integration staging tables, and troubleshoot data discrepancies.
• Enhancements & Support: Monitor active integration pipelines, identify performance bottlenecks, and implement proactive enhancements to minimize integration failures.

Qualifications

• Experience: Minimum 7+ years of hands-on technical experience in Oracle Fusion SCM implementations and integration development.
• Core Modules: Strong functional and technical understanding of Oracle Fusion Inventory Management and Order Management modules and their respective data models.
• Integration Middleware: 7+ years of extensive experience building connections, orchestrations, and file-based data imports (FBDI) using Oracle Integration Cloud (OIC).
• Reporting: Proficient in developing BI Publisher reports, data models, and complex SQL queries.
• APIs & Protocols: Deep expertise in working with REST and SOAP APIs (payload structure, authentication, pagination, and error handling).
• Testing Tools: High proficiency with Postman and SoapUI for API discovery and testing.
• Database Skills: Strong foundational knowledge of SQL and PL/SQL for data analysis and verification.

Requirements

• Technical or functional familiarity with Oracle Warehouse Management Cloud (LGF) Application.
• Experience handling warehouse-related API contracts and messaging (e.g., inventory synchronization, receiving, and shipping confirmations).

Professional Attributes

• Self-Directed Researcher: Ability to navigate Oracle Documentation independently to figure out API capabilities, limitations, and standard patterns.
• Strong Communicator: Excellent verbal and written communication skills to articulate technical designs and collaborate effectively with functional consultants and business stakeholders.
• Problem Solver: Analytical mindset with the ability to debug complex data flow issues across multiple cloud systems.