Castlight Interview Questions
The questions to prepare for Castlight interviews, across all roles. Questions from real interview reports rank first. Updated daily.
Approach for maintaining data quality and integrity across ETL pipelines.
CastlightSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Define a practical framework for judging design success using leading, lagging, and funnel-based product metrics.
CastlightApproach for building accessibility into product design through user needs, research, use cases, and measurable outcomes.
CastlightExplain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.
CastlightAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreMeasure dashboard adoption by Johns Hopkins user segment using joins, aggregation, and reporting-period filters.
The Johns Hopkins UniversityCreate a unified Johns Hopkins University dashboard result by combining department activity, users, and targets.
The Johns Hopkins UniversityFramework for finding credible upsell opportunities inside an active consulting engagement while staying anchored in customer value and ROI.
CastlightIdentify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.
CastlightManage a complex sale by requalifying often, multi-threading stakeholders, and controlling requirement drift with a clear mutual plan.
Castlight