Apolis logo

EPBCS Integration Specialist

Apolis
  • Jersey City, NJ
  • Remote
  • $60–$65 Per Hour
  • Quick Apply
9 days ago

Job Description

  • 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

Numbers & Facts

LocationJersey City, NJ (
Remote
)
IndustryComputer/IT Services
Salary$60–$65 Per Hour
Company Size500 to 999 employees
Websitehttps://www.apolisrises.com/
Want to know if you’re a fit?
Upload your resume and let our AI show you.

Skills

  • Actualsunmatched
  • Apacheunmatched
  • Application Programming Interface (API)unmatched
  • Budget Managementunmatched
  • Budgetingunmatched
  • Cloud Computingunmatched
  • Data Compressionunmatched
  • Data Lakeunmatched
  • Data Managementunmatched
  • Data Mappingunmatched
  • Data Qualityunmatched
  • Data Warehousingunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Identify Issuesunmatched
  • Informaticaunmatched
  • Metadataunmatched
  • Microsoft Windows Azureunmatched
  • Oracleunmatched
  • Oracle Enterprise Performance Management (EPM)unmatched
  • Performance Tuning/Optimizationunmatched
  • Quality Managementunmatched
  • Reconciliationunmatched
  • SQL (Structured Query Language)unmatched
  • Snowflake Schemaunmatched
  • Technical Writingunmatched

Benefits

Paid Sick Days, Employee Referral Program, Employee Events, Retirement / Pension Plans

About Company

Since 1996, RJT has provided successful SAP, Oracle, and IT consulting solutions and staffing services to clients around the world. The new Apolis brings you the same personalized service fortified with a greater array of IT solutions, global expertise, and cost-management strategies.

We are a global IT consultancy that seamlessly integrates experts and leading-edge solutions into your organization so you can focus on what really matters.

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder