Oracle Fusion Technical Consultant - ERP

Overview

We are looking for an experienced Oracle ERP Technical Consultant with experience in ERP implementations, integrations, technical development, reporting, data conversion, and production support. The consultant will be responsible for translating business requirements into scalable technical solutions and will work closely with functional consultants, business users, integration teams, and technical architects throughout the ERP implementation and support lifecycle.

Key Responsibilities

1. ERP Technical Development • Analyze business and functional requirements and translate them into technical solutions. • Design and develop technical components for ERP implementations and enhancements. • Develop and maintain technical solutions using ERP-provided tools, frameworks, APIs, and databases. • Perform technical impact analysis for new requirements, enhancements, and system changes. • Follow development standards, naming conventions, security guidelines, and performance best practices. 2. ERP Integrations • Design, develop, and support integrations between ERP and external applications. • Work with REST/SOAP APIs, web services, file-based integrations, SFTP, and middleware/integration platforms. • Develop integrations for inbound and outbound data flows. • Handle authentication, encryption, error handling, retries, logging, and monitoring. • Troubleshoot integration failures and perform root-cause analysis. • Collaborate with third-party application and banking/vendor teams for integration requirements. 3. Reporting & Data Extraction • Design and develop operational and management reports. • Work with reporting technologies such as BI Publisher, OTBI, FRS, SQL, and data models. • Develop complex SQL queries and optimize them for performance. • Analyze reporting requirements and determine the appropriate reporting approach. • Support report scheduling, bursting, security, and output distribution. 4. Data Conversion & Migration • Participate in ERP data conversion and migration activities. • Develop data extraction, transformation, validation, and loading processes. • Work with ERP data models, staging tables, conversion templates, and import processes. • Develop SQL queries and scripts for data validation and reconciliation. • Support mock conversions, SIT/UAT conversions, cutover, and production migration activities. • Investigate and resolve data conversion errors and discrepancies. 5. Technical Analysis & Troubleshooting • Analyze application, integration, database, and interface errors. • Perform root-cause analysis and provide permanent technical solutions. • Review logs, payloads, SQL queries, and system responses to troubleshoot issues. • Support SIT, UAT, cutover, hypercare, and production support. • Work with product/vendor support teams when required. 6. Technical Documentation • Prepare technical design documents, interface specifications, mapping documents, and technical runbooks.