Production Support Engineer

2 days ago

Montreal, QC, Canada Aarorn Technologies Inc Full-time
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

Chart of Accounts (COA) framework, segment values, and account hierarchies

Multi-ledger environments with primary and secondary le