A
EPBCS Integration Specialist
Apolis
🇺🇸 United States
Remote
Mid level
2 months ago
$60 – $65 / hour
- Oracle
- SQL
- ETL
- Snowflake
- Azure Synapse
- Informatica
- Talend
- Apache Airflow
- Data Architecture
- ELT
2 months ago
- We are currently working on this requirement on a priority basis. This role is for Utility domain Client, need remote candidates but on Sincera's Payroll. Please submit W2 candidates only for this role, referral will be received after confirmation. Need your support ASAP.
Job Title: EPBCS Integration Specialist
Location: Remote USA (Jersey City, NJ)
Role: Contract
Rate: DOE
(W2 with Sincera/Virtusa)
Referral will be provided this role, candidate will be on our payroll.
Client Domain: Utility Domain
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
EPBCS Integration Specialist · Apolis