Production Support Engineer

Job Title: Production Support Engineer (Deposit Systems)
Location: Montreal, QC (4x onsite a week)
Employment Type: Contract
Pay Rate: CAD$60/HR INC
Interview Type: Face 2 Face (Onsite Interview Only)

Position Overview

We are seeking an experienced Senior Oracle Financials EBS R12 Support Engineer to maintain, optimize, and support our Oracle Financials EBS R12 environment. In this role, you will manage Oracle EBS Modules PO, AP, FA, GL and custom modules, subledger accounting rules, GL posting workflows, and production systems to ensure seamless financial operations, accurate accounting movements, and complete audit trails. The role is expected to have experience in I-expense, i-procurement, and workflow development, EOY and Month process.

The ideal candidate possesses strong expertise in Oracle Financials EBS R12, advanced Linux shell scripting, BI Publisher and Oracle PL/SQL. Because this platform serves as the central hub for institutional financial accounting and reporting, a solid foundational understanding of financial data flows, subledger accounting architecture, and accounting movements is essential, with specialized knowledge of core accounting structures like General Ledgers, Subledger Accounting (SLA), Charts of Accounts, and multi‑ledger environments being highly advantageous.

Technical Skills & Requirements

• Oracle Financials EBS R12 Expertise (Mandatory)

Core Module Knowledge

• General Ledger (GL) Advanced proficiency in GL posting, journal entry creation, account reconciliation, and GL inquiry tools
• Accounts Payable (AP) Strong understanding of invoice processing, payment workflows, and AP subledger accounting
• Fixed Assets (FA) Knowledge of asset acquisition, depreciation, and FA subledger accounting
• Subledger Accounting Expert-level understanding of subledger journal entry creation, accounting definitions, accounting methods, and posting engines

EBS Financials Architecture

• Multi‑ledger and multi‑organization architecture (MOAC) configuration and management
• Chart of Accounts (COA) design, flexfield structures, and account derivation rules
• Ledger setup, accounting calendars, and currency management
• Subledger to GL posting workflows and reconciliation processes
• Balance sheet and non‑balancing account entry handling
• Accounting Flexfield (CCID) derivation and validation

Advanced Customization & Development

• Custom GL posting rules and accounting logic implementation
• Subledger Accounting rule configuration using Accounting Methods Builder (AMB)
• Application Accounting Definitions (AAD) and journal line type customization
• Transaction object definitions and source value mapping
• Integration with Oracle Financials Accounting Hub

Scripting Capabilities (Mandatory)

• Expert-level Linux Shell Scripting For
• Automated data pipeline management and file handling
• Concurrent program scheduling and batch operations
• GL posting automation and subledger journal entry creation
• Error handling, logging, and monitoring frameworks
• Data validation and reconciliation scripts

Database Skills (Mandatory)

• Advanced Oracle PL/SQL Proficiency, Including
• Complex queries, packages, stored procedures, and triggers
• Subledger Accounting table structures (GL tables, AP/FA subledger tables)
• Journal entry creation and GL posting logic
• Debugging and performance optimization within the EBS environment
• Custom function and procedure development for GL and subledger operations
• Data migration and reconciliation scripts
• Pro*C Programming (Preferred/Nice-to-Have)
• Foundational to intermediate Pro*C skills for:
• Troubleshooting and updating embedded SQL C-programs
• Supporting legacy batch code and concurrent programs
• Custom utility development for GL and subledger processing

Domain Knowledge & Experience

• Financial Data Flows & Accounting Movements (Mandatory)
• Strong understanding of financial data files (flat files, XML, CSV, EDI) containing:
• High-volume accounting movements (debits and credits)
• Inter-company transactions and eliminations
• Multi-currency transactions and revaluation
• Subledger transaction flows to GL posting

Core Accounting Concepts (Preferred Plus)

• Solid functional understanding of:
• General Ledger (GL) systems, trial balances, and period close processes
• Subledger Accounting (SLA) architecture, accounting events, and journal entry generation
• Balance Sheet accounts, non-balancing account entries, and reconciliation