Interview Prep

Topics: SQL basics, Python basics, Probability rules, Key terminology

Topics: SQL window functions, Pandas groupby/merge, Bayes' theorem, OLAP vs OLTP

Topics: SQL LAG/LEAD, Pandas transform vs apply, Distributions, Product sense GAME framework

Topics: Hypothesis testing, P-values, Type I/II errors, SQL self-joins, Python loc vs iloc

Topics: Bias-variance tradeoff, Random Forest vs XGBoost, SQL rolling averages, Probability puzzles

Topics: L1/L2 regularization, Classification metrics, A/B testing basics, Python generators, SQL duplicates

Topics: A/B testing pitfalls, Root cause analysis, Logistic regression, Python missing data, Behavioral "failure" story

Topics: Handling imbalanced data, Feature engineering, SQL consecutive days pattern, Pandas pivot/melt, CAP theorem

Topics: Cross-validation, Decision trees, Product metric design, Python decorators, SQL date manipulation

Topics: CLT, Confidence intervals, SQL anti-join + EXISTS, Gradient descent, Batch vs streaming

Topics: Fermi estimation, DL basics (when asked), Pandas memory optimization, Coupon collector, Star schema

Topics: NLP basics, Time series concepts, Advanced product questions, MLOps terminology, SQL UNION

Topics: Chicago interview patterns, PCA, SQL HAVING vs WHERE, Python `if __name__`, Behavioral collaboration story