· Responsibilities-

The data engineer will essentially support the data modeler and handle all the ETL code. Below is a 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).

📌 Data Engineer (Bengaluru)
🏢 Elfonze Technologies
📍 Bengaluru