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.
Experience Required:
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
Required Skills:
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
Key Responsibilities
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