OCI Oracle ATP Database Architect

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)