Abdelhamid Adel — Data Engineer
Open to Data Engineering & Analytics roles

Specialized in Data Engineering, ETL Pipelines, Lakehouse Architecture, and Cloud Analytics.

I AM ABDELHAMID ADEL

DATA ENGINEER
☁ AWS & Microsoft Certified Data Engineer
0+
Years Experience
0
Daily Pipeline
0%
Perf Improvement
0+
Queries Refined
LinkedIn Medium Email
About

Forging data systems
that endure.

From Cairo — a Data Engineer who designs and operates enterprise platforms across the full pipeline lifecycle. I move operational chaos into governed, analytics-ready datasets that organizations trust.

My craft spans complex ETL migrations, performance optimization, and modern lakehouse design: 78 MongoDB collections migrated into an Oracle DWH with zero integrity violations; a 1.7 PB/day pipeline stabilized from days to hours; ERP analytics decoupled to restore production health.

Depth from PySpark transformations to architecture decisions — always scalability, reliability, and measurable impact.

Experience
JAN 2022 — PRESENT
Data Engineer
IT-RANKS Technology · Cairo
  • Engineered Spark ETL pipelines migrating 78 MongoDB collections → Oracle DWH, zero integrity violations
  • Stabilized 1.7 PB/day ODI pipeline — ETL from 1–3 days to hours, 57% performance gain
  • Deployed Oracle GoldenGate to decouple ERP analytics, restoring production health
  • Optimized 130+ warehouse queries, cutting report retrieval by 60%
  • Built HR, Finance, SCM analytics via Oracle Analytics & Power BI
  • Incremental load architecture + Great Expectations data quality monitoring
Technical Skills

Skills across the data stack.

From ingestion streams to governed analytics — every layer of the modern data stack.

Programming & Scripting

Dynamic pipelines, query optimization, reusable ETL components.

Python SQL PySpark Bash

ETL & Orchestration

Apache Spark Apache Airflow Talend Oracle ODI Apache NiFi dbt Informatica PowerCenter

Databases

Oracle PostgreSQL MySQL MongoDB Redis Cassandra ClickHouse Neo4j

Warehousing & Modeling

Dimensional Modeling Star / Snowflake Schema Data Partitioning Performance Tuning

Big Data & Lakehouse

Apache Kafka Apache Iceberg HDFS Debezium GoldenGate Apache Nessie Trino Dremio MinIO

Cloud & Storage

AWS Glue AWS Redshift S3 · Athena · Lambda EC2 · QuickSight DataBrew · RDS DynamoDB GCP BigQuery GCP Dataflow

Quality & Governance

Great Expectations OpenMetadata

DevOps & Automation

Docker Git GitHub

Visualization & Analytics

Power BI Tableau Oracle Analytics Looker Metabase Apache Superset

Artificial Intelligence

scikit-learn & TensorFlow for predictive analytics; NLP & computer vision.

scikit-learn TensorFlow NLP Computer Vision
Case Studies

Selected engineering work with measurable outcomes.

Real architectures. Production systems built for scale, reliability, and impact.

CASE STUDY 01

MongoDB → Oracle Data Warehouse Migration

NoSQL to RDBMS · Dimensional Modeling · Zero Integrity Loss

78
COLLECTIONS
148
TABLES
0
VIOLATIONS
PySparkAirflowOracle DWHMongoDB
Architecture Flow
MongoDB
78 Collections
⟫
PySpark
Flatten · Transform
⟫
Key Mapping
ID Translation
⟫
Airflow DAG
Orchestrated DAG
⟫
Oracle DWH
148 Tables

Business Challenge

Operational data trapped in MongoDB — poor analytics performance, no referential integrity, schema chaos. The organization required a governed relational warehouse for BI and scale.

Architecture

  • Dimensional model: Lookups → Dimensions → Facts
  • Airflow orchestration respecting dependency order
  • PySpark explode() for nested document decomposition
  • Key mapping tables for MongoDB hash → Oracle sequences
78
COLLECTIONS
148
TABLES DELIVERED
0
INTEGRITY LOSS
✓
BI-READY
CASE STUDY 02

1.7 PB Daily Pipeline — Performance Optimization

Incremental Architecture · ODI · Oracle Analytics

57%
GAIN
1.7PB
DAILY
3d→h
RUNTIME
▼
Oracle ODIIncremental LoadCDCUpsert

Root Cause

Full refresh daily — truncate, reload 1.7PB including all history. Massive I/O, timeouts, dashboard blackouts lasting days.

Solution

  • Incremental loading — new & modified records only
  • Optimized merge/upsert strategies
  • Day-1 adjustment job for backdated transactions
  • Quarterly reconciliation without full reloads
57%
PERF GAIN
3d→h
ETL TIME
0
EO RUN FAILURES
50+
JOBS STABLE
CASE STUDY 03

ERP → Enterprise Data Platform

GoldenGate CDC · Single Source of Truth · Power BI

60%
FASTER
130+
QUERIES
3
DOMAINS
▼
GoldenGatePower BIData MartsSQL Optimization
Three-Layer Architecture
ERP (EBS)
HR · Finance · SCM
⟫
OGG CDC
Near Real-Time
⟫
Central DWH
Single Truth
⟫
Power BI
Never hits ERP

Challenge

Analytics hammered ERP tables — locking, degraded transactions, unreliable dashboards across scattered logic.

Impact

  • 130+ queries reworked with indexing strategy
  • Dashboard refresh: 5–30 min → near real-time
  • HCM governed mart
60%
QUERY REDUCTION
130+
OPTIMIZED
~0
REFRESH DELAY
1
DOMAINS
Certifications

Certifications & credentials

Industry-validated skills across cloud data engineering, orchestration, and analytics.

Associate

AWS Certified Data Engineer

Designing and implementing scalable, efficient, cost-effective data analytics solutions on AWS — S3, Glue, Redshift, Athena, Lambda, and cloud-native pipelines at enterprise scale.

Issued 2026 Amazon Web Services
2026

Microsoft Certified: Fabric Data Engineer

Microsoft

2025

Building Modern Data Analytics Solutions on AWS

Amazon Web Services

2025

Apache Airflow DAG Authoring

Astronomer

2025

Apache Airflow 2 Fundamentals

Astronomer

2024

Incorta for the Dashboard Consumer

Incorta

2024

Incorta 6 Essentials

Incorta

2023

OCI Management Foundations

Oracle Cloud

2023

OCI Foundation Associate

Oracle Cloud

Contact

Let's build data systems that scale.

Senior data engineering roles, consulting, and platform work — based in Cairo, open to remote and relocation.

Send a message

I'll respond within 1–2 business days.