Data Engineer

• Extracted data from various data sources(PostgreSQL, MSSQL Server, Couchbase DB, SAP Hana, Kafka, APIs, Web Pages) by using internally developed data ingestion tools, cdc tools, Kafka Connect and Python scripts;

• Developed ELT processes on Vertica;

• Developed ELT processes on BigQuery;

• Migrated Vertica ELT processes to BigQuery;

• Developed Python scripts for automating internal processes;

• Developed Java programs to move data in and out of Kafka (Developed SMTs for Kafka Connect, developed Kafka Streams programs);

• Maintained Kafka Connect clusters;

• Supported other teams for query performance tuning, data access etc;

• Made small proof of concepts for open source tools like Apache Airflow, Azkaban, Prefect;

• Contributed to internal data infrastructure codebase.

Highlighted Projects:

Took part in establishing new businesses in the financial services area and creating sub-companies for those businesses to meet regulatory requirements. Specifically, they played a role in building the data infrastructure for one of the newly established companies.

Additionally, developed a Kafka Streams program in Java that reads order events from Kafka and uses an API to determine which order items received free shipping promotions. The program writes the API responses to another Kafka topic.

Another project involved exporting all SQL scripts in the repo to Vertica and BigQuery tables for impact analysis and lineage. To identify which hand is running in a scheduler, Mehmet developed a Python script that flags scheduled scripts and includes scheduler metadata, such as the script's current flow or DAG and Cron Expression, to enrich their tables and help analysts make better impact analyses.

Lastly, as part of a microservices transformation at Trendyol, Mehmet designed and implemented a new data pipeline for the Coupon system, which switched its backend from the MSSQL Server to Couchbase DB. The new system produces approximately 10 - 15 GBs of change each day.

i2i Systems is an international information technology company. That specializes in developing innovative ideas and solutions, with its highly experienced team in the Telecommunications industry, it offers a diverse variety of products in Telco OSS/BSS domains, as well as 5G network solutions.

Vodafone DWH Reengineering Project:

• Developed ETL processes via Ab Initio (Acquire>It, MDW);
• Developed Bash scripts;
• Developed PL/SQL procedures;
• Developed Excel VBA programs for automating UC4 flow creation processes;
• Supported testing and reconciliation processes Volkswagen Doğuş Finans DWH Project;
• Created SSIS packages for ETL processes;
• Developed SQL stored procedures.