Looking for a job

Ahmed Gomaa

@ahmedgomaa6

Data Engineer at DataGear building ETL pipelines for AML, FATCA, KYC, and goAML reporting, with a 30% improvement in connection efficiency.

Egypt

Message

At DataGear, I build Python and SQL ETL pipelines that load Oracle data for AML, FATCA, KYC, and goAML reporting. I also migrated the ETL codebase from cx_Oracle to python-oracledb, improving performance and connection efficiency by 30%.

At Smartera 3S Solutions and Systems, I developed Talend pipelines for the CBR Regulatory Reporting System, processing daily data from 40+ source tables. On the Al Baraka Bank Egypt outsourced engagement, I evolved SSIS pipelines and reduced execution time from 12 hours to 15 minutes.

In my projects and open-source contributions, I’ve worked with Databricks, Apache Spark, dbt, and Airflow. I extended dbt-utils macros and built data pipelines with automated quality checks, including a serverless Azure lakehouse.

Experience

Work history, roles, and key accomplishments

Current

Data Engineer

Current

DataGear

Apr 2026 - Present (6 months)

Built Python and SQL ETL pipelines loading multiple Oracle sources into staging and applying MCP procedures to deliver AML, FATCA, KYC, and goAML compliance reporting. Resolved database connection leaks and migrated the ETL codebase from cx_Oracle to python-oracledb, improving performance and connection efficiency by 30%.

Python SQL Oracle ETL AML FATCA KYC GoAML Python OracleDB Batch Script Windows Task Scheduler

Data Engineer

Smartera 3S Solutions and Systems

Feb 2025 - Mar 2026 (1 year 1 month)

Developed and maintained Talend ETL pipelines with custom Java components to ingest and validate data from 40+ source tables into the CBR data mart, processing 250K+ daily records for regulatory reporting. Owned and evolved SSIS pipelines integrating Oracle IMAL core banking with digital channels, processing 500K+ daily transactions for downstream reporting.

Talend Java SQL SSIS Oracle Data Warehouse Star Schemas Regulatory Reporting CBE Data Quality ETL

Education

Degrees, certifications, and relevant coursework

Information Technology Institute (ITI)

Intensive Program, Business Intelligence

2024 - 2025

Completed a Business Intelligence Intensive Program at the Information Technology Institute (ITI) in Cairo from November 2024 to February 2025.

Menoufia University

Bachelor of Science, Computer Science

2019 - 2023

Earned a Bachelor of Science in Computer Science from the Faculty of Computers and Information, Menoufia University, from September 2019 to July 2023.