EPBCS to Data Lake Integration - Resource Requirements Summary

Role

EPBCS Integration Specialist 

Core Requirements

Experience

• 5+ years Oracle EPBCS/Planning Cloud
• 3+ years EPBCS data integration projects
• 2+ years cloud data warehouse (Snowflake, BigQuery, Synapse)

Key Skills

• EPBCS architecture, dimensions, actuals, budgets, APIs
• SQL, Python, ETL tools (Informatica, Talend, Airflow)
• Data quality and reconciliation

Key Responsibilities

• Design EPBCS extraction and data lake integration strategy
• Develop dimension, actuals, and budget data pipelines
• Implement data validation and reconciliation
• Optimize performance and troubleshoot issues
• Develop technical documentation 

Best Practices (4 Pillars)

Pillar	Key Actions
Data Architecture	Version dimensions, incremental actuals loads, budget versioning, maintain lineage
Data Quality	Pre/during/post-load validation, reconciliation checks, row count verification
Integration Patterns	Full dimension extracts, incremental actuals, budget versioning
Performance	Batch exports, parallel extraction, bulk loading, partitioning, compression

Remote role

Deliverables

• Integration architecture & data flows
• Data mapping specifications
• ETL/ELT pipelines (version controlled)
• Data quality validation framework
• Reconciliation dashboards
• Operational runbooks

 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws.This position's pay range is $7.25/hr - $80.00/hr.