Job Description & Details
The demand for integrated ERP solutions is soaring as companies look to streamline supply chain operations. Mastering Oracle APEX, EBS, Fusion, and OIC puts you at the forefront of this transformation, especially in the chemical processing sector. This senior developer role in Columbus offers a chance to lead complex SCM projects while working in a hybrid environment.
Job Summary
We are seeking a Senior Oracle APEX/EBS/Fusion/OIC developer to design, build, and maintain custom applications and integrations that support procurement, inventory, and order management within a chemical processing environment. The role requires hands‑on development, API creation, and data migration expertise, with a focus on delivering scalable, high‑performance SCM solutions.
Top 3 Critical Skills Table
| Skill | Why it's critical | Mastery Level |
|---|---|---|
| Oracle APEX | Enables rapid web‑app development on top of Oracle DB, essential for custom SCM interfaces | Senior |
| Oracle EBS / Fusion | Core ERP platforms handling procurement, inventory, order management; deep knowledge ensures stable integration | Senior |
| Oracle Integration Cloud (OIC) | Connects disparate systems and APIs, vital for seamless data flow across SCM modules | Senior |
Interview Preparation
- How do you design a scalable APEX application for high‑volume procurement data?
What the interviewer is looking for: Understanding of page performance, RESTful services, and database indexing. - Explain the steps to integrate Oracle EBS with Oracle Fusion using OIC.
What the interviewer is looking for: Knowledge of adapters, orchestration, and error handling. - What strategies do you use for data migration between legacy SCM systems and Oracle Fusion?
What the interviewer is looking for: Experience with ETL tools, data validation, and rollback plans. - Describe a complex API you built to synchronize inventory levels across multiple sites.
What the interviewer is looking for: Ability to design idempotent APIs, security (OAuth), and logging. - How would you troubleshoot a performance bottleneck in an Oracle APEX dashboard that aggregates real‑time inventory data?
What the interviewer is looking for: Skills in SQL tuning, APEX session management, and use of materialized views.
Resume Optimization
- Oracle APEX
- Oracle EBS
- Oracle Fusion
- Oracle Integration Cloud (OIC)
- SCM modules (Procurement, Inventory, Order Management)
- API development
- Data migration
- Hybrid work model
- Chemical processing industry
- 9+ years of ERP development
Application Strategy
When reaching out to the recruiter, send a concise email that starts with a friendly greeting, attaches your updated resume, and clearly highlights your top skills. Make sure to mention related skills you possess, such as Oracle APEX, Oracle Fusion, and OIC integrations, and reference any relevant projects where you delivered SCM solutions. Emphasize your ability to work onsite three days a week and your immediate availability.
Career Roadmap
| Current Role | Typical Experience | Core Focus | Next Position |
|---|---|---|---|
| Senior Oracle SCM Developer | 9+ years in APEX/EBS/Fusion/OIC | End‑to‑end SCM solutions, integrations | Lead Oracle Developer |
| Lead Oracle Developer | 12+ years, team leadership | Architecture, governance, large‑scale projects | ERP Solutions Architect |
| ERP Solutions Architect | 15+ years, cross‑functional design | Enterprise‑wide integration strategy | Director of ERP Solutions |