Oracle EBS Software Developer

Posted 9hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Oracle EBS developer building PL/SQL financial systems for CGI Federal’s defense consulting programs. Supporting DLA and DAI cloud-hosted federal financial management, compliance, and analytics.

Responsibilities:

  • Develop and maintain PL/SQL packages, procedures, functions, views, and extraction scripts supporting financial posting logic, SLA/AutoAccounting/Account Generator rule analysis, and machine readable crosswalk generation.
  • Implement data transformation logic required to normalize, structure, and export Oracle EBS financial configuration and transaction metadata.
  • Create optimized SQL and PL/SQL queries to support compliance validation services, RCA workflows, and Oracle Analytics Server (OAS) data models.
  • Support database integrations with OCI Object Storage, including generating output artifacts in JSON/CSV/XML formats and enabling downstream consumption.
  • Collaborate with the DBA team to support indexing, performance tuning, environment synchronization, and efficient query execution across modules (AP, AR, GL, FA, PO, OM&S).
  • Work with DevSecOps engineers to integrate PL/SQL code into CI/CD pipelines, ensuring version control, automated testing, and governed deployments.
  • Assist functional SMEs and architects with posting logic investigations, derivation analysis, exception identification, and traceability.
  • Produce technical documentation, database design artifacts, and support evidence required for audit and compliance reviews.

Requirements:

  • 5+ years of Oracle PL/SQL development experience in enterprise or ERP environments.
  • Strong knowledge of Oracle SQL, PL/SQL development best practices, performance tuning, and complex data modeling.
  • Familiarity with creating structured data outputs (JSON/CSV/XML) and interacting with cloud storage services.
  • Ability to work with DBAs, cloud engineers, and analysts to troubleshoot queries, optimize performance, and improve reliability.
  • Ability to obtain/maintain IT II Non Critical Sensitive security clearance or Tier 3 (T3) investigation suitability.
  • Familiarity with additional BI reporting tools (i.e. Databricks, Spark experience, Qlik, ADW)
  • Experience with Oracle EBS (Financials preferred), especially SLA, AutoAccounting, and accounting event structures.
  • Experience with OCI based systems, Object Storage integration, or external table configurations (DBMS_CLOUD).
  • Understanding of federal financial structures (USSGL, SFIS/SLOA), or experience supporting audit focused financial applications.
  • Experience with DevSecOps practices including CI/CD and automated PL/SQL testing frameworks.
  • Strong analytical and problem solving abilities, especially in complex ERP/financial data environments.
  • Clear communication and collaboration skills across functional and technical teams.
  • Structured, detail oriented, and comfortable operating within compliance driven federal programs.

Benefits:

  • Competitive compensation including profit participation program
  • Comprehensive medical, dental, and vision benefits
  • Basic life and accidental death & dismemberment insurance
  • Matching contributions through 401(k) plan
  • CGI share purchase plan
  • Flexibility and paid accrued vacation leave, ranging from 10 to 20 days per year
  • 80 hours of floating holiday leave per year
  • At least 80 consecutive hours of paid sick/safe leave
  • Paid parental leave, ranging from 20 to 70 consecutive business days
  • Bereavement leave, ranging from 1 to 7 days per year
  • Paid jury duty leave, up to time summoned
  • Learning opportunities and tuition assistance
  • Wellness and Well being programs