Sun Life Financial Interview Questions
The questions to prepare for Sun Life Financial interviews, across all roles. Questions from real interview reports rank first. Updated weekly.
Use a CTE, join, and RANK window function to find employees earning the third-highest distinct salary.
Sun Life FinancialAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreUse joins, CTEs, and row ranking to resolve conflicting customer profile values across ACME House systems.
Ramsey Solutions
ACME HouseSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Approach for maintaining data quality and integrity across ETL pipelines.
Sun Life FinancialExplain how you would diagnose and recover a project that is falling behind schedule without losing stakeholder trust.
Sun Life FinancialSet a clear north star, supporting KPIs, leading indicators, and guardrails for a new product feature.
Sun Life FinancialExplain the bias-variance tradeoff mathematically and how L1 and L2 regularization change model complexity and weights.
Sun Life FinancialIdentify major online experiment pitfalls and explain how they can bias results in a streaming product A/B test.
Sun Life FinancialDesign a production ranking system with robust feature drift monitoring across batch and real-time features at high QPS.
Sun Life Financial