Back to Jobs
Recently postedOther

OCI Oracle ATP Database Architect

Advantra Consulting GroupUnited States🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationUnited States
OracleSQLComplianceData PrivacyReconciliationRESTSQL Server

Job description

OCI Oracle ATP Database Architect -

Remote (USA)

Video Interview

Description:

  • Design and implement data lake architecture leveraging Oracle ATP, OCI services, and Oracle analytics tools.
  • 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).
  • Implement data quality validations, reconciliation controls, and error handling.
  • Transform raw data into cleansed, conformed, and analytics†ready structures.
  • Develop business†friendly schemas, dimensions, and fact tables to support reporting, dashboards, and advanced analytics.
  • Implement data enrichment, harmonization, and reference data management logic.
  • Optimize SQL, indexing, partitioning, external tables, and materialized views to ensure high performance and scalability within Oracle ATP.
  • Collaborate with governance and security teams to ensure compliance with data privacy, retention, and access control policies
  • Experience getting data from MS SQL Server Database and My SQL (Optional)

Similar jobs