Porch Group Data Engineer Interview Questions
The questions to prepare for a Porch Group Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Compare PostgreSQL index strategies by read latency, write overhead, storage size, and an overall cost score.
Explain how to run PostgreSQL schema migrations without downtime while preserving compatibility, integrity, and performance.
Explain OLTP vs OLAP designs, including schema shape, workload patterns, and when each is appropriate in a data platform.
Classify clinical-data indexes by read usage and estimated write-maintenance overhead.
MedpaceOptimize a PostgreSQL reporting query by reducing intermediate rows, using appropriate joins, and calculating monthly performance efficiently.
The Cigna Group
ElemicaExplain when SQL or NoSQL is appropriate in an end-to-end ML system, including consistency, scale, latency, and operational tradeoffs.
Design a fault-tolerant real-time processing pipeline with low latency, reliable delivery, replay, data quality, and scalable serving.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.