Oracle Fusion Consultant – ERP Technical Consultant
Dautom · New Cairo, Cairo, Egypt
Apply & track with Apply EdgeMandated to hire for a Saudi Based Telecom Organization in EgyptRole - Full Time Employment Work Location: Mivida Compound , New Cairo, EgyptWork Model: Hybrid ( 8 WFH Days per month )Enterprise Resource Planning (ERP)– Oracle Fusion Technical ConsultantPosition Overview We are looking for an experienced Oracle Fusion Technical Consultant to support the development, integration, reporting, data migration and technical support activities for Oracle Fusion Cloud applications.The candidate will work closely with functional consultants, technical leads, integration teams and business users to deliver reliable and scalable Oracle Fusion solutions.Core Responsibilities1. Oracle Fusion Technical DevelopmentDevelop and maintain technical solutions for Oracle Fusion Cloud.Analyze functional requirements and prepare technical solutions.Develop and maintain:BI Publisher (BIP) ReportsOTBI Reports and DashboardsSQL queries and data modelsFBDI templatesHDL/HSDL programsREST and SOAP integrationsScheduled processesPerform technical unit testing and defect fixing.Follow Oracle development and coding standards.2. Oracle Integration Cloud – OICDevelop and support integrations using Oracle Integration Cloud (OIC).Build integrations between Oracle Fusion and third-party applications.Work with REST, SOAP, FTP/SFTP and database adapters.Implement integration mappings, lookups, fault handling and notifications.Monitor integrations and troubleshoot failures.Analyze integration logs and perform root-cause analysis.Support OIC deployment across development, test and production environments.3. REST & SOAP APIsDevelop and consume Oracle Fusion REST APIs.Work with Oracle Fusion SOAP Web Services.Understand API request/response structures.Perform API testing using Postman or similar tools.Troubleshoot API errors and integration failures.Support API-based automation and data extraction.4. BI Publisher & OTBIDevelop BI Publisher reports based on business requirements.Create SQL queries and data models.Develop report templates using RTF/Excel formats.Configure scheduled and bursting reports.Develop and modify OTBI analyses and dashboards.Troubleshoot report data and performance issues.Validate reports with functional teams.5. Data MigrationSupport Oracle Fusion data migration activities using:FBDIHDL/HSDLREST APIsADFdiSpreadsheet LoadersPrepare and validate migration data.Execute data loads and troubleshoot errors.Perform data reconciliation after migration.Support mock conversions and production cutover activities.6. Technical DocumentationPrepare and maintain:Technical Design DocumentsIntegration Design DocumentsReport Design DocumentsAPI specificationsData migration documentsTest scriptsDeployment documentsTechnical support/runbook documents7. Production SupportProvide technical support for Oracle Fusion applications.Analyze and resolve integration, reporting and data issues.Monitor scheduled processes and integrations.Perform root-cause analysis for recurring issues.Coordinate with Oracle Support when required.Support production deployments and emergency fixes.Participate in incident and problem management.8. Functional CollaborationWork closely with Finance, SCM, HCM and other functional consultants.Understand business requirements and translate them into technical solutions.Participate in requirement and solution discussions.Provide technical feasibility and effort estimates.Support SIT, UAT and production validation.Assist functional teams in troubleshooting technical issues.Required Technical SkillsMandatoryOracle Fusion CloudOracle Integration Cloud (OIC)REST APIsSOAP Web ServicesBI PublisherOTBISQLPL/SQLFBDIHDL/HSDLOracle Fusion technical architectureData migrationProduction supportGood to HaveOracle APEXVisual Builder / VBCSOracle AnalyticsOCIGitJenkins / CI-CDPostmanGroovy scriptingJavaAI/GenAI exposureFunctional KnowledgeWorking knowledge of at least one Oracle Fusion module is required.ERPGeneral LedgerAccounts PayableAccounts ReceivableFixed AssetsProcurementCash ManagementSCMInventoryOrder ManagementPurchasingCostingSupply Chain PlanningHCMCore HRPayrollAbsence ManagementTalent ManagementCompensationExperience across multiple modules will be an advantage.Project ResponsibilitiesParticipate in requirement and technical design discussions.Estimate development and integration effort.Develop technical components.Perform unit testing and defect resolution.Support SIT and UAT.Coordinate with functional and integration teams.Prepare deployment packages.Support production migration and go-live.Provide post-production support.Maintain technical documentation.Experience Requirements5+ years of overall IT experience.3+ years of Oracle Fusion Cloud technical experience.Experience in at least one end-to-end Oracle Fusion implementation.Strong hands-on experience in OIC, BIP, OTBI, REST/SOAP and FBDI/HDL.Experience working with offshore/onsite teams.Good understanding of Oracle Fusion business processes.Strong troubleshooting and analytical skills.Preferred CertificationsOracle Fusion Cloud certificationOracle Integration Cloud certificationOracle Cloud Infrastructure certificationOracle APEX certificationKey CompetenciesStrong technical and analytical skillsProblem-solving abilityGood communication skillsAbility to work independentlyTeam collaborationCustomer orientationOwnership and accountabilityGood documentation skillsAbility to work under tight project timelinesKey Performance IndicatorsTimely completion of development tasksQuality of technical deliverablesIntegration stability and performanceReport accuracySuccessful SIT/UAT completionReduction in production defectsTimely resolution of technical issuesQuality of technical documentationAdherence to development and deployment standardsIdeal CandidateThe ideal candidate should be a hands-on Oracle Fusion Technical Consultant with strong expertise in OIC, REST/SOAP APIs, BI Publisher, OTBI, SQL/PLSQL and FBDI/HDL.The candidate should be capable of independently developing technical solutions, troubleshooting production issues and working effectively with functional and technical teams across the complete Oracle Fusion project lifecycle.