How to become Data Engineer?

Watch this below video

Must go-through (free resources):

Azure Data factory

• Azure Data Factory by WafaStudies [Mandatory]
• Azure Data Factory by Adam Marczak [Mandatory]

---

Azure Synapse

• Azure Synapse Analytics by WafaStudies [Optional]

---

Azure Databricks

• Azure Databricks by WafaStudies [Mandatory]
• Azure Databricks by Adam Marczak [Mandatory]

---

Pyspark

• Pyspark wiki [Mandatory]
• Pyspark Notes [Interview Questions]

---

SQL

• SQL by kudvenkat [Mandatory]
• SQL Practice HackerRank [Mandatory]
• SQL Practice Naukri [Mandatory]
• SQL Practice Datalemur [Mandatory]

---

Python

• Python by Corey Schafer [Mandatory]

---

git

• Git Essentials by Corey Schafer [Preferred]
• Git Hindi by CodeWithHarry [Optional]

---

Azure Fundamentals

• Azure Data Fundamentals [Preferred]

Spark Advanced videos with slides (must for Interview)

1. Making Apache Spark Better with Delta Lake [Presentation slides here]
2. Understanding Query Plans and Spark UIs - Xiao Li Databricks [Presentation slides here]
3. Optimizing Delta Parquet Data Lakes for Apache Spark - Matthew Powers [Presentation slides here]
4. Everyday I'm Shuffling - Tips for Writing Better Apache Spark Programs [Presentation slides here]
5. Optimizing Apache Spark SQL Joins: Spark Summit East talk by Vida Ha [Presentation slides here]
6. Apache Spark Core—Deep Dive—Proper Optimization Daniel Tomes Databricks [Presentation slides here]
7. The Parquet Format and Performance Optimization Opportunities Boudewijn Braams [Presentation slides here]
8. Easy, Scalable, Fault Tolerant Stream Processing with Structured Streaming in Apache Spark [Presentation slides here]
9. Spark Architecture, Alexey Grishchenko [Presentation slides here]
10. Deeper Understanding of Spark Internals - Aaron Davidson [Presentation slides here]
11. Advanced Apache Spark Training - Sameer Farooqui [Presentation slides here]
12. Top 5 Mistakes When Writing Spark Applications [Presentation slides here]
13. Spark SQL: A compiler from Queries to RDDS with Sameer Agarwal [Presentation slides here]
14. Deep Dive into Spark SQL with Advanced Performance Tuning with Xiao Li & Wenchen Fan [Presentation slides here]
15. A Deep Dive into Spark SQL's Catalyst Optimizer with Yin Huai [Presentation slides here]
16. Spark + Parquet In Depth: Spark Summit East talk by: Emily Curtin and Robbie Strickland [Presentation slides here]
17. Change Data Feed in Delta [Presentation slides here]
18. Deep Dive into Delta Lake [Presentation slides here]
19. Diving into Delta Lake: Unpacking the Transaction Log [Presentation slides here]
20. Delta Lake 2.0 Overview [Presentation slides here]
21. Accelerating Data Ingestion with Databricks Autoloader Simon [Presentation slides here]
22. Tuning and Debugging in Apache Spark Patrick Wendell [Presentation slides here]
23. Tuning Apache Spark for Large-Scale Workloads Gaoxiang Liu and Sital Kedia [Presentation slides here]
24. Understanding the Performance of Spark Applications - Patrick Wendell [Presentation slides here]
25. SQL, DataFrames, Datasets And Streaming - by Michael Armbrust [Presentation slides here]
26. Apache Spark 2.0: A Deep Dive Into Structured Streaming - by Tathagata Das [Presentation slides here]
27. Designing ETL Pipelines with Structured Streaming and Delta Lake How to Architect Things Right [Presentation slides here]
28. Deep Dive: Apache Spark Memory Management [Presentation slides here]

Fastrack Interview

WIP

Optional resources for Mechanical Engineers:

• Azure IoT Hub Part 1
• Azure IoT Hub Part 2
• Modern Industrial IoT Analytics on Azure - Part 1
• Modern Industrial IoT Analytics on Azure - Part 2
• Modern Industrial IoT Analytics on Azure - Part 3
• Azure Stream Analytics
• Azure Stream Analytics by Adam
• Azure Stream Analytics by Pragmatics

Certifications:

• Exam DP-203: Data Engineering on Microsoft Azure [Preferred] [Questions]
• Databricks Certified Data Engineer Associate [Preferred] [Questions]
• Databricks Certified Data Engineer Professional [Preferred] [Questions]
• Exam DP-900: Microsoft Azure Data Fundamentals [Optional]

Advanced Reads:

• Delta Lake Essentials [Preferred]
• Delta Lake blogs [Preferred]

Free Cloud Resources:

• Azure Free Account [Use new Credit Card]
• Databricks Community [choose - “Get started with Community Edition”]

𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 Burger

Road Map to Data Engineer

Data Warehouse vs Lake vs Mesh

Data Warehouse vs Lake vs Lakehouse vs Mesh

Cloud Platform Models

ETL vs ELT vs reverse ETL

Star vs Snowflake Schema

Medallion Architecture

Database Types

Database Indexing

SQL Execution Order

HTTP status code

Containerization