Description

• Own and manage backlog items related to Oracle EBS-driven systems and integrations
• Conduct independent, deep-dive troubleshooting by:
  • Writing and executing complex SQL queries against Oracle EBS (including extensive custom table structures)
  • Tracing transaction lifecycles across multiple modules and integrations
• Perform root cause analysis directly from EBS data, logic, and execution paths, without reliance on engineering teams for initial diagnosis
• Read and interpret:
  • PL/SQL stored procedures, packages, triggers, and Oracle functions
  • Oracle EBS application logic and customization layers
  • JSON requests and responses for integrations and business events
• Translate findings into:
  • Well-defined user stories, defect tickets, and enhancement requests
  • Clear acceptance criteria based on actual system behavior
• Engage in QA testing by:
  • Developing clearly documented test cases
  • Generating test data
  • Executing test cases
  • Documenting findings
  • Troubleshooting defects
  • Providing feedback to engineers and/or integration partners
• Partner with engineering teams to validate solutions and ensure alignment with system constraints
• Reconcile differences between business expectations and actual EBS system behavior
• Trace and validate end-to-end transaction flows across EBS and integrated systems
• Support testing and validation by confirming that fixes resolve underlying data and logic issues

Technical Responsibilities

• Use SQL as a primary tool to:
  • Diagnose production issues
  • Validate data integrity
  • Reconcile discrepancies across systems
• Analyze and interpret:
  • PL/SQL code, Oracle functions, and EBS backend processing logic
• Demonstrate deep familiarity with:
  • Oracle EBS base tables, relationships, and transaction models
  • Custom extensions and client-specific configurations
• Understand how Oracle functions and application logic are customized within EBS environments
• Play a lead role in functional feature, enhancement, integration, and bugfix QA, including working with warehouse operators to validate functionality post-deployment.
• Navigate multiple EBS environments (Model, Pre-Prod, Prod) to identify inconsistencies and root causes
• Use database-level and application-level analysis as the primary mechanisms for understanding system behavior

Functional / Domain Responsibilities

• Possess strong working knowledge of Oracle EBS functionality “under the hood”, including:
  • Order management
  • Inventory and fulfillment processing
  • Transaction lifecycle and state transitions
• Understand how:
  • Transactions are created, updated, and persisted within EBS
  • Upstream and downstream systems interact with EBS processing logic
• Identify:
  • Data anomalies
  • Configuration gaps
  • Breakdown points in system workflows

Required Qualifications

• 5–8 years of experience in one or more of the following:
  • Oracle EBS Technical Analyst
  • Business Systems Analyst (EBS-focused)
  • Technical Product Owner supporting Oracle EBS
• Strong, hands-on SQL expertise in Oracle
  • Must be comfortable writing complex queries for troubleshooting production issues
• Proven experience reading and interpreting:
  • PL/SQL stored procedures, packages, triggers, and Oracle functions
• Demonstrated experience working with:
  • Core Oracle EBS data structures, transaction flows, and backend processing logic
• Practical experience with:
  • Customization of Oracle functions and EBS application behavior
• Proven ability to:
  • Perform independent root cause analysis using data and system logic
  • Translate technical findings into actionable product requirements

Preferred Qualifications

• Experience working in heavily customized Oracle EBS environments
• Familiarity with:
  • Oracle APEX or mobile vs. desktop form behavior within EBS ecosystems
  • Differences in how users interact with EBS across UI frameworks
• Experience in:
  • Supply chain, order management, inventory, or fulfillment modules
• Familiarity with:

Integration patterns between EBS and external systems (APIs, event-driven platforms)

Key Skills

Education

Bachelor's degree