Intermediate everything in Data Science & Analytics
Demographic Parity versus Equalized Odds in hiring
Demographic parity equalizes selection rates regardless of qualification; equalized odds equalizes true and false positive rates across groups, conditioning on the true label.
Explain an interaction effect to a non-statistician
Define interaction as it depends on, show separate slope lines per age group, give the business takeaway on targeting.
Present a small but significant A/B test lift
Hypothesis, design and validity checks, result with effect size and interval, business impact of 0.5%, then a clear recommendation.
Interactive versus static plots for EDA
Interactive libraries win for exploring dense, high-cardinality, or multi-dimensional data via zoom, hover, and filtering; static plots win for reproducible, publication output.
Parquet versus CSV for analytical data lakes
Parquet stores by column enabling projection pushdown, compression, and predicate skipping; CSV is row-based, untyped, and slow to scan.
Audit an ML pipeline for GDPR compliance
Inventory data and check minimization, verify processing matches stated purpose, build lineage to trace any prediction's inputs.
A/B test two fraud models in production
Randomize by entity, consider shadow mode first, collect precision/recall and business loss, decide with significance and guardrails.
Communicate a forecast interval to an executive
Give the point estimate but frame the range as scenarios, use a fan chart, tie the interval to planning decisions and risk.
Purpose of watermarks in Spark Structured Streaming
A watermark sets a threshold on event-time lateness, lets late data update windows up to that bound, and tells Spark when to finalize and drop old state.
repartition() versus coalesce() in Spark
Repartition does a full shuffle and can increase or balance partitions; coalesce avoids a full shuffle and only reduces them.
Explain a loan denial with LIME or SHAP
LIME fits a local surrogate, SHAP attributes the prediction across features via Shapley values, both give per-feature contributions.
Design an automated A/B test reporting system
Standardized metric definitions, automated stats with confidence intervals and guardrails, segment breakdowns, a clear ship recommendation.
Explain false positives and negatives for churn
False positive flags a loyal customer (wasted incentive), false negative misses a leaver (lost customer), tie to threshold choice.
Catalyst Optimizer and Project Tungsten in Spark
Catalyst transforms logical plans with rules, picks physical plans by cost; Tungsten optimizes execution with off-heap memory and codegen.
Primary metric up, guardrail down: ship or not?
Tie metrics to business value, weigh short-term lift against retention damage, use guardrails and an overall evaluation criterion.
Handle source schema changes without downtime
Add columns as nullable additive changes, version the schema, use formats like Iceberg or Parquet that support evolution, backfill new types safely.
Design a SQL upsert from a staging table
Define a stable key, use MERGE or INSERT ON CONFLICT, dedupe the staging set first, run in a transaction.
Explain KNN or MICE imputation principles
KNN borrows from similar rows, MICE models each variable from the others iteratively and creates multiple datasets.
When should you keep outliers, not drop them?
Keep them in fraud or anomaly detection, use robust models and metrics.
pandas .apply() versus vectorized operations
Apply runs a Python function per row or column, flexible but slow due to per-element looping; prefer vectorized ops; use apply only for custom logic with no vectorized equivalent.
We are hiring for this. Every open role lists the topics its interview covers, so you can prepare for the real thing rather than guessing.
See open roles