Senior Oracle ERP Developer
Role details
Job location
Tech stack
Job description
The Senior Oracle ERP Developer is responsible for the design, development, and support of technical solutions within the Oracle ecosystem. This role requires a "hybrid" expert who can support legacy Oracle EBS R12 environments while leading the technical transition to Oracle Fusion Cloud ERP. You will act as the primary developer for OIC integrations, OCI PaaS extensions, and complex data conversions from EBS to Cloud., EBS to Cloud Transition & Data Migration
- Legacy Support: Maintain and enhance existing Oracle EBS R12 technical components, including PL/SQL packages, Stored Procedures, Oracle Reports, and XML Publisher.
- Data Conversion: Lead the extraction of legacy data from EBS tables and transform it into FBDI (File-Based Data Import) templates for ingestion into Fusion Cloud Financials.
- Co-existence Design: Develop and support co-existence strategies where EBS and Cloud ERP systems exchange data during multi-year migration phases.
Cloud Integration & Development (OIC/OCI)
- Integration Development: Build and monitor end-to-end integrations in Oracle Integration Cloud (OIC) using the ERP Cloud, FTP, and REST adapters.
- OCI PaaS Extensions: Develop custom side-by-side extensions on Oracle Cloud Infrastructure (OCI) using SQL, Java, and OCI Object Storage to meet gaps in standard Cloud functionality.
- Web Services: Develop and consume SOAP and RESTful web services to facilitate real-time communication between Oracle Cloud and third-party Finance tools (e.g., BlackLine, Banking portals).
Financial Reporting & Technical Support
- Reporting: Create and maintain complex BI Publisher (BIP) reports, OTBI analysis, and Financial Reporting Studio (FRS) reports.
- SLA Customization: Provide technical support for Subledger Accounting (SLA) rule modifications to ensure proper accounting of custom transactions.
- Issue Resolution: Perform root-cause analysis for production issues in both EBS (Forms/Reports/Workflows) and Cloud (OIC/Scheduled Processes).
Requirements
Do you have experience in Technical architecture?, * Oracle EBS (R12/11i): Advanced PL/SQL, Oracle Forms, Oracle Reports, Workflow Builder, and Concurrent Programs.
- Oracle Fusion Cloud: Hands-on experience with OIC (Oracle Integration Cloud), FBDI, ADFdi, and BIP.
- OCI PaaS: Basic to intermediate knowledge of OCI Gen3 Architecture, VBCS, and Autonomous Database (ATP).
Experience
- Years of Experience: 5-8 years of experience as an Oracle Technical Consultant/Developer.
- Migration Portfolio: Proven track record of at least one full-cycle EBS to Oracle Cloud ERP migration.
- Domain Knowledge: Strong technical understanding of the P2P (Procure-to-Pay) and R2R (Record-to-Report) cycles.
- Bachelor's degree in Computer Science, Engineering, or a related technical field.
- Demonstrated proficiency in utilizing AI tools to enhance productivity and streamline workflows, or possess the agility and "growth mindset" to rapidly master new AI technologies as they are integrated into Sunrun's operations.
Professional Competencies
- Technical Agility: Ability to quickly pivot between writing legacy PL/SQL code and modern OIC orchestration logic.
- Documentation: Strong skills in creating Technical Design Documents (MD070/CV060) and mapping documents.
- Collaboration: Experience working closely with Functional Leads to validate technical designs against business requirements.
Preferred Certifications
- Oracle E-Business Suite R12 Project Portfolio Management Certified Implementation Specialist.
- Oracle Cloud Infrastructure (OCI) Foundations or Developer Associate.
Benefits & conditions
Please note that the compensation information is made in good faith for this position only. It assumes that the successful candidate will be located in markets within the United States that warrant the compensation. Please speak with your recruiter to learn more.
Starting salary/wage for this opportunity:
154,799.31 to 185,759.18
Compensation decisions will not be based on a candidate's salary history. You can learn more here.