Module-8 – Interview & System Design

🎯 Objectives

• Polish résumé, LinkedIn & portfolio.
• Drill common Data-Engineering interview Q&A.
• Master system-design thinking & whiteboard skills.

🗓️ Weekly Plan

• Week 29 – Résumé & LinkedIn optimization; project stories.
• Week 30 – Mock interviews: STAR, technical Q&A & design drills.

🔑Key Concepts

Résumé & Portfolio

• Structure: summary, skills, experience, projects.
• Keywords: Azure, Spark, Fabric, ETL, data-warehouse.

Behavioral Interviews

• STAR method: Situation, Task, Action, Result.

Technical Q&A

• SQL tuning, Spark internals, ADF/Databricks patterns.

System Design

• Architectures: Lambda, Kappa, Medallion.
• Components: ingestion, storage, transform, serve, monitoring.

Trade-offs

• Consistency vs availability, cost vs performance, batch vs streaming.

🔨 Mini-Projects

• Interview Q&A: record answers to 50+ Azure DE questions.
• Design Whiteboard: sketch an end-to-end data platform for retail.
• Portfolio Polish: finalize GitHub repo + demo video.

📚 Resources

• Designing Data-Intensive Applications (storage & distributed systems)
• GitHub portfolio best practices
• LeetCode & Glassdoor question banks