Job 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 Technical Developer designs, develops, and supports custom components in Oracle E-Business Suite R12, including RICEW objects, OIC integrations, custom PL/SQL packages, Workflows, OAF/Forms customizations, and EBS concurrent programs. The developer collaborates with functional analysts, architects, and business owners to deliver reliable, scalable, and audit-compliant technical solutions across Oracle Financials and Procurement environments. Key Responsibilities Technical Design & Development • Develop and maintain RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows) consistent with internal technical design standards. • Build and optimize PL/SQL programs, including custom packages, procedures, views, and database objects. • Implement and support concurrent programs, validations, and staging-table frameworks for inbound/outbound integrations. • Support OIC integrations, file-based data pipelines, schedulers, REST/SOAP integrations, and error-handling frameworks consistent with OIC patterns. • Create OTBI/BIP reports and EBS XML Publisher components. Technical Architecture & Standards • Ensure compliance with EBS 12.2 online patching (ADOP) requirements and coding standards. • Conduct performance tuning of SQL, PL/SQL, workflows, and interface programs. • Maintain custom objects in line with technical governance processes and RICEW development life cycle. • Adhere to internal environment, migration, and deployment standards. Testing & Release Support • Build unit test plans, conditions, and test data based on technical specification patterns. • Perform debugging and root-cause analysis across interfaces, APIs, custom objects, and workflows. • Support integrated testing, regression cycles, and release validation for quarterly patches and ERP upgrades. Production Support • Investigate and resolve technical issues involving custom code, integrations, concurrent programs, and database performance. • Analyze staging-table errors, interface failures, and OIC orchestration logs following the enterprise error-handling framework. • Provide on-call support for batch failures, data corrections, and system performance issues. Collaboration & Documentation • Work with functional teams to validate requirements and translate them into detailed technical designs and MD70 documents. • Provide impact analysis for patches, customizations, SLA changes, table updates, and integrations. • Maintain code documentation, configuration files, and migration trackers consistent with internal TDD expectations. 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.

Requirements

Must-haves

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.
Technical Design & Development
Develop and maintain RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows) consistent with internal technical design standards.
Build and optimize PL/SQL programs, including custom packages, procedures, views, and database objects.
Implement and support concurrent programs, validations, and staging-table frameworks for inbound/outbound integrations.
Support OIC integrations, file-based data pipelines, schedulers, REST/SOAP integrations, and error-handling frameworks consistent with OIC patterns.
Create OTBI/BIP reports and EBS XML Publisher components.
Technical Architecture & Standards
Ensure compliance with EBS 12.2 online patching (ADOP) requirements and coding standards.
Conduct performance tuning of SQL, PL/SQL, workflows, and interface programs.
Maintain custom objects in line with technical governance processes and RICEW development life cycle.
Adhere to internal environment, migration, and deployment standards.
Testing & Release Support
Build unit test plans, conditions, and test data based on technical specification patterns.
Perform debugging and root-cause analysis across interfaces, APIs, custom objects, and workflows.
Support integrated testing, regression cycles, and release validation for quarterly patches and ERP upgrades.
Production Support
Investigate and resolve technical issues involving custom code, integrations, concurrent programs, and database performance.
Analyze staging-table errors, interface failures, and OIC orchestration logs following the enterprise error-handling framework.
Provide on-call support for batch failures, data corrections, and system performance issues.
Collaboration & Documentation
Work with functional teams to validate requirements and translate them into detailed technical designs and MD70 documents.
Provide impact analysis for patches, customizations, SLA changes, table updates, and integrations.
Maintain code documentation, configuration files, and migration trackers consistent with internal TDD expectations.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlrest

Platform: jobdiva
Effort: medium