OCI Oracle ATP Database Architect
Vantage Point Consulting · Posted Nov 11, 2026
- Senior
Design and implement data lake architecture leveraging Oracle ATP, OCI services, and Oracle analytics tools.
Responsibilities
- Define standards and patterns for Landing (Raw), Unified (Consolidated) and Structured (Curated) data layers
- Establish data modeling approaches (normalized, dimensional, and hybrid models) aligned with analytics and reporting needs
- Build ingestion pipelines to load massive data from source systems (F&B POS)
- Support batch and near-real-time ingestion using tools such as OCI Data Integration, OIC, OCI Object Storage, REST APIs, and file-based loads
- Preserve source fidelity, metadata, and audit attributes (load dates, source system identifiers, record counts)
Requirements
- Nice to have: MS SQL Server Database
- Nice to have: My SQL