Data Career Hub
Menu
SQLPythonPySparkApache SparkKafkaAirflow

Study planner

90-Day Data Engineer Study Plan

90 days, 348 planned hours: about 3 hours on weekdays and 6 at weekends. Each day pairs one topic from every skill with a mock interview, revision or applications. Every topic links to its lesson.

Set a start date to see a calendar date on each day and highlight today. Saved in this browser only.

Phase 1: Foundations

Week 1SQL joins/windows solid + 15 DSA done

  1. Day 1SQL + DSA focus3 h
  2. Day 2Big Data Engineering3 h
  3. Day 3Cloud & Warehousing3 h
  4. Day 4Streaming Systems3 h
  5. Day 5System Design Deep-Dive6 h
  6. Day 6Data Modeling & SQL6 h
  7. Day 7Mock Interview Day3 h

Week 2Advanced SQL + 30 DSA + Spark core

  1. Day 8Big Data Engineering3 h
  2. Day 9Cloud & Warehousing3 h
  3. Day 10Streaming Systems3 h
  4. Day 11System Design Deep-Dive3 h
  5. Day 12Data Modeling & SQL6 h
  6. Day 13SQL + DSA focus6 h
  7. Day 14Mock Interview Day3 h

Week 3PySpark performance + Snowflake basics

  1. Day 15Cloud & Warehousing3 h
  2. Day 16Streaming Systems3 h
  3. Day 17System Design Deep-Dive3 h
  4. Day 18Data Modeling & SQL3 h
  5. Day 19SQL + DSA focus6 h
  6. Day 20Big Data Engineering6 h
  7. Day 21Mock Interview Day3 h

Week 41 end-to-end project + 50 DSA

  1. Day 22Streaming Systems3 h
  2. Day 23System Design Deep-Dive3 h
  3. Day 24Data Modeling & SQL3 h
  4. Day 25SQL + DSA focus3 h
  5. Day 26Big Data Engineering6 h
  6. Day 27Cloud & Warehousing6 h
  7. Day 28Mock Interview Day3 h

Week 5Kafka + streaming fundamentals

  1. Day 29System Design Deep-Dive3 h
  2. Day 30Data Modeling & SQL3 h

    Month 1: Core SQL+DSA+Spark mastered; 1 project; start applying Target: 60% prep • first OAs & recruiter calls.

Phase 2: Advanced + Projects

Week 5Kafka + streaming fundamentals

  1. Day 31SQL + DSA focus3 h
  2. Day 32Big Data Engineering3 h
  3. Day 33Cloud & Warehousing6 h
  4. Day 34Streaming Systems6 h
  5. Day 35Mock Interview Day3 h

Week 6Airflow + AWS Glue/Redshift

  1. Day 36Data Modeling & SQL3 h
  2. Day 37SQL + DSA focus3 h
  3. Day 38Big Data Engineering3 h
  4. Day 39Cloud & Warehousing3 h
  5. Day 40Streaming Systems6 h
  6. Day 41System Design Deep-Dive6 h
  7. Day 42Mock Interview Day3 h

Week 7Data modeling + 80 DSA

  1. Day 43SQL + DSA focus3 h
  2. Day 44Big Data Engineering3 h
  3. Day 45Cloud & Warehousing3 h
  4. Day 46Streaming Systems3 h
  5. Day 47System Design Deep-Dive6 h
  6. Day 48Data Modeling & SQL6 h
  7. Day 49Mock Interview Day3 h

Week 82nd project + system design start

  1. Day 50Big Data Engineering3 h
  2. Day 51Cloud & Warehousing3 h
  3. Day 52Streaming Systems3 h
  4. Day 53System Design Deep-Dive3 h
  5. Day 54Data Modeling & SQL6 h
  6. Day 55SQL + DSA focus6 h
  7. Day 56Mock Interview Day3 h

Week 95 system design scenarios + mocks

  1. Day 57Cloud & Warehousing3 h
  2. Day 58Streaming Systems3 h
  3. Day 59System Design Deep-Dive3 h
  4. Day 60Data Modeling & SQL3 h

    Month 2: Cloud+Streaming+Modeling done; 2 projects; active interviews Target: 85% prep • multiple onsites in pipeline.

Phase 3: Interview Mastery

Week 95 system design scenarios + mocks

  1. Day 61SQL + DSA focus6 h
  2. Day 62Big Data Engineering6 h
  3. Day 63Mock Interview Day3 h

Week 10110 DSA + revise weak areas

  1. Day 64Streaming Systems3 h
  2. Day 65System Design Deep-Dive3 h
  3. Day 66Data Modeling & SQL3 h
  4. Day 67SQL + DSA focus3 h
  5. Day 68Big Data Engineering6 h
  6. Day 69Cloud & Warehousing6 h
  7. Day 70Mock Interview Day3 h

Week 11Full mock loops + behavioral prep

  1. Day 71System Design Deep-Dive3 h
  2. Day 72Data Modeling & SQL3 h
  3. Day 73SQL + DSA focus3 h
  4. Day 74Big Data Engineering3 h
  5. Day 75Cloud & Warehousing6 h
  6. Day 76Streaming Systems6 h
  7. Day 77Mock Interview Day3 h

Week 12Final revision + apply aggressively

  1. Day 78Data Modeling & SQL3 h
  2. Day 79SQL + DSA focus3 h
  3. Day 80Big Data Engineering3 h
  4. Day 81Cloud & Warehousing3 h
  5. Day 82Streaming Systems6 h
  6. Day 83System Design Deep-Dive6 h
  7. Day 84Mock Interview Day3 h

Week 13Offer negotiation & decision

  1. Day 85SQL + DSA focus3 h
  2. Day 86Big Data Engineering3 h
  3. Day 87Cloud & Warehousing3 h
  4. Day 88Streaming Systems3 h
  5. Day 89System Design Deep-Dive6 h
  6. Day 90Data Modeling & SQL6 h

    Month 3: Interview-ready across stack; multiple offers; negotiate offers Target: 100% prep • offers in hand.

Search
Filter by type