Technical Stack and Infrastructure Questions
Addresses the technology stack and platform infrastructure choices that support a product. Topics include cloud architecture, deployment platforms, service and data layer design, observability and monitoring, scalability and performance considerations, tooling for build and release, and assessing technical debt or modernization needs in the stack. Also covers evaluation of BI tools, ETL platforms, and how infrastructure choices affect team velocity and operational cost.
MediumTechnical
40 practiced
Your product team wants embedded analytics inside the application. Define evaluation criteria for choosing a visualization platform for embedding (licensing and pricing model, SDK/APIs, authentication/SSO, row-level security, performance, theming/customization, and multi-tenancy). List key vendor questions to ask during selection.
HardTechnical
33 practiced
Design controls and processes to ensure GDPR compliance for a BI platform that stores and analyzes personal data. Cover data classification, minimization, pseudonymization or aggregation, access control, audit logging, consent management, retention/deletion workflows, and vendor assessments.
HardSystem Design
21 practiced
Design a federated analytics architecture where sensitive datasets must remain on-premises but need joining with cloud-hosted datasets for BI reporting. Propose secure query patterns, data virtualization options (e.g., Trino/Presto), performance mitigations, and trade-offs including latency and complexity.
HardTechnical
25 practiced
Your company's cloud analytics bill has ballooned and leadership asks you to reduce costs by 40% within three months without materially impacting critical reporting. Create a 3-month action plan with immediate quick wins, medium-term optimizations, and longer-term architectural changes, and propose KPIs to track progress and validate no business impact.
HardSystem Design
23 practiced
Design a CI/CD pipeline for dbt-driven data transformations. Include code review, unit and integration testing, ephemeral or dev environments, environment promotion, scheduling, secrets handling, rollback procedures, and coordination for schema migrations with downstream consumers.
Unlock Full Question Bank
Get access to hundreds of Technical Stack and Infrastructure interview questions and detailed answers.
Sign in to ContinueJoin thousands of developers preparing for their dream job.