Oracle EBS Technical Developer

Oracle EBS Technical Developer

Location: Canada 

Travel: 7 days in month – to USA [candidate should have required Travel visa]

Job Type: Contract [6+ Months] – Corp 2 Corp

Role Overview

We are seeking a highly skilled Oracle EBS Technical Developer to design, develop, implement, and support Oracle EBusiness Suite (EBS) solutions.  The ideal candidate will combine deep technical expertise in PL/SQL, Oracle Forms, Reports, OA Framework (OAF), and XML Publisher with strong experience in RICEW development, integrations, and performance tuning. You will collaborate with functional and technical teams to deliver robust, scalable, and maintainable enterprise solutions within Finance, and SCM

Key Responsibilities

• Lead end-to end technical design and development of Oracle EBS customizations, extensions, and integrations.
• Develop, optimize, and maintain PL/SQL packages, procedures, functions, and materialized views for transactional and reporting requirements across F&A, SCM, Projects, and HRMS modules.
• Build and maintain Oracle Forms and Reports customizations; migrate legacy forms to modern R12 standards.
• Design and implement integrations between Oracle EBS and third-party systems using REST/SOAP Web Services, Oracle SOA Suite, ICS/OIC, FTP/flat-file interfaces, and APIs.
• Develop concurrent programs, request sets, and custom managers with performance optimization for high-volume processing.
• Implement and customize OAF pages and personalizations to enhance user workflows and UI experience.
• Lead data migration and conversion using SQL*Loader, FBDI, WebADI, CSV/Excel imports, and custom ETL scripts.
• Design and maintain BI/XML Publisher templates, data models, and output formats for financial and operational reporting.
• Troubleshoot production incidents, perform root cause analysis, and support patching, cloning, and upgrade activities.
• Collaborate with offshore/nearshore support teams and contribute to knowledge transfer and training for functional users.

Required Skills

Technical Skills:

• Strong expertise in Oracle EBS R12 / 12.2 development across multiple modules (Finance, SCM).
• Advanced PL/SQL programming: packages, cursors, bulk operations, exception handling, collections, and performance tuning.
• Oracle Forms and Reports development and troubleshooting.
• Experience in OAF/ADF page customization and Java development.
• Expertise in building and consuming Web Services for system integrations (Integrated SOA Gateway).
• Hands-on experience with Oracle APIs, OPEN_INTERFACE tables, FND APIs, and concurrent programs.
• BI/XML Publisher template design for transactional and batch reporting.
• SQL tuning and performance optimization, use of EXPLAIN PLAN, SQL Trace, and TKPROF.

• Experience with Oracle APEX development is considered an asset.

Soft Skills:

• Strong analytical, problem-solving, and technical design skills.
• Excellent stakeholder communication and collaboration with cross-functional teams.
• Ability to manage multiple priorities in agile/hybrid delivery models.
• Mentorship and leadership experience to guide junior developers and ensure code quality.
• Detail-oriented documentation and testing practices.

Education & Certifications

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or related fields (Master’s preferred).
• Oracle EBS certifications are a plus.

Experience

• 5–10+ years of demonstrated experience in Oracle EBS development and technical production support.
• Proven track record of working on at least one full lifecycle EBS implementation and upgrade projects.
• Experience with data migration, performance tuning, and RICEW object development.