Ayesa Digital Interview Questions
The questions to prepare for Ayesa Digital interviews, across all roles. Questions from real interview reports rank first. Updated daily.
Calculate three-day rolling user activity averages and classify behavior trends with SQL window functions.
Optimize a slow PostgreSQL query on a large dataset by choosing better filters, joins, and indexes.
Explain how to handle NULLs, skewed values, and outliers when preparing an analysis dataset using SQL.
Join two tables and derive palindrome, reversed-substring, and character-frequency results with PostgreSQL.
HsbcDetermine the sample size needed to detect a meaningful A/B test effect at a chosen significance level and power.
Identify major online experimentation pitfalls and explain practical mitigations for SRM, network effects, peeking, and novelty.
A treatment shows a positive lift, but the confidence interval is wide. Explain how to judge actionability and decide whether to ship or gather more evidence.
Outline the first checks to diagnose a sudden drop in a core product metric, starting with data quality, scope, and decomposition.
Explain what statistical significance means and why it matters when interpreting experimental or analytical results.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.