Production Support Engineer (Deposit Systems)

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 ledgers

Accounting methods and accounting conventions for different legal entities

Month-end and year-end close procedures, accruals, and reconciliation

Oracle EBS Financial Modules Integration (Mandatory)

Practical Experience With

Development skills required for BI Publisher.

GL posting workflows and subledger journal entry creation

Subledger reconciliation and GL account balancing

Integration between Oracle EBS modules and GL

Accounting Hub and Financials Accounting Hub configurations

Drill-down capabilities from GL to subledger transactions

Oracle EBS Technical Architecture (Mandatory)

Online Patching (EBR) Understanding of Edition-Based Redefinition and online patching procedures

Customization Standards Compliance with Release 12.2 development standards for PL/SQL, Forms, Reports, and Java

Database Objects Knowledge of EBS database object development standards and schema migration

Concurrent Programs Design, development, and troubleshooting of concurrent programs

Oracle Forms & Reports Experience with custom Forms and Reports development or modification

Web ADI (Web-based Application Desktop Integrator) Configuration and troubleshooting for GL and subledger data loads

SDLC & Process Tools (Mandatory)

Proven Familiarity With

Standard Software Development Life Cycle (SDLC) methodologies

Change control procedures and Oracle EBS change management

Oracle EBS patching, upgrades, and online patching enablement

Jira and version control systems (Git, SVN)

Testing protocols (unit, integration, UAT)

Documentation standards and best practices

Key Responsibilities

Application Support & Customization Management: Provide specialized support for Oracle Financials EBS R12. Maintain, update, and validate custom PL/SQL modules, Forms, Reports, and Concurrent Programs. Manage custom GL posting rules, subledger accounting definitions, and accounting logic.

Subledger Accounting & GL Operations: Configure and maintain subledger accounting rules, accounting methods, and journal entry definitions. Troubleshoot subledger to GL posting workflows, reconciliation issues, and non-balancing account entries. Ensure accurate GL posting and complete audit trails.

Financial Data Validation & Troubleshooting: Investigate, diagnose, and resolve technical issues related to inbound and outbound financial files containing accounting movements. Identify and isolate anomalies in GL balancing, subledger reconciliation, and account reconciliation. Validate data integrity across multi-ledger environments.

Pipeline Automation: Design, optimize, and maintain robust Linux shell scripts to manage background file processing, concurrent program scheduling, GL posting automation, subledger journal entry creation, and error handling within the EBS environment.

Database & Pro*C Maintenance: Optimize and debug backend processing components using Oracle PL/SQL. Manage database objects (tables, indexes, sequences, views). Maintain legacy batch code written in Pro*C. Perform query optimization and concurrent program tuning.

Analysis & Enhancements: Perform impact analysis for GL mapping updates, subledger accounting rule changes, module customizations, or platform migrations. Map transaction flows accurately to standard GL lines and COA guidelines. Provide clear effort estimates for development, unit testing, and UAT cycles.

Testing & Release Coordination: Execute unit and integration testing protocols for custom modules, subledger accounting rules, and interface configurations. Create, submit, and track change requests (CR) following corporate SDLC compliance guidelines and EBS change management procedures.

Performance Tuning & Optimization: Monitor and optimize Oracle EBS Financials performance, including GL posting performance, concurrent program tuning, subledger journal entry creation efficiency, and database maintenance activities.

Multi-Ledger & Multi-Organization Support: Manage multi-ledger configurations, MOAC setups, and inter-company accounting. Support consolidation processes and reporting across multiple legal entities and ledgers.

Process & Compliance: Maintain real-time task tracking in Jira. Provide daily progress updates to management. Adhere strictly to institutional client data policies, SOX compliance requirements, and security compliance standards. Maintain audit trails and documentation for all GL and subledger transactions.

Preferred Qualifications

5+ years of direct experience with Oracle EBS R12 (or R12.2.x versions)

Experience with Oracle EBS Financials implementations or major upgrades

Knowledge of Oracle Application Framework (OAF) or Oracle ADF

Familiarity with Oracle Workflow or business process automation

Understanding of financial reporting standards and consolidation processes

Experience with Oracle Web ADI and data integration tools

Knowledge of Oracle Approval Management Engine (AME)

Exposure to Oracle Cloud Infrastructure (OCI) or Oracle EBS on Cloud deployments

Technical Environment

Oracle EBS R12

Oracle Database 19c or 12c Release 1

Linux Operating System (64-bit)

Oracle Forms & Reports

Oracle Concurrent Programs

Jira and Version Control Systems

Disclaimer: AI tools may assist in the recruitment process; however, all hiring decisions are made by the recruitment team based on a comprehensive evaluation of candidates.