Oracle Integration Cloud (OIC) Middleware & ETL Developer (EBS 12.2.12)

22nd Century Technologies, Inc. (TSCTI)

Washington, DC
Today

$50–$75 Per Hour
Full-time

Highlights

Developing and troubleshooting PL/SQL, EBS interfaces/APIs, concurrent programs, BI Publisher/XML artifacts as needed, and middleware/integration components (e.g., Oracle integration Cloud (OIC)/Oracle Integration patterns, web services, file-based exchanges); implementing monitoring and audit-ready logging; supporting test cycles and cutovers; and resolving production defects while adhering to federal security and compliance expectations. Design, build, and maintain OIC integrations (orchestrations, scheduled jobs, file-based flows, event-driven integrations) that support ERP modernization and UNIFI operations, aligned with initiative discussions in Pre-IBM Review Meeting Re: Integrations and Data Transport Methods.

Numbers & Facts

Location	Washington, DC
Job Type	Full-time
Salary	$50–$75 Per Hour
Company Size	501 - 1000
Year Founded	1997
Headquarters	McLean, VA, US
Website	https://www.tscti.com/

Description

Job Title: Oracle Integration Cloud (OIC) Middleware & ETL Developer (EBS 12.2.12)

Location with zip code: Washington, DC, CA 20002(Hybrid Role-2-3 days onsite)

Duration: Full-time

Job Description:

The Senior Oracle integration Cloud (OIC) Middleware, ETL, EBS Integration Specialist is responsible for designing, building, and supporting ETL Jobs, Oracle Integration Cloud (OIC) integrations for an Oracle E-Business Suite R12 environment hosted in OCI.
This role ensures reliable, secure, and scalable data flows between EBS and external systems, aligning with enterprise integration standards and operational readiness activities.
This position requires deep expertise in OIC orchestration, REST/SOAP services, FBDI/HDL patterns, ERP adapters, ETL Process and hands-on understanding of EBS interface tables, APIs, and concurrent program frameworks. Key Responsibilities OIC Integration Design & Development

Responsibilities:

Design, build, and maintain OIC integrations (orchestrations, scheduled jobs, file-based flows, event-driven integrations) that support ERP modernization and UNIFI operations, aligned with initiative discussions in Pre-IBM Review Meeting Re:
Integrations and Data Transport Methods.
Implement REST/SOAP services, OIC Connectors, EBS adapters, FTP/SFTP, and OCI Object Storage patterns.
Build FBDI-based and API-based integrations for Financials, Procurement, AR/AP, and custom modules.
Develop transformation mappings (XSLT/JSON/XML) and apply error-handling, retry, and notification frameworks.
Developing and troubleshooting PL/SQL, EBS interfaces/APIs, concurrent programs, BI Publisher/XML artifacts as needed, and middleware/integration components (e.g., Oracle integration Cloud (OIC)/Oracle Integration patterns, web services, file-based exchanges); implementing monitoring and audit-ready logging; supporting test cycles and cutovers; and resolving production defects while adhering to federal security and compliance expectations. EBS R12 Integration Support Confidential - Not for Public Disclosure
Design and support interfaces and concurrent program frameworks using EBS staging tables, validations, and public APIs.
Collaborate with technical teams on data extraction requirements for outbound integrations.
Troubleshoot data, process, API, and workflow issues involving EBS subledger modules. Operational Readiness & Migration Support
Participate in integration design reviews and cross-team planning meetings (e.g., ERP Interim Operational Capacity (IOC) Design Review).
Support cutovers, migrations, and release deployments across OCI environments.
Coordinate with DBAs, EBS Admins, and Technical Developers to validate end-to-end integration readiness. Monitoring, Troubleshooting & Support
Monitor OIC dashboards, error logs, instance runs, and connectors.
Analyze and resolve integration failures, data inconsistencies, and performance bottlenecks.
Enhance logging, observability, and exception-handling capabilities to meet enterprise reliability standards. Documentation & Governance
Develop technical design documents, integration specifications, and support runbooks.
Maintain source-to-target mappings, API catalogs, and versioning standards in alignment with ongoing operational planning .
Support SOX/SOD, audit evidence, and compliance documentation as required.

Required Skills & Experience:

7–10+ years with Oracle EBS technical or integration development, including strong expertise in EBS R12.
3–5+ years hands-on with Oracle Integration Cloud (OIC), including orchestrations.
3–5+ years hands-on with Oracle SQL, PL/SQL ETL data-load patterns. Confidential - Not for Public Disclosure
REST/SOAP integrations, event-driven flows, file transfers, and scheduling.
Strong experience with EBS interface tables, open APIs, concurrent programs, and data-load patterns.
Expertise with FBDI/ADFdi, transformation mappings (XSLT/JSON/XML), and integration best practices.
Proficiency with OCI services relevant to integrations (Object Storage, Networking, Keys/Certs).
Strong PL/SQL, performance tuning skills, and ability to debug complex data flows.
Experience participating in cross-functional design reviews like Review ERP TDD for ERB or integration-focused reviews.
Excellent communication skills and experience supporting large integration programs.

Preferred Qualifications:

Background in EBS integrations with cloud systems, ERP modernization.
Experience in Data warehouse tools (e.g., OBIEE, Snowflake, etc..)
Experience in ETL tools (e.g., ODI, Informatica, etc..)
Experience in OCI DevOps pipelines, Git-based CI/CD for OIC, or API Gateway.

Job Responsibilities

Design, build, and maintain OIC integrations (orchestrations, scheduled jobs, file-based flows, event-driven integrations) that support ERP modernization and UNIFI operations, aligned with initiative discussions in Pre-IBM Review Meeting Re:
Integrations and Data Transport Methods.
Implement REST/SOAP services, OIC Connectors, EBS adapters, FTP/SFTP, and OCI Object Storage patterns.
Build FBDI-based and API-based integrations for Financials, Procurement, AR/AP, and custom modules.
Develop transformation mappings (XSLT/JSON/XML) and apply error-handling, retry, and notification frameworks.
Developing and troubleshooting PL/SQL, EBS interfaces/APIs, concurrent programs, BI Publisher/XML artifacts as needed, and middleware/integration components (e.g., Oracle integration Cloud (OIC)/Oracle Integration patterns, web services, file-based exchanges); implementing monitoring and audit-ready logging; supporting test cycles and cutovers; and resolving production defects while adhering to federal security and compliance expectations. EBS R12 Integration Support Confidential - Not for Public Disclosure
Design and support interfaces and concurrent program frameworks using EBS staging tables, validations, and public APIs.
Collaborate with technical teams on data extraction requirements for outbound integrations.
Troubleshoot data, process, API, and workflow issues involving EBS subledger modules. Operational Readiness & Migration Support
Participate in integration design reviews and cross-team planning meetings (e.g., ERP
Interim Operational Capacity (IOC) Design Review).
Support cutovers, migrations, and release deployments across OCI environments.
Coordinate with DBAs, EBS Admins, and Technical Developers to validate end-to-end integration readiness. Monitoring, Troubleshooting & Support
Monitor OIC dashboards, error logs, instance runs, and connectors.
Analyze and resolve integration failures, data inconsistencies, and performance bottlenecks.
Enhance logging, observability, and exception-handling capabilities to meet enterprise reliability standards. Documentation & Governance
Develop technical design documents, integration specifications, and support runbooks.
Maintain source-to-target mappings, API catalogs, and versioning standards in alignment with ongoing operational planning .
Support SOX/SOD, audit evidence, and compliance documentation as required.

Qualifications

7–10+ years with Oracle EBS technical or integration development, including strong expertise in EBS R12.
3–5+ years hands-on with Oracle Integration Cloud (OIC), including orchestrations.
3–5+ years hands-on with Oracle SQL, PL/SQL ETL data-load patterns. Confidential - Not for Public Disclosure
REST/SOAP integrations, event-driven flows, file transfers, and scheduling.
Strong experience with EBS interface tables, open APIs, concurrent programs, and data-load patterns.
Expertise with FBDI/ADFdi, transformation mappings (XSLT/JSON/XML), and integration best practices.
Proficiency with OCI services relevant to integrations (Object Storage, Networking, Keys/Certs).
Strong PL/SQL, performance tuning skills, and ability to debug complex data flows.
Experience participating in cross-functional design reviews like Review ERP TDD for ERB or integration-focused reviews.
Excellent communication skills and experience supporting large integration programs.

Preferred Qualifications:

Background in EBS integrations with cloud systems, ERP modernization.
Experience in Data warehouse tools (e.g., OBIEE, Snowflake, etc..).
Experience in ETL tools (e.g., ODI, Informatica, etc..).
Experience in OCI DevOps pipelines, Git-based CI/CD for OIC, or API Gateway.

About Company

22nd Century Technologies, Inc. (TSCTI) is one of the fastest-growing IT services integrators and workforce solutions providers in the United States. Founded in 1997, TSCTI is a Certified National Minority Business Enterprise (MBE) with a workforce of over 6,000 professionals, including more than 600 cybersecurity subject matter experts (SMEs), supporting clients across all 50 U.S. states, Canada, and Mexico.

Headquartered in Princeton, New Jersey, and McLean, Virginia, TSCTI operates through 14 offices nationwide. Our commitment to quality, security, and operational excellence is reflected in our adherence to industry-leading standards and certified mature processes, including CMMI Level 3 for Development and Services, ISO 20000, ISO 27001, and ISO 9001.

With a strong focus on the public sector, TSCTI currently supports 14 of the 15 Federal Executive Departments, 37 additional federal agencies, all 50 state governments, more than 115 local government agencies, and 37 school districts. Over the past three years, we have significantly expanded our commercial footprint and now serve more than 80 Fortune 500 and commercial clients.

Recognized by Forbes as one of the “Best Companies to Work For,” 22nd Century Technologies consistently exceeds client expectations through a customer-centric approach, delivering exceptional talent and innovative solutions while fostering a culture that motivates, values, and empowers its employees.

https://www.tscti.com/current-openings