22 Nov
|
Scaleup Innovation Lab
|
Canada
22 Nov
Scaleup Innovation Lab
Canada
Oracle EBS Technical Developer
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:
- Robust 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.
Pay: $90,000.00-$150,000.00 per hour
Work Location: Remote
📌 Oracle EBS Technical Developer (Canada)
🏢 Scaleup Innovation Lab
📍 Canada