Design and implement data lake architecture leveraging Oracle ATP, OCI services, GoldenGate 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 (retail/hospitality POS)
Support batch and near-real-time ingestion using tools such as OCI Data Integration, OIC, OCI Object Storage, REST APIs, GoldenGate 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 and MySQL (Optional)
Pay: $75.00 - $80.00 per hour
Work Location: Remote
