Oracle EPM Consultant

Consultant OTM

Team Overview

As a part of Managed services Emerging solutions, we provide Application & Platform Support services to various member firms around the world to support the business transformation journeys of clients across a wide range of industries.

At MS clients are central to everything we do. With a single-minded focus on driving the best business results for clients, we forge strong partnerships with our member firms to build innovative solutions that address our clients’ biggest challenges. It is this client-centric approach which has allowed us to become one of the fastest growing business units in KGS in the last few years.

With unique technology-led solutions, strong leadership and an ever-growing group of highly skilled people, we are always striving to scale new heights of success.

 

Roles & responsibilities

• OTM Configuration & Technical Development : Configure and enhance OTM components such as agents, automation workflows, business rules, power data, and shipment execution processes. Support transportation planning, freight rating, carrier management, and operational workflows as per business requirements.
• Integration Development & Support : Design, develop, and support integrations between OTM and Oracle EBS (ERP/WMS) using OTM Integration Manager, Web Services, XML/XSD, and XSLT. Handle interface mappings, message validations, error handling, and monitoring of inbound and outbound integrations.
• Database & Backend Development : Develop and maintain SQL and PL/SQL objects including procedures, functions, packages, and optimized queries. Support data extraction, transformation, and performance tuning to ensure system stability and scalability.
• Reporting & Customization : Design, develop, and maintain BI Publisher reports, data templates, and layouts. Support custom screens, configuration-based enhancements, and technical documentation in line with Oracle standards and audit requirements.
• Production Support (L2/L3): Provide L2/L3 application support for OTM and related integrations, including incident management, root cause analysis, defect fixing, and performance optimization. Work closely with functional teams, business users, and global stakeholders to resolve critical production issues within SLAs.
• Testing, Deployment & Data Migration : Perform unit testing, system integration testing (SIT), and support UAT activities. Assist in deployment activities, release management, and data migration across development, test, and production environments.

  

Technical Skill Sets

• TM Configuration & Administration: Expertise in configuring OTM modules, including Order Management, Shipment Management, Rate Management, and Fleet Optimization.

• Business Process Automation: In-depth knowledge of designing and maintaining Automation Agents, Monitors, and Workflow Agents.

• Data Model & Database Knowledge: Strong proficiency in SQL and Oracle database structures for querying and data validation.

• Integration & Data Migration: Experience with XML/XSLT, SOAP/REST web services, and EDI for integration with ERP systems (like Oracle EBS) and external systems (Fourkites/P44).

• Reporting & Analytics: Development of operational and analytical reports using Oracle BI Publisher and OAC/OBIEE.

• Functional Tools: Ability to create and customize User Screen Sets, Manager Layouts, and Menus..

 

Core Functional Domain Knowledge

• Logistics & Transportation: Understanding of transportation lifecycles, including procurement, planning, and execution.

• Platforms: Hands-on experience with OTM Cloud and On-Premise versions (e.g., 6.3.x to 6.4.x).

Roles and Responsibilities 

Designation: Consultant 

Reporting to Manager 

Employment type: Full Time

 

Experience Level

Senior Level