Production Support Engineer (Deposit Systems)

Aarorn Technologies Inc; Montreal; On-site; CAD 68,000 - 97,000; Full time

Job summary

Aarorn Technologies Inc seeks a Production Support Engineer (Deposit Systems) in Montreal, QC. The role focuses on senior Oracle Financials EBS R12 support, including GL/AP/FA, SLA, and COA design, with emphasis on scripting, data integrity, and audit trails. Onsite, 4 days per week, contract position.

The candidate should demonstrate strong PL/SQL, BI Publisher, and Unix/Linux scripting skills, and experience with MOAC, multi-ledger environments, and complex financial workflows.

Qualifications

• Oracle EBS R12 expertise mandatory.
• GL posting, journal entry creation, account reconciliation.
• AP invoicing workflows and AP subledger accounting.
• FA asset management and depreciation workflows.
• Subledger Accounting rules, AMB, and GL integration.

Responsibilities

• Provide specialized support for Oracle Financials EBS R12 and maintain custom PL/SQL modules.
• Configure subledger accounting rules and journal entry definitions; troubleshoot GL-to-subledger posting.
• Validate financial data flows and reconcile multi-ledger environments.
• Design and maintain Linux shell scripts for batch processing and automation.
• Coordinate testing, releases, and change management per SDLC guidelines.
• Assist in data validation, performance tuning, and debugging of EBS processes.

Skills

Oracle EBS R12

Linux scripting

PL/SQL

BI Publisher

GL posting

AP processing

FA depreciation

Subledger Accounting

Automation scripting

Tools

Jira

Git

SVN

Pro*C

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)

• 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.