Data Engineer

· Responsibilities- The data engineer will essentially support the data modeler and handle all the ETL code. Below is a job description to assist you with sourcing. · Implement data lake architecture leveraging Oracle ATP, OCI services, and Oracle analytics tools. · 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).