Onsite

Four Rounds from System Design to RAG

J.P. MorganSoftware Engineer II · Onsite · Aug 2026

Round 1: Hiring Manager System design: choose a project you previously worked on, design and explain its architecture end to end, and answer related follow-up questions. Database optimization: given a database table with user_id and region columns and more than one million rows, how would you optimize a query that looks up a specific record? Database indexing. Table partitioning. Sharding. Replic…

Shared by a candidate · reported Aug 2026. Interview formats change; use it as a guide, not a script.