Senior Oracle integration Cloud (OIC) Middleware & ETL Developer (EBS 12.2.12)

Ampcus Incorporated

Washington, DC
30+ days ago

$70–$80 Per Hour

Highlights

Develop and troubleshoot PL/SQL, EBS interfaces/APIs, concurrent programs, BI Publisher/XML artifacts as needed, and middleware/integration components; implement monitoring and audit-ready logging; support test cycles and cutovers; and resolve 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
Industry	Staffing/Employment Agencies
Salary	$70–$80 Per Hour
Company Size	500 to 999 employees
Website	http://www.ampcus.com

Description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Position Summary

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

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.
Develop and troubleshoot PL/SQL, EBS interfaces/APIs, concurrent programs, BI Publisher/XML artifacts as needed, and middleware/integration components; implement monitoring and audit-ready logging; support test cycles and cutovers; and resolve production defects while adhering to federal security and compliance expectations.

EBS R12 Integration Support

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.
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.
Experience with 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.
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.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.

About Company

Ampcus Inc is a global technology and business consulting firm specializing in Digital Transforrmation, Big Data, Analytics, Cyber Security, Testing, IV&V, Infrastructure Management and Enterprise Solutions. Ampcus Inc is an SBA 8(a) certified Women and Minority Owned global Provider of broad range of consulting Services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, their goals become our goals. We are an ISO 9000, ISO 20000, ISO 27000 and CMMi Level certified company.

Ampcus consultants have significant business, engineering and technology experience. Our consultants have over 20 years of business experience and an average of over 10 years of engineering and technology experience. This means that the project teams understand how systems work and how the technology impacts the business processes of organizations.

We believe that success of an engagement is determined by strong project management, clear communication and mutual commitment working collaboratively. Our methodology begins by listening to the customer needs, then working with their teams to gain a clear understanding of the requirements, while providing a knowledge transfer of best practices for the organization. As a recognized leader providing customized software services, management and engineering solutions to companies around the world, our ability to deliver is a "granted" that makes companies put their trust in us to answer their day-to-day business challenges and put them on a path for greater success. We are the choice for our clients because we look at our clients business from a growth perspective.

Industry: Information Technology and Services

Specialties: Digital Transformation, Big Data and Analytics, Infrastructure Management Services, Testing and IV&V, Cyber Security, Active Directory and E-mail Infrastructure, Project Management, Training, and ERP, CRM. EAI, BI