ETL Developer

Apexon; Washington (District of Columbia); On-site; USD 80,000 - 115,000; Full time

Job summary

A technology solutions company in Washington, DC, seeks an Oracle E-Business Suite Federal G-Invoicing Technical Developer to design and support integrations with the U.S. Treasury's G-Invoicing platform. The role involves translating requirements into technical designs, troubleshooting PL/SQL and EBS interfaces, and ensuring compliance with federal security standards. Ideal candidates have a strong understanding of Oracle EBS and are skilled in ETL, SQL, and PL/SQL.

Qualifications

• Strong knowledge of Oracle EBS data model and integrations.
• Disciplined approach to data quality and exception management.
• Ability to collaborate with functional finance stakeholders.

Responsibilities

• Design, build, and support technical integrations for G-Invoicing.
• Develop and troubleshoot PL/SQL, EBS interfaces/APIs, and concurrent programs.
• Implement monitoring and audit-ready logging for compliance.

Skills

ETL

Oracle EBS

SQL

PL/SQL

Job description

LOCATION: 20201, Washington, District of Columbia, United States

An Oracle E-Business Suite (EBS) Federal G-Invoicing Technical Developer is responsible for designing, building, and supporting the technical integrations and EBS extensions required to connect an agency’s Oracle EBS environment to the U.S. Treasury Bureau of the Fiscal Service G-Invoicing platform for intragovernmental transactions (IGT).

The role translates Treasury and agency requirements into technical designs and delivers outbound/inbound interface processing across the full G-Invoicing lifecycle—General Terms & Conditions (GT&C), Orders, Performance/Receiving, and Invoices—including message generation, transformations, data mapping, validations, acknowledgements, error handling, and reconciliation back to EBS financials (e.g., Accounts Receivable/Accounts Payable, Subledger Accounting, and General Ledger impacts as applicable). Typical responsibilities include developing and troubleshooting PL/SQL, EBS interfaces/APIs, concurrent programs, BI Publisher/XML artifacts as needed, and middleware/integration components (e.g., Oracle SOA Suite/Oracle Integration patterns, web services, file-based exchanges) to meet G-Invoicing interface specifications; implementing monitoring and audit-ready logging; supporting test cycles and cutovers; and resolving production defects while adhering to federal security and compliance expectations (e.g., controls, traceability, and ATO/FISMA-aligned practices). Success in this role requires strong knowledge of Oracle EBS data model and integrations, a disciplined approach to data quality and exception management, and the ability to collaborate with functional finance stakeholders, integration teams, and external partners to ensure timely, compliant IGT processing through G-Invoicing Required Skills: ETL, Oracle EBS, SQl, PL/SQL