Oracle ERP Cloud Technical Consultant (GL + PL/SQL)

As an experienced Oracle ERP Cloud Technical Consultant specializing in Oracle Financials General Ledger (GL) and advanced PL/SQL development, your role will involve designing, developing, and supporting integrations, reports, custom extensions, and data conversions within Oracle ERP Cloud Financials. Your expertise will ensure financial data accuracy and support critical accounting processes. You will need to combine technical knowledge with an understanding of financial systems to excel in this role. Key Responsibilities: - Configure and support Oracle ERP Cloud Financials General Ledger - Manage Chart of Accounts (COA), Ledgers, Journal Entries, Allocations - Support Period Close and Financial Reporting - Troubleshoot GL-related issues and provide production support - Collaborate with finance teams to translate business requirements into technical solutions Technical Development (PL/SQL & Integrations): - Develop and maintain PL/SQL packages, procedures, functions, and triggers - Design and implement Inbound / Outbound Integrations, REST APIs, SOAP Web Services, FBDI, HDL - Develop reporting and integrations using BI Publisher, OTBI Custom Reports, Data conversion scripts, and Oracle Integration Cloud (OIC) - Perform performance tuning and query optimization Data & Reporting: - Develop financial reports using BI Publisher, OTBI, and Smart View - Support financial reconciliations, audit queries, month-end, and year-end close reporting Collaboration & Documentation: - Work with functional consultants and finance stakeholders - Prepare Technical Design Documents (TDD) and participate in solution architecture discussions - Support UAT and deployment while ensuring compliance with financial and audit standards Required Skills: - Oracle ERP Cloud Financials - General Ledger (GL) - PL/SQL Development - BI Publisher - OTBI Reporting - REST / SOAP APIs - FBDI / HDL - Oracle Integration Cloud (OIC) - Financial data integrations - Performance tuning As an experienced Oracle ERP Cloud Technical Consultant specializing in Oracle Financials General Ledger (GL) and advanced PL/SQL development, your role will involve designing, developing, and supporting integrations, reports, custom extensions, and data conversions within Oracle ERP Cloud Financials. Your expertise will ensure financial data accuracy and support critical accounting processes. You will need to combine technical knowledge with an understanding of financial systems to excel in this role. Key Responsibilities: - Configure and support Oracle ERP Cloud Financials General Ledger - Manage Chart of Accounts (COA), Ledgers, Journal Entries, Allocations - Support Period Close and Financial Reporting - Troubleshoot GL-related issues and provide production support - Collaborate with finance teams to translate business requirements into technical solutions Technical Development (PL/SQL & Integrations): - Develop and maintain PL/SQL packages, procedures, functions, and triggers - Design and implement Inbound / Outbound Integrations, REST APIs, SOAP Web Services, FBDI, HDL - Develop reporting and integrations using BI Publisher, OTBI Custom Reports, Data conversion scripts, and Oracle Integration Cloud (OIC) - Perform performance tuning and query optimization Data & Reporting: - Develop financial reports using BI Publisher, OTBI, and Smart View - Support financial reconciliations, audit queries, month-end, and year-end close reporting Collaboration & Documentation: - Work with functional consultants and finance stakeholders - Prepare Technical Design Documents (TDD) and participate in solution architecture discussions - Support UAT and deployment while ensuring compliance with financial and audit standards Required Skills: - Oracle ERP Cloud Financials - General Ledger (GL) - PL/SQL Development - BI Publisher - OTBI Reporting - REST / SOAP APIs - FBDI / HDL - Oracle Integration Cloud (OIC) - Financial data integrations - Performance tuning