🔍 Ctrl+K
🎯 Interview Preparation • GOLDEN_QUESTIONNAIRE_JULY_2026.pdf

Interview Prep Track

11 dedicated interview lessons — 168 real questions with interview-ready answers, code snippets and tips, straight from your Golden Questionnaire (July 2026) + docs/introduction/intro.md. Separate from the SQL/PySpark/AWS guides.

Start with Introduction → Scenario Questions (33)

Lesson Path

11 lessons • 168 questions • each with answer, code & tip — mark as complete as you go

🎙️ 00

Introduction & Basics

35 Qs — self-intro, pipeline architecture, S3/Glue/Athena/Redshift, scenarios & challenges

Explore →
🐍 01

Python

12 Qs — comprehension, decorators, generators, *args, GC, threading

Explore →
🐼 02

Pandas

7 Qs — Series vs DataFrame, merge/join/concat, loc/iloc, dedup, explode

Explore →
🗄️ 03

SQL

12 Qs — normalization, window functions, indexes, CTE, execution order, DELETE vs TRUNCATE

Explore →
⚡ 04

PySpark

12 Qs — architecture, lazy evaluation, cache/persist, skew, salting code

Explore →
☁️ 05

AWS

17 Qs — S3, Glue, Lambda, Redshift dist/sort keys, Athena, DMS, SCD2

Explore →
🌀 06

Airflow

6 Qs — DAGs, XCom push/pull, triggers, retries, dependencies, vs Step Functions

Explore →
🔷 07

Azure

10 Qs — ADF incremental load, Unity Catalog, Delta Lake, Key Vault, PII

Explore →
🧩 08

Scenario Questions

33 Qs — failures, skew, schema evolution, API throttling, GDPR, SLAs

Explore →
🌿 09

Git & GitHub

12 Qs — workflow, branches, PRs, conflicts, fetch vs pull, undo commits

Explore →
🚀 10

CI/CD

12 Qs — PR checks, environments, secrets, IaC, approvals, monitoring

Explore →