The Johns Hopkins University Software Engineer Interview Guide

The 60-second brief

As a Software Engineer at The Johns Hopkins University, you serve as a critical technical driver supporting groundbreaking research, public health initiatives, enterprise operations, and academic excellence across the institution. This role bridges complex business, clinical, and scientific requirements with robust technical architectures, translating high-level organizational goals into scalable software solutions, reliable data pipelines, and high-performance computing frameworks. You will work closely with interdisciplinary teams—ranging from faculty researchers and data scientists to system administrators and product stakeholders—to design, develop, and maintain both homegrown applications and enterprise-wide systems.

This guide is scoped to a Software Engineer candidate at The Johns Hopkins University.

Focus areas

• System Design
• Relational Database Architecture
• Python

The The Johns Hopkins University interview process

The Johns Hopkins University candidates report 4 rounds over 3-5 weeks. The stages below are what candidates describe, not a published process.

Recruiter/HR Touchpoint

Initial communication to discuss the role, expectations, and logistics.

What to demonstrate

• Initial communication to discuss the role, expectations, and logistics
• Depth in System Design

How to prepare

• Be able to walk your CV end to end in two minutes, and say why this company specifically.
• Have your salary expectations, notice period and location constraints ready, and ask for the rest of the loop in writing.

Technical Screens

Assessment of technical skills including coding, system design, and infrastructure.

What to demonstrate

• Assessment of technical skills including coding, system design, and infrastructure
• Depth in System Design

How to prepare

• Answer aloud and timed: How do you approach designing high-performance architecture for data-intensive research workflows?
• Answer aloud and timed: What strategies do you use when planning disaster recovery and cloud-based failover for critical systems?

On-site/Virtual Panel

Interviews with multiple team members focusing on problem-solving and stakeholder alignment.

What to demonstrate

• Interviews with multiple team members focusing on problem-solving and stakeholder alignment
• Depth in System Design

How to prepare

• Answer aloud and timed: This category assesses your hands-on coding proficiency, database design capabilities, and mastery of modern software stacks.
• Answer aloud and timed: Can you write SQL Server queries against sample databases and explain your indexing strategy?

Decision/Offer

Final evaluation and discussion of the offer based on interview performance.

What to demonstrate

• Final evaluation and discussion of the offer based on interview performance
• Depth in System Design

How to prepare

• Answer aloud and timed: How would you add a new field to a form and persist it using an ORM or Entity Framework?
• Answer aloud and timed: What is your experience with full-stack development, and how do you structure relational database schemas in PostgreSQL or MySQL?

Where candidates lose points

Emphasize maintainability and documentation

In an academic and research setting, code outlives individual developers. Emphasize your commitment to writing clean code, thorough documentation, and adherence to software lifecycle standards.

Prepare for consultative questions

Expect interviewers to probe how you handle vague requirements or conflicting stakeholder needs. Practice structuring your answers around how you observe, clarify, and translate problems into technical specifications.

Connect your work to the mission

Show genuine enthusiasm for how your software solutions support education, research, or public health. Demonstrating an understanding of the broader institutional impact goes a long way.

Master your foundational tools

Do not get caught off guard by fundamental questions regarding relational databases, API design, or debugging strategies in your primary programming language.

Questions & practice

This category assesses your hands-on coding proficiency, database design capabilities, and mastery of modern s

Medium · Coding & Database Development

This category assesses your hands-on coding proficiency, database design capabilities, and mastery of modern software stacks.

Approach

1. Restate the input: its shape, its size, and what is guaranteed about it.
2. Name the brute-force solution and its complexity before improving on it.
3. Choose the data structure from the access pattern, not from familiarity.
4. State the target complexity and say which constraint rules the naive version out.

Follow-up

• How does this change if the input no longer fits in memory?
• What is the worst case, and how likely is it on real data?

How would you add a new field to a form and persist it using an ORM or Entity Framework?

Medium · Coding & Database Development

Approach

1. Restate the input: its shape, its size, and what is guaranteed about it.
2. Name the brute-force solution and its complexity before improving on it.
3. Choose the data structure from the access pattern, not from familiarity.
4. State the target complexity and say which constraint rules the naive version out.

Follow-up

• How does this change if the input no longer fits in memory?
• What is the worst case, and how likely is it on real data?

Archive a resource graph without breaking live references or recursing

Medium · graph traversal · topological order · tenant isolation

Resources reference other resources within a tenant; for the largest tenant the reference table holds up to 2,000,000 nodes and 8,000,000 edges. Archiving a resource must archive everything reachable from it that nothing outside the set still references, refuse when a live external referrer exists, and terminate when references form cycles, which they legitimately do. Produce the archive order and the refusal list, targeting O(V+E). Say what stops the traversal crossing a tenant boundary, and why recursion is the wrong control structure at this size.

Approach

1. Load the subgraph with the tenant predicate on both endpoints of the edge, not only on the side you started from. Scoping the left table alone is the classic cross-tenant leak: one mis-entered edge then pulls another tenant's resources into the traversal and, worse, into the archive.
2. Traverse iteratively with an explicit stack. A 2,000,000-node graph can hold a chain deep enough to exhaust a native stack in the low tens of thousands of frames, and that failure is a process crash rather than an error you can return.
3. Treat cycles as data rather than corruption: compute strongly connected components with Tarjan in O(V+E) using its own explicit stack, then condense. The condensation is a DAG, so a topological order over it gives the archive order, and every member of a component archives in one transaction because no order within a cycle is valid.
4. Decide refusals with reverse edges. A candidate is archivable only if every in-edge originates inside the candidate set, so build the transpose or count in-degrees restricted to the visited set, and emit each blocked resource with the id of the external referrer, which is the only part of the answer an operator can act on.

Follow-up

• The graph is read in one query and the archive writes a minute later. What can change in between, and how do you make the write safe?
• The candidate set is 400,000 resources. Is that one transaction, and if not, what does a half-finished archive look like to a reader?

Can you write SQL Server queries against sample databases and explain your indexing strategy?

Medium · Coding & Database Development

Approach

1. Name the grain you start from and join outward from it.
2. Check whether any join is one-to-many before aggregating, or the sums inflate.
3. Say which index the query would use, and what makes it unusable.
4. Handle the rows that do not match: that is usually the actual question.

Follow-up

• How does the query change if that join becomes one-to-many?
• What happens to this when the table is ten times larger?

Write the update path that detects a concurrent edit

Medium · optimistic concurrency · transactional outbox · audit history

resource carries version INT NOT NULL DEFAULT 1. resource_revision holds revision_id, resource_id, version, actor_user_id, change_kind, patch JSONB, request_id, created_at with UNIQUE (resource_id, version). outbox_event holds aggregate_type, aggregate_id, aggregate_version, event_type, payload, status. A PUT carries the version the client read. Write the exact statements for the single transaction that applies the edit, records the revision and enqueues 'resource.updated', and give the handler's branch on zero affected rows. Then say what PostgreSQL 16 does under READ COMMITTED when two of these updates hit one row at once.

Approach

1. One transaction, three writes, no network call inside it: UPDATE resource SET title = $3, version = version + 1, updated_at = now() WHERE resource_id = $1 AND tenant_id = $4 AND version = $2; then INSERT the resource_revision row at version $2 + 1; then INSERT the outbox_event row at the same aggregate_version. The event goes to a table rather than a broker because no transaction spans both.
2. Branch on the affected-row count before doing anything else. Zero has three causes — stale version, wrong tenant, row gone — so re-read once and map to 409 carrying the current version, or 404 for an id outside the caller's tenant, which also stops the endpoint confirming that another tenant's id exists.
3. State the engine behaviour instead of assuming it. Under READ COMMITTED the second UPDATE blocks on the row lock, and when the first commits PostgreSQL re-evaluates the WHERE clause against the newly committed row, so the version predicate now fails and the statement reports zero rows. Under REPEATABLE READ the identical collision raises SQLSTATE 40001 instead, so the handler must fold both shapes into one conflict response.
4. Keep UNIQUE (resource_id, version) even though the predicate already serialises writers. It is what makes a lost update unwritable if any other path ever reaches the revision table, and it converts a logic bug into 23505 rather than into a silently missing history row.

Follow-up

• A client sends the version it read ten minutes ago and the resource has moved three versions. What is in your 409 so it can resolve the conflict without a full re-fetch?
• Two editors, two disjoint fields, no overlap. Does your answer still refuse the second write, and should it?

This category evaluates your ability to conceptualize, scale, and structure complex applications and distribut

Medium · Technical System Design & Architecture

This category evaluates your ability to conceptualize, scale, and structure complex applications and distributed workflows from scratch.

Approach

1. Fix the scope first: who calls this, how often, and what they do when it fails.
2. Name the read and write paths separately; they rarely have the same bottleneck.
3. Choose a partition key and say what query it makes expensive.
4. State the consistency you need, and where you are willing to be stale.

Follow-up

• What breaks first when traffic grows ten times?
• How does this behave when that dependency is down for an hour?

How would you design a scalable emailing application from the ground up?

Medium · Technical System Design & Architecture

Approach

1. Fix the scope first: who calls this, how often, and what they do when it fails.
2. Name the read and write paths separately; they rarely have the same bottleneck.
3. Choose a partition key and say what query it makes expensive.
4. State the consistency you need, and where you are willing to be stale.

Follow-up

• What breaks first when traffic grows ten times?
• How does this behave when that dependency is down for an hour?

How do you approach designing high-performance architecture for data-intensive research workflows?

Medium · Technical System Design & Architecture

Approach

1. Fix the scope first: who calls this, how often, and what they do when it fails.
2. Name the read and write paths separately; they rarely have the same bottleneck.
3. Choose a partition key and say what query it makes expensive.
4. State the consistency you need, and where you are willing to be stale.

Follow-up

• What breaks first when traffic grows ten times?
• How does this behave when that dependency is down for an hour?

What strategies do you use when planning disaster recovery and cloud-based failover for critical systems?

Medium · Technical System Design & Architecture

Approach

1. Fix the scope first: who calls this, how often, and what they do when it fails.
2. Name the read and write paths separately; they rarely have the same bottleneck.
3. Choose a partition key and say what query it makes expensive.
4. State the consistency you need, and where you are willing to be stale.

Follow-up

• What breaks first when traffic grows ten times?
• How does this behave when that dependency is down for an hour?

This category focuses on specialized environments, performance tuning, and infrastructure management.

Medium · Domain & Systems Engineering

Approach

1. Clarify what is being asked and what a complete answer contains.
2. State your assumptions explicitly before working the problem.
3. Say what you would check first and why it is the highest-information step.
4. Work from the requirement backwards to the design.

Follow-up

• What assumption would you test first?
• How would you know your answer was wrong?

What is your familiarity with containerization tools and job schedulers like SLURM?

Medium · Domain & Systems Engineering

Approach

1. Clarify what is being asked and what a complete answer contains.
2. State your assumptions explicitly before working the problem.
3. Say what you would check first and why it is the highest-information step.
4. Work from the requirement backwards to the design.

Follow-up

• What assumption would you test first?
• How would you know your answer was wrong?

How do you ensure that your infrastructure solutions comply with rigorous security standards such as NIST guid

Medium · Domain & Systems Engineering

How do you ensure that your infrastructure solutions comply with rigorous security standards such as NIST guidelines?

Approach

1. Clarify what is being asked and what a complete answer contains.
2. State your assumptions explicitly before working the problem.
3. Say what you would check first and why it is the highest-information step.
4. Work from the requirement backwards to the design.

Follow-up

• What assumption would you test first?
• How would you know your answer was wrong?

How do you approach debugging and optimizing software stacks in Linux-based or high-performance computing envi

Medium · Domain & Systems Engineering

How do you approach debugging and optimizing software stacks in Linux-based or high-performance computing environments?

Approach

1. Establish what changed and when, before forming any theory.
2. Pick a bisection that eliminates candidates whichever way it turns out.
3. Check the instrumentation before believing the symptom.
4. Separate the trigger from the cause; the deploy is rarely the bug.

Follow-up

• What would you look at first, and what would it rule out?
• How would you tell a cause from a coincidence here?

Suggested practice checklist

Built from the rounds and topics The Johns Hopkins University candidates report.

Day 1 — Map the The Johns Hopkins University loop

• Write out the reported sequence: Recruiter/HR Touchpoint, Technical Screens, On-site/Virtual Panel, Decision/Offer.
• For each round, write one sentence on what it is judging, from the description above, and mark the one you are least ready for.

Deliverable: A one-page map of the 4 reported rounds, with the weakest marked.

Day 2 — Work System Design

• Spend the session on System Design, which The Johns Hopkins University candidates report being tested on.
• Write one worked example in System Design and time yourself on it.

Deliverable: One timed worked example in System Design.

Day 3 — Work Relational Database Architecture

• Spend the session on Relational Database Architecture, which The Johns Hopkins University candidates report being tested on.
• Write one worked example in Relational Database Architecture and time yourself on it.

Deliverable: One timed worked example in Relational Database Architecture.

Day 4 — Work Python

• Spend the session on Python, which The Johns Hopkins University candidates report being tested on.
• Write one worked example in Python and time yourself on it.

Deliverable: One timed worked example in Python.

Day 5 — Answer out loud: Technical System Design & Architecture

• Answer aloud, timed: This category evaluates your ability to conceptualize, scale, and structure complex applications and distributed workflows from scratch.
• Answer aloud, timed: How would you design a scalable emailing application from the ground up?

Deliverable: Spoken answers to 2 reported Technical System Design & Architecture question(s), under time.

Day 6 — Answer out loud: Coding & Database Development

• Answer aloud, timed: This category assesses your hands-on coding proficiency, database design capabilities, and mastery of modern software stacks.
• Answer aloud, timed: Can you write SQL Server queries against sample databases and explain your indexing strategy?

Deliverable: Spoken answers to 2 reported Coding & Database Development question(s), under time.

Day 7 — Answer out loud: Domain & Systems Engineering

• Answer aloud, timed: This category focuses on specialized environments, performance tuning, and infrastructure management.
• Answer aloud, timed: How do you approach debugging and optimizing software stacks in Linux-based or high-performance computing environments?

Deliverable: Spoken answers to 2 reported Domain & Systems Engineering question(s), under time.

Behavioural preparation

Behavioural rounds judge the decision you made and what it cost.

What is your experience with full-stack development, and how do you structure relational database schemas in P

Medium · Coding & Database Development

What is your experience with full-stack development, and how do you structure relational database schemas in PostgreSQL or MySQL?

Approach

1. Pick a story where you made the decision, not one where you watched it.
2. State the situation in two sentences and spend the rest on the reasoning.
3. Give the blast radius: what could have broken, and what you measured.
4. Name the disagreement and how you resolved it with evidence.

Follow-up

• What would you do differently if you ran that again?
• How did you know your change caused the improvement?

This category explores your communication style, stakeholder management, and resilience when handling workplac

Medium · Behavioral & Workplace Problem-Solving

This category explores your communication style, stakeholder management, and resilience when handling workplace challenges.

Approach

1. Pick a story where you made the decision, not one where you watched it.
2. State the situation in two sentences and spend the rest on the reasoning.
3. Give the blast radius: what could have broken, and what you measured.
4. Name the disagreement and how you resolved it with evidence.

Follow-up

• What would you do differently if you ran that again?
• How did you know your change caused the improvement?

How do you handle competing priorities and difficult problems when collaborating with non-technical stakeholde

Medium · Behavioral & Workplace Problem-Solving

How do you handle competing priorities and difficult problems when collaborating with non-technical stakeholders?

Approach

1. Pick a story where you made the decision, not one where you watched it.
2. State the situation in two sentences and spend the rest on the reasoning.
3. Give the blast radius: what could have broken, and what you measured.
4. Name the disagreement and how you resolved it with evidence.

Follow-up

• What would you do differently if you ran that again?
• How did you know your change caused the improvement?

What are your greatest professional strengths and weaknesses, and how do you apply them to your daily work?

Medium · Behavioral & Workplace Problem-Solving

Approach

1. Pick a story where you made the decision, not one where you watched it.
2. State the situation in two sentences and spend the rest on the reasoning.
3. Give the blast radius: what could have broken, and what you measured.
4. Name the disagreement and how you resolved it with evidence.

Follow-up

• What would you do differently if you ran that again?
• How did you know your change caused the improvement?

Can you describe a time when you had to translate vague business requirements into clear technical specificati

Medium · Behavioral & Workplace Problem-Solving

Can you describe a time when you had to translate vague business requirements into clear technical specifications?

Approach

1. Pick a story where you made the decision, not one where you watched it.
2. State the situation in two sentences and spend the rest on the reasoning.
3. Give the blast radius: what could have broken, and what you measured.
4. Name the disagreement and how you resolved it with evidence.

Follow-up

• What would you do differently if you ran that again?
• How did you know your change caused the improvement?