Production Support Engineer (Deposit Systems) (Montreal)

Production Support Engineer (Deposit Systems) (Montreal)

19 Nov
|
Aarorn Technologies
|
Montreal

19 Nov

Aarorn Technologies

Montreal

Job Title: Production Support Engineer (Deposit Systems)Location: Montreal, QC (4x onsite a week)Employment Type: ContractPay Rate: CAD$60/HR INCInterview Type: Face 2 Face (Onsite Interview Only)Position OverviewWe 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 & RequirementsOracle Financials EBS R12 Expertise (Mandatory)Core Module KnowledgeGeneral Ledger (GL) Advanced proficiency in GL posting, journal entry creation, account reconciliation, and GL inquiry toolsAccounts Payable (AP) Strong understanding of invoice processing, payment workflows, and AP subledger accountingFixed Assets (FA) Knowledge of asset acquisition, depreciation, and FA subledger accountingSubledger Accounting Expert-level understanding of subledger journal entry creation, accounting definitions, accounting methods, and posting enginesEBS Financials ArchitectureMulti‐ledger and multi‐organization architecture (MOAC) configuration and managementChart of Accounts (COA) design, flexfield structures, and account derivation rulesLedger setup, accounting calendars, and currency managementSubledger to GL posting workflows and reconciliation processesBalance sheet and non‐balancing account entry handlingAccounting Flexfield (CCID) derivation and validationAdvanced Customization & DevelopmentCustom GL posting rules and accounting logic implementationSubledger Accounting rule configuration using Accounting Methods Builder (AMB)Application Accounting Definitions (AAD) and journal line type customizationTransaction object definitions and source value mappingIntegration with Oracle Financials Accounting HubScripting Capabilities (Mandatory)Expert-level Linux Shell Scripting ForAutomated data pipeline management and file handlingConcurrent program scheduling and batch operationsGL posting automation and subledger journal entry creationError handling, logging, and monitoring frameworksData validation and reconciliation scriptsDatabase Skills (Mandatory)Advanced Oracle PL/SQL Proficiency, IncludingComplex queries, packages, stored procedures, and triggersSubledger Accounting table structures (GL tables,



AP/FA subledger tables)Journal entry creation and GL posting logicDebugging and performance optimization within the EBS environmentCustom function and procedure development for GL and subledger operationsData migration and reconciliation scriptsPro*C Programming (Preferred/Nice-to-Have)Foundational to intermediate Pro*C skills for:Troubleshooting and updating embedded SQL C-programsSupporting legacy batch code and concurrent programsCustom utility development for GL and subledger processingDomain Knowledge & ExperienceFinancial 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 eliminationsMulti-currency transactions and revaluationSubledger transaction flows to GL postingCore Accounting Concepts (Preferred Plus)Solid functional understanding of:General Ledger (GL) systems, trial balances, and period close processesSubledger Accounting (SLA) architecture, accounting events, and journal entry generationBalance Sheet accounts, non-balancing account entries, and reconciliationChart of Accounts (COA) framework, segment values, and account hierarchiesMulti-ledger environments with primary and secondary ledgersAccounting methods and accounting conventions for different legal entitiesMonth-end and year-end close procedures, accruals, and reconciliationOracle EBS Financial Modules Integration (Mandatory)Development skills required for BI Publisher.GL posting workflows and subledger journal entry creationSubledger reconciliation and GL account balancingIntegration between Oracle EBS modules and GLAccounting Hub and Financials Accounting Hub configurationsDrill-down capabilities from GL to subledger transactionsOracle EBS Technical Architecture (Mandatory)Online Patching (EBR) Understanding of Edition-Based Redefinition and online patching proceduresCustomization Standards Compliance with Release 12.2 development standards for PL/SQL, Forms, Reports, and JavaDatabase Objects Knowledge of EBS database object development standards and schema migrationConcurrent Programs Design, development, and troubleshooting of concurrent programsOracle Forms & Reports Experience with custom Forms and Reports development or modificationWeb ADI (Web-based Application Desktop Integrator) Configuration and troubleshooting for GL and subledger data loadsSDLC & Process Tools (Mandatory)Proven Familiarity WithStandard Software Development Life Cycle (SDLC) methodologiesChange control procedures and Oracle EBS change managementOracle EBS patching, upgrades, and online patching enablementJira and version control systems (Git, SVN)Testing protocols (unit, integration, UAT)Documentation standards and best practicesKey ResponsibilitiesApplication 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 transparent 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 Qualifications5+ years of direct experience with Oracle EBS R12 (or R12.2.X versions)Experience with Oracle EBS Financials implementations or major upgradesKnowledge of Oracle Application Framework (OAF) or Oracle ADFFamiliarity with Oracle Workflow or business process automationUnderstanding of financial reporting standards and consolidation processesExperience with Oracle Web ADI and data integration toolsKnowledge of Oracle Approval Management Engine (AME)Exposure to Oracle Cloud Infrastructure (OCI) or Oracle EBS on Cloud deploymentsTechnical EnvironmentOracle EBS R12Oracle Database 19c or 12c Release 1Linux Operating System (64-bit)Oracle Forms & ReportsOracle Concurrent ProgramsJira and Version Control SystemsDisclaimer: 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.

📌 Production Support Engineer (Deposit Systems) (Montreal)
🏢 Aarorn Technologies
📍 Montreal

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: production support engineer (deposit systems) (montreal) / montreal

Subscribe to this job alert:

Get the latest job offers by email for: production support engineer (deposit systems) (montreal) / montreal