Job Role: Data Engineer – Oracle Data Lake & ETL

Job Type: Contract

Job Location: Remote

Experience: 7+ Years

:

- Support the Data Modeler and develop/manage ETL pipelines.

- Design and implement Data Lake solutions using Oracle ATP, OCI services, and Oracle Analytics tools.

- Build data ingestion pipelines to load large volumes of data from source systems, including F&B; POS systems.

- Develop batch and near-real-time data integration using:

OCI Data Integration, Oracle Integration Cloud (OIC), OCI Object Storage, REST APIs, File-based data loads

- Maintain source data accuracy, metadata, audit details, load dates, source identifiers, and record counts.

- Perform data quality checks, data reconciliation, error handling, and validation.

- Transform raw data into clean, standardized, and analytics-ready datasets.

- Develop business-friendly fact tables, dimension tables, and reporting schemas.

- Implement data enrichment, data harmonization,



and reference data management.

- Optimize Oracle ATP SQL queries, indexing, partitioning, external tables, and materialized views.

- Work with governance and security teams to follow data privacy, retention, and access-control policies.

- Experience with Oracle ERP data and understanding how data flows through Oracle ERP is preferred.

- Experience extracting data from Microsoft SQL Server and MySQL is an added advantage.

- Strong communication, collaboration, and teamwork skills.

- Good understanding of business objectives and organizational structure.

- Solid attention to detail, accuracy, confidentiality, and data integrity.

- Ability to manage multiple priorities and meet tight project deadlines.

- Must demonstrate strong work ethics, trustworthiness, and commitment to quality.

📌 Data Engineer – Oracle Data Lake & ETL (India)
🏢 Ignisov Consulting Services
📍 India