Oracle EBS Software Developer
Posted 9hrs ago
Employment Information
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
















