Top 2
Prep plan
Updated weekly · Last refresh Oct 17Castlight Data Analyst Interview Questions
The questions to prepare for a Castlight Data Analyst interview. Questions from real interview reports rank first. Updated daily.
2questions
~1htotal time
Track your progressSign up free to work through all 2 questions and resume where you left off.
Start practicing free →1
SQL & Data ManipulationStart here. 1 question + 3 drills · ~38 min
SQL DDL and Performance TuningHard
Evaluates your ability to design database structures and optimize query and system performance.
Performance Tuning
Castlight
CastlightSQL Query OptimizationMedium
Practice
Practice drillOptimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.
Performance Tuningdatabase optimizationindexesDDroisys
Capgemini
Nomura
CapgeminiNomuraOptimizing Slow SQL QueriesHard
Practice
Practice drillOptimize a PostgreSQL transaction query that filters, aggregates, ranks, and returns top merchants efficiently on large tables.
Performance Tuningdatabase optimizationlarge datasets
Sprinter Health
SentiLink
Autodesk
Sprinter HealthSentiLinkAutodeskOptimize Slow Queries on Large DataMedium
Practice
Practice drillOptimize a slow PostgreSQL query on a large dataset by choosing better filters, joins, and indexes.
Performance Tuningdatabase optimizationdatabase management
CitiTThoucentricPPitney Bowes
CitiTThoucentricPPitney Bowes2
Behavioral & Leadership1 question · ~8 min
Clarifying Your Ideal RoleEasy
Assesses role fit, motivations, and how you align your goals with the Data Analyst work.
career goalsinterestCastlight
CastlightSign up to see every question
Create a free account to unlock this list and practice real interview questions.
The finish line: interview-readyComplete all 2 questions plus 3 hands-on drills to finish this plan.