Senior Integration Developer (Oracle Integration Cloud & Oracle EPM)
Exp : 7+ years
Shift : UK Shift ( 2:30-11:30 pm)

Location: Pune, Noida, Bangalore, Chennai, Hyderabad

The Opportunity:
We are seeking a highly skilled and experienced Senior Integration Developer with a strong background in Oracle Integration Cloud (OIC) and deep expertise in Oracle Enterprise Performance Management (EPM) modules. This critical role involves designing, developing, and implementing robust integration solutions that connect our Oracle EPM systems (e.g., Planning Budgeting Cloud Service (PBCS), Financial Consolidation and Close Cloud Service (FCCS), Account Reconciliation Cloud Service (ARCS), Enterprise Data Management Cloud Service (EDMCS)) with other enterprise applications. You will ensure the efficient and accurate flow of financial, operational, and master data, playing a pivotal role in transforming our integration landscape and supporting our EPM initiatives.

Key Responsibilities

• Own integration solution architecture and integration strategy for assigned programs/projects.
• Translate business/functional requirements into scalable integration designs: interface contracts, payload models, mappings, and non-functional requirements.
• Design and build OIC integrations (orchestrations, routing, transformations, enrichment, validations) using reusable components and standards.
• Implement secure connectivity and authentication: OAuth 2.0/2.1, Basic, certificates, keys, wallets; ensure compliance with enterprise security controls.
• Develop file-based integrations using SFTP/FTP, CSV/XML, and Oracle Fusion load patterns such as FBDI/BIP/UCM (as applicable).
• Define and implement robust operational patterns: error handling framework, exception routing, retries, replay/reprocessing, and idempotency.
• Drive testing strategy: unit tests, SIT coordination, test data strategy, defect triage and fixes, and UAT support.
• Own deployment and release management: versioning, packaging, environment promotion (DEV/SIT/UAT/PROD), and rollback readiness.
• Set up monitoring and operational readiness: integration tracking, alerts, dashboards, runbooks, and support handover/KT.
• Perform code reviews and enforce engineering standards for performance, resiliency, maintainability, and documentation.
• Mentor junior developers and lead technical discussions with stakeholders (business, functional, security, infra, and external vendors).

 Must-Have Technical Skills

• Oracle Integration Cloud (OIC): connections, integrations, schedules, lookups, libraries, packages, monitoring and troubleshooting.
• Strong API engineering: REST/SOAP, JSON/XML, WSDL/OpenAPI familiarity, pagination, throttling, error semantics.
• Data transformation skills: mapping best practices, XSLT where needed, canonical model approach, and schema validation.
• File-based integration: SFTP polling patterns, large file handling, chunking/batching, and Fusion load patterns (FBDI/BIP/UCM where applicable).
• Security fundamentals: OAuth, JWT concepts, client credentials, mutual TLS/certificates, secrets handling, and least-privilege access.
• Operational excellence: logging, correlation IDs, retry strategy, dead-letter/error queues (conceptually), support runbooks.
• Good working knowledge of SQL for data verification, reconciliation, and troubleshooting.

What You Will Do:

• Design & Development: Lead the design, development, and implementation of complex integration solutions using Oracle Integration Cloud (OIC) for various enterprise applications, with a primary focus on Oracle EPM modules (PBCS, FCCS, ARCS, EDMCS, etc.).
• Technical Expertise: Leverage your in-depth knowledge of OIC capabilities, including integrations, process automation (orchestrations), and visual builder to create efficient and scalable solutions.
• Oracle EPM Integration: Work closely with Finance, Accounting, and Planning teams, as well as functional consultants, to understand business requirements, identify integration points, and translate them into technical specifications for Oracle EPM module integrations. This includes managing data loads, metadata synchronization, and inter-system data transfers critical for financial planning, budgeting, forecasting, consolidation, and reporting cycles.
• API Development & Management: Develop, configure, and manage APIs within OIC for various integration patterns, interacting with Oracle EPM APIs and other source/target system APIs.
• Troubleshooting & Support: Provide expert-level support, troubleshoot complex integration issues related to EPM data flows, and optimize existing integrations for performance and reliability.
• Best Practices: Advocate for and implement integration best practices, coding standards, and security guidelines within the OIC platform, particularly concerning sensitive financial data.
• Documentation: Create comprehensive technical design documents, mapping specifications, and support documentation for all integration solutions.
• Collaboration: Collaborate with cross-functional teams, including architects, functional consultants, business users, and other developers, to deliver integrated solutions.
• Mentorship: Mentor junior developers and contribute to the continuous improvement of our integration development processes.
• Stay Current: Keep abreast of the latest OIC features, Oracle EPM Cloud updates, and industry integration trends in financial systems.

What You Bring:

• Experience: 7+ years of experience in enterprise application integration development, with at least 3-5 years specifically focused on Oracle Integration Cloud (OIC).
• Oracle EPM Domain Expertise: Proven experience integrating with and understanding the data models, business processes, and functionalities of multiple Oracle EPM Cloud modules (e.g., PBCS, FCCS, ARCS, EDMCS, Hyperion Planning, HFM).
• OIC Proficiency: Hands-on experience with OIC components such as Integrations (App Driven, Scheduled, File-based), Process Automation, Visual Builder, and Adapters (e.g., Oracle ERP Cloud Adapter, REST Adapter, SOAP Adapter, FTP Adapter, Database Adapter, EPM Cloud Adapter if available/used).
• Technical Skills:
• Strong proficiency in XML, XSLT, JSON, and REST/SOAP web services.
• Experience with SQL and PL/SQL for data manipulation and validation, especially with Oracle databases.
• Familiarity with security concepts in integrations (e.g., OAuth, Basic Authentication).
• Cloud Experience: Understanding of cloud-native concepts and experience working with cloud platforms (preferably Oracle Cloud Infrastructure).
• Problem-Solving: Excellent analytical and problem-solving skills with the ability to diagnose and resolve complex integration issues.
• Communication: Strong verbal and written communication skills to effectively interact with technical and non-technical stakeholders.
• Team Player: Ability to work independently and collaboratively in a fast-paced environment.
• Education: Bachelor's degree in Computer Science, Information Technology, Finance, or a related field.

Bonus Points (Nice-to-Have):

• Oracle Cloud Certification (e.g., Oracle Integration Cloud Specialist, EPM Specialist certifications).
• Experience with other Oracle SaaS applications (e.g., ERP Cloud, HCM Cloud, SCM Cloud).
• Knowledge of Data Management tools within EPM (e.g., Data Management/FDMEE) and integrating with them via OIC.
• Experience with continuous integration/continuous deployment (CI/CD) pipelines for OIC.