Original job description
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.
