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
24 practiced
Compare BigQuery, Snowflake, and Redshift for a BI team running many concurrent interactive dashboards and ad-hoc queries. Discuss concurrency handling, cost model (storage vs compute), performance for ad-hoc patterns, ease of scaling, caching behaviors, and operational overhead.
MediumTechnical
20 practiced
Estimate monthly cloud costs for two AWS architectures: (A) Athena + Glue over S3, and (B) Redshift + Spectrum with S3, given 1 TB/month of data scanned and 1,000 concurrent dashboard users executing unpredictable query patterns. Outline factors, formulas, assumptions, and where major uncertainties lie.
MediumTechnical
26 practiced
You need to evaluate ETL/ELT tooling options (Airflow + custom jobs, dbt, managed connectors like Fivetran) for a mid-size company. Define evaluation criteria and explain how you'd weigh developer productivity, governance, observability, cost, vendor lock-in, and maintainability.
MediumTechnical
20 practiced
For Tableau or Power BI, explain the trade-offs between using live connections versus scheduled data extracts for dashboards. Discuss impacts on data freshness, interactivity, warehouse load, cost, reliability, and maintenance overhead.
HardTechnical
25 practiced
As BI lead, prepare a business justification for migrating from legacy on-prem ETL to a cloud ELT approach using dbt and a cloud data warehouse. Include expected impacts on developer velocity, operational cost, maintainability, risks, and a high-level migration timeline with milestones.
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.