Oracle Fusion ERP Technical Consultant

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. • Maintain integration, report, conversion, and configuration documentation. • Document technical assumptions, dependencies, error-handling mechanisms, and support procedures. 7. Collaboration & Delivery • Work closely with functional consultants to understand business processes and technical requirements. • Participate in requirement workshops, design discussions, code reviews, and technical walkthroughs. • Coordinate with offshore/onshore development and support teams. • Estimate technical effort and communicate risks, dependencies, and delivery timelines. • Mentor junior technical consultants and review their technical deliverables. Required Technical Skills •  Experience in ERP technical development and implementation. •  Strong experience with Oracle ERP / Oracle Fusion Cloud ERP or a comparable enterprise ERP platform. •  Strong SQL and database development skills. •  Experience with REST APIs, SOAP web services, JSON, XML, and HTTP-based integrations. •  Experience with BI Publisher and/or OTBI. •  Experience with ERP data conversion and migration processes. •  Experience with middleware/integration platforms such as Oracle Integration Cloud (OIC), Oracle Integration, MuleSoft, Boomi, or equivalent. •  Experience with SFTP/file-based integrations and various file formats such as CSV, XML, JSON, and fixed-width files. •  Good understanding of authentication mechanisms such as Basic Authentication, OAuth 2.0, and certificates. •  Experience with integration monitoring, error handling, logging, and reconciliation. •  Good understanding of ERP security and role-based access concepts. •  Experience working with enterprise implementation methodologies and SDLC processes. Preferred Oracle Fusion Skills Experience in one or more of the following Oracle Fusion modules is preferred: •  General Ledger •  Accounts Payable •  Accounts Receivable •  Cash Management •  Procurement •  Expenses •  Fixed Assets •  Projects •  Supply Chain Management Experience with Oracle Fusion technical objects and capabilities such as FBDI, REST APIs, SOAP services, BIP, OTBI, scheduled processes, ESS jobs, value sets, flexfields and ERP integrations will be an advantage. Key Competencies •  Strong analytical and problem-solving skills. •  Ability to understand complex business requirements and convert them into technical solutions. •  Strong communication and stakeholder-management skills. •  Ability to work independently as well as within a cross-functional team. •  Good troubleshooting and root-cause analysis skills. •  Ability to manage multiple technical deliverables and priorities. •  Strong documentation and presentation skills. •  Good understanding of software development and implementation lifecycle. •  Ability to mentor junior team members and provide technical guidance.