Skip to content
View Mazhar-Kakar's full-sized avatar

Block or report Mazhar-Kakar

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
mazhar-kakar/README.md

Hello Tech Folks 👋

Aspiring Data Engineer with hands-on experience in Python, SQL, AWS S3, Snowflake, and dbt. Built end-to-end data engineering projects, ETL/ELT pipelines, and SQL-based data transformations. Comfortable writing SQL queries, cleaning datasets, and explaining design trade-offs clearly.


🚀 Featured Project

RetailFlow — End-to-End ELT Data Pipeline

Built a production-inspired ELT pipeline that ingests retail data, stores it in a cloud data warehouse, and transforms it into business-ready analytics models.

Architecture

PostgreSQL
      ↓
Python ETL Pipeline
      ↓
Amazon S3 (Parquet)
      ↓
Snowflake (Bronze)
      ↓
dbt (Staging → Intermediate → Fact & Dimensions → Business Marts)
      ↓
Power BI Dashboard

Project Highlights

  • Extracted retail data from PostgreSQL using Python.
  • Converted data to Parquet and stored it in Amazon S3.
  • Loaded raw data into Snowflake using COPY INTO.
  • Built a layered dbt project with:
    • Staging Models
    • Intermediate Models
    • Fact & Dimension Tables
    • Business Data Marts
  • Implemented data quality validations and reusable dbt macros.
  • Designed a Star Schema for analytics.
  • Prepared business-ready datasets for Power BI reporting.

🛠️ Tech Stack

  • Python
  • SQL
  • PostgreSQL
  • Amazon S3
  • Snowflake
  • dbt
  • Power BI
  • Git & GitHub

📖 Currently Learning

  • Apache Airflow
  • Advanced dbt
  • Data Warehouse Design
  • Production Data Engineering

🤝 Let's Connect

I'm actively looking for a Data Engineering Internship where I can contribute, learn from experienced engineers, and continue building real-world data platforms.

Feel free to connect if you'd like to discuss Data Engineering, dbt, Snowflake, or modern ELT architectures.

Pinned Loading

  1. retailflow-elt-pipeline retailflow-elt-pipeline Public

    Modern ELT Data pipeline with dbt transformation. Includes data ingestion using python from postgresql to amazon s3, copy data into snowflake from s3 build dbt models. implemented Incremental loadi…

    Python

  2. ai-nl-to-sql-analytics-platform ai-nl-to-sql-analytics-platform Public

    AI-powered data analytics platform that converts natural language into SQL queries using LLM (Ollama/Qwen) and execute on Mysql.

    Python 1