Data Engineer
Elfonze Technologies Pvt Ltd · Bengaluru, Karnataka, India
IT Services and IT Consulting · 201-500 employees
About the role
The data engineer will implement data lake architecture and build ingestion pipelines to load massive data from source systems. They are responsible for transforming raw data into analytics-ready structures while ensuring data quality and performance optimization.
What they look for
Requirements
The role requires experience with Oracle ATP, OCI services, and ETL processes to support data modeling and ingestion. Proficiency in SQL and experience with data validation, reconciliation, and schema development are essential.
Full description
· 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).
