The role requires solid hands-on experience in building end-to-end data integration processes, including source-file ingestion, data transformation, loading into Oracle databases, file generation, data reconciliation, and interface monitoring.

Key Responsibilities: Design, develop, and maintain ODI integration solutions using:  ODI Projects  Packages  Procedures  Scenarios  Load Plans  Mappings  Variables  Knowledge Modules o Develop data extraction, transformation, and loading processes between source systems, SFTP locations, Oracle databases, staging tables, OFSAA, and downstream applications.

Create and maintain source-to-target mappings based on functional and technical requirements. o Develop reusable ODI components and frameworks for file ingestion, data validation, transformation, and loading. o Configure and support ODI repositories, agents, topologies, contexts, models, data stores, and physical and logical schemas. o Generate, deploy, schedule, and monitor ODI scenarios and load plans across development, testing, and production environments. o Troubleshoot ODI job failures, session errors, data-quality issues, transformation errors, and performance problems. o Develop file-processing solutions for CSV, delimited, fixed-width, XML, or other supported file formats. o Integrate ODI with SFTP servers, shell scripts, Oracle databases, OFSAA, and enterprise scheduling platforms. o Support restart, recovery, rerun, and dependency management for failed or interrupted ODI processes.

End-to-End Integration Responsibilities o Design and support end-to-end data flows such as:



o Source system to SFTP o SFTP to ODI o ODI to staging or target tables o ODI to OIC o OIC to downstream applications o Define the processing boundary and handoff between ODI o Ensure data completeness, accuracy, consistency, and traceability across all integration layers. o Implement file-level and record-level validation, including: o File-name validation o File-format validation o Record-count validation o Control-total validation o Duplicate checking o Mandatory-field validation o Reconciliation checks o Coordinate with database administrators, infrastructure teams, application teams, security teams, and vendors for connectivity and environment-related requirements. o Support SFTP setup, network connectivity, firewall whitelisting, credentials, certificates, and access requirements. o Participate in requirements gathering, solution design, fit-gap analysis, and technical workshops. o Translate business and functional requirements into scalable technical integration designs. o Support unit testing, system integration testing, user acceptance testing, deployment, and post-production activities. o Provide production support and perform root-cause analysis for integration incidents. o Coordinate with Oracle Support for product-related defects, patches, or technical issues.



o Prepare and maintain the following technical documents: o Technical Design Document o Low-Level Design Document o Source-to-Target Mapping Document o Interface Specification Document o ODI Mapping and Package Design o Deployment and Configuration Guide o Unit Test and Integration Test Results o Data Reconciliation Report o Production Implementation Plan o Rollback Plan o Operational Runbook o Troubleshooting and Recovery Procedures o Oracle Configuration Workbook Required Skills &

Qualifications:  5 to 10 Years of Exp.  Strong experience with Oracle EPM Cloud applications (FCCS, TRCS, EPBCS, EDMCS).  Proven ability to write and debug Calc Scripts.

 Hands-on experience with Groovy scripting in Oracle EPM.  Experience providing BAU / production support for EPM systems.  Good understanding of financial processes such as planning, budgeting, consolidation, and reporting.  Strong problem-solving and troubleshooting skills.  Ability to work independently and manage multiple priorities.

Nice to Have

• Experience with EPM data integrations (Data Management, EPM Automate).

• Knowledge of Oracle Cloud Infrastructure (OCI).

• Exposure to financial close, tax, or planning implementations. We are seeking an experienced Oracle EPM Engineer to support, maintain, and enhance our Oracle Enterprise Performance Management (EPM) applications. The role focuses on BAU (Business-As-Usual) support, system enhancements, and technical development across multiple EPM modules, with strong hands-on expertise in calculation scripts and Groovy scripting.

📌 Urgent Job Opening ODI Profile (Delhi)
🏢 TechBliss Digital Solution
📍 Delhi