EPBCS Integration Specialist

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 BigQuery, 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.

Best Practices

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

Deliverables

Integration architecture and data flow design

Data mapping specifications

Version-controlled ETL/ELT pipelines

Data quality validation framework

Reconciliation reports

Operational runbooks