Skip to content

data-engineering-helpers/data-engineering-skilling

Repository files navigation

Knowledge Sharing - Data Engineering skilling

Table of Content (ToC)

Created by gh-md-toc

Overview

This project aims at collecting in a single place training resources for the up skilling of data engineers.

Even though the members of the GitHub organization may be employed by some companies, they speak on their personal behalf and do not represent these companies.

References

Data Engineering helpers

Articles and posts

Spark jobs, stages and tasks

Idempotency with Spark

Complete SQL and PySpark guide

End-to-end project in the AI era

  • Link to the article on Medium
  • Title: How Important It Has Become to Build a Pet Project or Product-Equivalent E2E Project on Your Own in the AI Era

Full open source lakehouse

Data Engineering fundamentals

Key Takeaways:

  • Data engineering is the discipline of building systems that move data reliably from source to use: ingestion, transformation, validation, storage, and consumption.
  • The job has shifted from "moving data" to "ensuring data is correct, fresh, and usable" at every pipeline stage.
  • Data engineering is evolving toward greater automation, observability, and governance.
  • Most data failures are silent: pipelines run successfully but produce incorrect outputs. Engineers' job is to design systems that fail visibly.

Core skills of a Data Engineer:

  1. Strong SQL capability
  2. Python or a similar general-purpose language
  3. How data should be modeled
  4. Distributed systems thinking
  5. Cloud infrastructure knowledge
  6. Reason about data quality
  7. Communication

Data Engineering - How to transition from one role to the next

The Essential Skill Stack: Foundational Knowledge Every Data Engineer Must Hav

Data Engineering is not one job anymore

Claude Skills in Data Engineering

Spark on Luminousmen on Substack

Anatomy of Spark applications

Awesome open source Data Engineering - Resources by Gunnar Morling

Data ingestion methods

Data Talks Club - Zoomcamp

Reliable Data Engineering

Data Engineering Design Patterns You Must Learn in 2026

  • Title: Data Engineering Design Patterns You Must Learn in 2026
  • Date: Jan. 2026
  • Article on Medium

Data Expert - Resources by Zach Wilson

Data Engineer handbook

Awesome Data Engineering - Resources by Igor Barinov

Data Engineering resources by Amjń

Data Engineering resources by Ahmed Alsaket

Article - 2025-08

Learning

  1. Scrimba - Master Python
  2. Scrimba - Learn SQL
  3. Scrimba - Learn MySQL
  4. Scrimba - Learn MongoDB
  5. Scrimba - Dominate PySpark
  6. Scrimba - Learn Bash, Airflow & Kafka
  7. Scrimba - Learn Git & GitHub
  8. Scrimba - Learn CICD basics
  9. Scrimba - Decode Data Warehousing
  10. Scrimba - Learn DBT
  11. Scrimba - Learn Data Lakes
  12. Scrimba - Learn DataBricks
  13. Scrimba - Learn Azure Databricks
  14. Scrimba - Learn Snowflake
  15. Scrimba - Learn Apache NiFi
  16. Scrimba - Learn Debezium

Portfolio with 5 must-try projects

  1. Scrimba - Reddit ETL Pipeline
  2. Scrimba - Surfline Dashboard
  3. Scrimba - Finnhub Streaming Data Pipeline
  4. Scrimba - Audiophile End-To-End ELT Pipeline
  5. Scrimba - Streamify

Data Engineering articles by Saurav Singh

Data Engineering articles by Mayurkumar Surani

Data Engineering Q&A by Sachin Chandrashekhar

Data Engineering on DataBricks by Jakub Lasak

Jakub Lasak - Senior Databricks Data Engineer interview

Data Engineering illustrations by Riya Khandelwal

Books

Fundamentals of Data Engineering

Designing Data Intensive Applications

Curricula

DataBricks Growth Path

DataExpert

Data Engineering training

Transition from data science to data engineering

Specific topics

DataBricks - Data Engineering

Spark koans

Open source all included stacks

  • GitHub - Abel Tavares - Batch data pipeline
  • Date: Nov. 2025
  • Author: Abel Tavares
  • Post on LinkedIn
  • Overview:
    • Abel built a batch data pipeline with observability, data quality, and lineage tracking using open-source tools.
      • Apache Airflow for orchestration
      • DuckDB for fast analytical processing
      • Delta Lake for ACID transactions on data lakes
      • MinIO (S3-compatible) for storage
      • Trino Software Foundation for distributed SQL queries
      • Metabase for dashboards
      • Soda core for data quality checks
      • Marquez + OpenLineage for end-to-end lineage
      • Prometheus Group + Grafana Labs for monitoring
  • The pipeline follows the Medallion Architecture (Bronze → Silver → Gold) with automated data cleaning, validation, and business aggregations.
  • Everything runs with Docker, including automated dashboard generation in Metabase and Grafana.

Architecture

Python

Data Analysis with SQL

Duplication removal

Web sites

Data Engineering toolkit by Second brain

About

Skilling/training resources for data engineers

Topics

Resources

License

Stars

4 stars

Watchers

0 watching

Forks

Releases

No releases published

Packages

 
 
 

Contributors