Torchora
Back to Home

Key Responsibilities and Required Skills for Oracle EBS Developer

💰 $ - $

ITERPOracleEBSDevelopment

🎯 Role Definition

An Oracle EBS Developer designs, develops, implements and supports Oracle E-Business Suite (EBS) solutions to meet business process requirements. The role focuses on customizations, integrations, data migrations, performance tuning, and full-lifecycle delivery for Oracle EBS (R12 / 12.2) modules such as Financials (GL/AP/AR), Supply Chain (INV/PO/OM), Projects (PA), and HRMS. The ideal candidate combines deep technical expertise in PL/SQL, Oracle Forms & Reports, OAF, and Web Services with strong business analysis, testing, and production support experience.

📈 Career Progression

Typical Career Path

Entry Point From:

  • Junior Oracle Developer / PL/SQL Developer
  • Oracle Applications Support Analyst
  • ERP Technical Analyst

Advancement To:

  • Senior Oracle EBS Developer / Technical Lead
  • Oracle EBS Architect / Solution Architect
  • ERP Integration Architect or Application Manager

Lateral Moves:

  • Oracle Cloud (Fusion) Integration Developer
  • Middleware / SOA Developer
  • Business Analyst (ERP Functional)

Core Responsibilities

Primary Functions

  • Lead end-to-end technical design and development of Oracle E-Business Suite (EBS) customizations, extensions, and integrations, including detailed design documents, data models, and technical specifications aligned to business requirements.
  • Develop, optimize and maintain complex PL/SQL packages, procedures, functions, packages, and materialized views to support transactional and reporting requirements across AP, AR, GL, PO, INV, OM and PA modules.
  • Build and maintain Oracle Forms and Reports customizations, convert legacy forms to R12 standards, and troubleshoot runtime issues to ensure a stable user experience for transactional users.
  • Design and implement integrations between Oracle EBS and third-party systems using REST/SOAP web services, Oracle SOA Suite, Oracle Integration Cloud (OIC/ICS), Oracle Database Gateway, FTP/flat-file interfaces and API calls.
  • Create and maintain concurrent programs, request sets, and custom concurrent managers, including parameter handling, scheduling considerations, and performance tuning for high-volume processing.
  • Implement and customize Oracle Application Framework (OAF), Java-based OAF pages, and personalizations to standard EBS pages for enhanced user workflows and responsive UI experiences.
  • Lead data conversion and migration efforts using SQL Loader, FBDI, WebADI, CSV/Excel imports, and custom ETL scripts; create verification checks and reconciliation reports to validate migrated data.
  • Develop and maintain BI Publisher (XML Publisher) templates, data models, and output formats for invoices, purchase orders, checks, and financial reports; ensure accurate PDF/RTF/Excel output.
  • Troubleshoot production incidents, perform root cause analysis, apply fixes or workarounds, and prepare post-incident reports; participate in on-call rotation and urgent production releases.
  • Participate in Oracle EBS patching, cloning, and upgrade activities (R12 → 12.2), including testing custom objects, resolving patch conflicts, and ensuring compatibility of customizations with baseline code.
  • Build, test, and deploy interfaces using standard Oracle EBS APIs, OPEN_INTERFACE tables, and direct SQL only when justified; follow coding standards and change management processes to ensure traceability.
  • Optimize SQL queries, indexes, and execution plans; work with DBAs to resolve locking/contention issues, implement bind variable usage, and improve long-running queries to enhance system performance.
  • Author and maintain comprehensive technical documentation: design specs, test cases, deployment runbooks, rollback plans, and knowledge transfer guides for operational teams and future developers.
  • Collaborate with functional analysts, business stakeholders, project managers and QA to translate business requirements into technical solutions, estimate effort, and negotiate scope or alternatives.
  • Design and implement Oracle EBS workflows and approval processes using Oracle Workflow builder; integrate workflow events with notifications, custom attributes, and human tasks.
  • Create unit, integration, and system test cases for customizations and interfaces; coordinate and support user acceptance testing (UAT) activities and remediate defects identified during testing.
  • Enforce secure coding practices and data protection standards when developing integrations and data conversions, including encryption-at-rest/in-transit considerations and role-based access checks.
  • Coach and mentor junior EBS developers, perform code reviews, and establish reusable libraries and templates to standardize development and accelerate delivery across projects.
  • Collaborate on performance capacity planning and sizing of application and database tiers; provide input for infrastructure upgrades, OCI migrations, and High Availability/Disaster Recovery planning.
  • Manage release cycles and deployments through change control, patching strategies, and automated build/deploy pipelines where applicable; coordinate with Release Management and QA.
  • Support continuous improvement initiatives by identifying technical debt, proposing refactors or modernization (e.g., replace legacy forms with OAF or move integrations to OIC), and tracking ROI for refactoring.
  • Ensure compliance with audit, SOX and internal control requirements by implementing logging, traceability, segregation of duties checks, and producing supporting evidence for audits.

Secondary Functions

  • Support ad-hoc data requests and exploratory data analysis.
  • Contribute to the organization's data strategy and roadmap.
  • Collaborate with business units to translate data needs into engineering requirements.
  • Participate in sprint planning and agile ceremonies within the data engineering team.
  • Provide production support SLAs, prepare incident reports, and track recurring issues for long-term resolution.
  • Deliver training sessions and knowledge transfer to functional teams and end-users on custom features and best practices.
  • Assist in pre-sales and estimation exercises by providing technical feasibility assessments and high-level solution proposals.
  • Maintain an up-to-date inventory of custom objects, patches, and technical dependencies for auditability and maintenance planning.

Required Skills & Competencies

Hard Skills (Technical)

  • Oracle E-Business Suite R12 / 12.2 application development and customization experience across multiple modules (Financials, SCM, Projects, HRMS).
  • Expert-level PL/SQL: packages, cursors, bulk processing, exceptions, collections, and performance tuning.
  • Oracle Forms and Reports development and troubleshooting; experience migrating forms/reports to modern frameworks.
  • Oracle Application Framework (OAF) / Java development for EBS personalization and page customizations.
  • Experience building and consuming REST/SOAP Web Services, integrating EBS with third-party systems using Oracle SOA Suite / ICS / OIC.
  • Hands-on experience with Oracle API usage, OPEN_INTERFACE tables, FND APIs, and concurrent program development.
  • BI Publisher (XML Publisher) template design and data model creation for transactional and batch reporting.
  • Strong SQL tuning skills, use of EXPLAIN PLAN, SQL Trace, TKPROF, and collaboration with DBAs for indexing and optimizer hints.
  • Experience with data migration tools and techniques: SQL*Loader, FBDI, WebADI, ETL utilities, and reconciliation scripts.
  • Familiarity with Oracle EBS workflows, Oracle Workflow Builder, and approval routing configuration.
  • Experience with patching, cloning, upgrades and applied patches (AD utilities, opatch, adpatch) in EBS environments.
  • Knowledge of Unix/Linux shell scripting, basic system administration tasks and automation for deployment/runbooks.
  • Version control and CI/CD familiarity (Git, Jenkins, or similar) in packaging and deploying EBS customizations.
  • Understanding of security concepts, role-based access, SSO integration (SSO/OAM), and segregation of duties (SOD) in EBS.
  • Strong understanding of financial and procurement business processes to align technical solutions with functional controls.

Soft Skills

  • Excellent stakeholder communication and presentation skills; ability to translate complex technical topics for functional and business audiences.
  • Strong analytical and problem-solving mindset with a pragmatic approach to trade-offs between technical purity and business value.
  • Ability to work in agile and hybrid delivery models, manage multiple priorities, and deliver under tight deadlines.
  • Proactive ownership mentality and a continuous improvement mindset; comfortable driving technical design decisions and trade-offs.
  • Mentoring skills to upskill junior staff and foster consistent code quality and standards across teams.
  • Detail-oriented documentation and test-case creation to support repeatable deployments and audits.
  • Collaboration and teamwork orientation; experience working in cross-functional global teams and with offshore/nearshore resources.
  • Customer-service focus with the ability to manage expectations and provide timely status updates during incident resolution.

Education & Experience

Educational Background

Minimum Education:

  • Bachelor’s degree in Computer Science, Information Technology, Software Engineering, or a related technical discipline.

Preferred Education:

  • Master’s degree in Computer Science, Information Systems, or MBA with strong technical background.
  • Oracle certifications (Oracle EBS, Oracle Database, OCP) and middleware/integration certifications are a plus.

Relevant Fields of Study:

  • Computer Science / Information Technology
  • Software Engineering
  • Management Information Systems
  • Accounting/Finance (beneficial for EBS Financial modules)

Experience Requirements

Typical Experience Range:

  • 4 to 10+ years of relevant Oracle EBS development and support experience (varies by seniority).

Preferred:

  • 6+ years with demonstrated experience on Oracle EBS R12 / 12.2 implementations, upgrades, integrations and production support.
  • Proven track record in at least two full lifecycle implementations (design → build → test → deploy → support) and participation in one or more upgrade/patch cycles.
Explore More Careers