People Tech Group Interview Questions
The questions to prepare for People Tech Group interviews, across all roles. Questions from real interview reports rank first. Updated weekly.
Find the second highest salary in each department without using aggregate functions.
People Tech GroupUse ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.
Replit
QuantcastFind the top 3 customers in each region by transaction volume using joins, aggregation, and window ranking.
JPMorganChase
Silicon Valley Bank
NaviReverse a string using basic iteration and swapping, without built-in reverse helpers.
People Tech GroupSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Explain how to test whether an observed experiment lift is real using hypothesis testing, p-values, and confidence intervals.
People Tech GroupExplain the bias-variance tradeoff mathematically and how L1 and L2 regularization change model complexity and weights.
People Tech GroupExplain how transformer self-attention works, including its role in sequence modeling and why it scales better than RNNs.
People Tech GroupDiagnose a post-release KPI drop by separating instrumentation issues from real behavior changes and tracing the problem through the metric hierarchy.
People Tech GroupDefine a success metric for a new feature that captures real user value, not just raw usage.
People Tech GroupChoose the right evaluation metric for an imbalanced dataset and explain why accuracy can mislead.
People Tech Group