Technical Foundation and Self Assessment Questions

Covers baseline technical knowledge and the candidate's ability to honestly assess and communicate their technical strengths and weaknesses. Topics include fundamental infrastructure and networking concepts, operating system and protocol basics, core development and platform concepts relevant to the role, and the candidate's candid self evaluation of their depth in specific technologies. Interviewers use this to calibrate how technical the candidate is expected to be, identify areas for growth, and ensure alignment of expectations between product and engineering for collaboration.

EasyTechnical

0 practiced

What is data lineage, and why is it critical for BI and reporting? Describe the minimum set of lineage metadata you would capture for every dashboard metric to enable traceability, debugging, and impact analysis.

EasyTechnical

0 practiced

Implement in Python a function compute_column_means(csv_path: str) -> dict that loads a CSV using pandas, ignores non-numeric columns, treats empty strings and NaN as missing, and returns a mapping column_name -> mean. Provide concise, production-ready code (error handling optional).

HardSystem Design

0 practiced

Design a BI reporting architecture that supports both near-real-time dashboards (<=60s latency) and historical batch analytics for 100M events/day and up to 1k concurrent dashboard users. Describe ingestion, streaming vs batch processing, storage choices, serving layer, caching strategy, and how you would meet SLAs while controlling cost.

MediumTechnical

0 practiced

A critical report uses filters on customer_id and a date range and aggregates revenue by product_id. Which indexing strategies would you consider (single-column, composite, covering indexes) to accelerate queries, and how would you measure their impact? Discuss trade-offs and maintenance implications.

MediumTechnical

0 practiced

Explain p-values and confidence intervals in plain language and describe how you would present the results of an A/B test (conversion uplift and 95% CI) to a nontechnical executive so they can make a business decision.

Unlock Full Question Bank

Get access to hundreds of Technical Foundation and Self Assessment interview questions and detailed answers.

Join thousands of developers preparing for their dream job.