John Hancock Interview Questions
The questions to prepare for John Hancock interviews, across all roles. Questions from real interview reports rank first. Updated weekly.
Identify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.
John HancockExplain how to profile, clean, and standardize missing or dirty data before analysis.
John HancockUse joins, CTEs, and row ranking to resolve conflicting customer profile values across ACME House systems.
Ramsey Solutions
ACME HouseReconcile billing and ERP invoice totals using joins, a CTE for latest snapshots, and CASE-based discrepancy classification.
LiteratiUse joins and CASE WHEN to find CRM records with missing, invalid, or conflicting ownership data by team.
AlphaSenseSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Outline the first checks to diagnose a sudden drop in a core product metric, starting with data quality, scope, and decomposition.
John HancockExplain how to reduce overfitting using regularization, validation, and model selection.
John HancockExplain what a p-value means in hypothesis testing and how it relates to statistical significance.
John HancockExplain how you gather and align requirements when stakeholders want different outcomes and priorities.
John HancockExplain when to use first-touch, last-touch, or multi-touch attribution based on business goals, funnel structure, and measurement limits.
John HancockExplain how you evaluate models using the right metrics, validation strategy, and error analysis for the problem.
John Hancock