EPBCS Integration Specialist

Job Description:

Project : EPBCS to Data Lake Integration Role

Summary:

We are seeking an experienced EPBCS Integration Specialist to design, develop, and support the integration of Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) with enterprise Data Lake platforms. The ideal candidate will have strong expertise in Oracle EPM technologies, data integration, SQL, ETL development, and data quality management.

• 5+ years of experience with Oracle EPBCS / Planning Cloud
• 3+ years of experience in EPBCS data integration projects
• 2+ years of experience working with Data Warehouse platforms such as Snowflake, Google Big Query, or Azure Synapse

• Strong experience with Oracle EPBCS, including:
  Metadata Dimensions Actuals Budgets APIs
• Strong SQL development skills
• ETL tools experience such as:
  Informatica Talend Apache Airflow
• Experience with data quality validation and data reconciliation

• Design the EPBCS extraction and Data Lake integration strategy.
• Develop dimension, actuals, and budget data pipelines.
• Implement data validation and reconciliation processes.
• Optimize integration performance and troubleshoot production issues.
• Develop technical documentation and operational runbooks.

• Data Architecture
• Versioned dimensions
• Incremental actuals loads
• Budget versioning
• Maintain lineage and metadata
• Data Quality Pre-load and post-load validation
• Reconciliation checks
• Row count verification
• Data consistency validation
• Integration Patterns Full dimension extracts
• Incremental actuals extraction
• Budget version management
• Performance Batch exports Parallel extraction Bulk data loading Partitioning Data compression

• Integration architecture and data flow design
• Data mapping specifications
• Version-controlled ETL/ELT pipelines
• Data quality validation framework
• Reconciliation reports
• Operational runbooks