Dataford
Top 50
Company roadmap
Updated weekly · Last refresh Aug 30

HII Interview Questions

The questions to prepare for HII interviews, across all roles. Questions from real interview reports rank first. Updated weekly.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
Machine LearningStart here. 3 questions · ~24 min
Supervised vs Unsupervised LearningEasy

Explain how supervised and unsupervised learning differ, and ground the distinction in a practical ML example.

Unsupervised LearningFeature EngineeringBias-Variance TradeoffHII
More Machine Learning questions with a free account
2
Execution10 questions · ~81 min
Handle Scope Creep Mid-ProjectMedium

Explain how you would manage scope creep without damaging stakeholder trust or putting delivery at risk.

Trade-offsRisk AssessmentScope ManagementHII
More Execution questions with a free account
3
Metrics3 questions · ~24 min
Diagnose KPI Drop After ReleaseMedium

Diagnose a post-release KPI drop by separating instrumentation issues from real behavior changes and tracing the problem through the metric hierarchy.

KPILeading IndicatorsDiagnosisHII
More Metrics questions with a free account
4
Coding3 questions · ~24 min
More Coding questions with a free account
5
Product Sense3 questions · ~24 min
More Product Sense questions with a free account
6
SQL & Data Manipulation5 questions + 3 drills · ~70 min
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
Handle Missing Financial Input ValuesMedium
Practice
Practice drill

Use joins, CTEs, and CASE logic to flag and fill missing financial fields for Qlik planning records.

Data WranglingETLQualityQlik
Clean Event Statuses for AnalysisEasy
Practice
Practice drill

Clean raw status text with TRIM and LOWER, filter unusable rows, and count usable events by cleaned status.

Data WranglingETLQualityDatabricks
More SQL & Data Manipulation questions with a free account
7
More topics23 questions · ~186 min
Tell Me About YourselfEasy

Tests your ability to deliver a clear, relevant introduction tailored to the role at Aqr.

Competitive AnalysisGo-to-MarketHII
Pitfalls in Streaming Experiment AnalysisHard

Identify major online experiment pitfalls and explain how they can bias results in a streaming product A/B test.

Network InterferenceNovelty EffectSample Ratio MismatchHII
Evaluating Observed Lift SignificanceMedium

Explain how to test whether an observed experiment lift is real using hypothesis testing, p-values, and confidence intervals.

Confidence IntervalsStatistical SignificanceP-ValuesHII
Evaluating Imbalanced Classification ModelsMedium

Explain how to evaluate a classifier on imbalanced data, with focus on metrics that are more informative than accuracy.

F1 ScorePrecisionRecallHII
Legacy Data Migration ConsistencyHard

Approach for keeping data consistent during a legacy-to-new-platform migration, including validation, replay safety, and reconciliation.

ETLData ModelingQualityHII
More questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.