cswork / libraryOpen practice workspace

Interview guides · The Johns Hopkins University Applied Physics Laboratory

The Johns Hopkins University Applied Physics Laboratory Software Engineer Interview Guide

What The Johns Hopkins University Applied Physics Laboratory asks Software Engineer candidates, from reported rounds and questions.

The 60-second brief

A Software Engineer at The Johns Hopkins University Applied Physics Laboratory (APL) operates at the intersection of cutting-edge scientific research and robust systems engineering. Unlike traditional commercial tech roles focused solely on consumer-facing applications, engineers at APL develop software that directly impacts national security, space exploration, and healthcare informatics. As a University Affiliated Research Center (UARC), APL tasks its engineering teams with solving complex, high-consequence challenges that require highly secure, resilient, and performant software architectures. In this role, you will contribute to critical defense and space systems, build advanced decision support tools, and design data-driven solutions that require high explainability.

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

Focus areas

  • Programming Language: Python
  • SQL Server
  • System Design

The The Johns Hopkins University Applied Physics Laboratory interview process

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

HR Phone Screen

Initial call to discuss background, career goals, and eligibility for U.S. government security clearance.

What to demonstrate

  • Initial call to discuss background, career goals, and eligibility for U.S
  • Government security clearance

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 Phone Screens

One or more technical discussions with a hiring manager or tech lead covering resume details and foundational coding questions.

What to demonstrate

  • One or more technical discussions with a hiring manager or tech lead covering resume details and foundational coding questions
  • Depth in Programming Language: Python

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.

Onsite Interview

Comprehensive interview stage with a panel of team members, managers, and technical directors, including practical tests or presentations.

What to demonstrate

  • Comprehensive interview stage with a panel of team members, managers, and technical directors
  • Including practical tests or presentations

How to prepare

  • Answer aloud and timed: Write three SQL queries against a sample database (such as AdventureWorks) to extract complex relational data using joins and aggregations.
  • Answer aloud and timed: How do you add a new input field to an existing form in an ASP.NET MVC application and persist that data to a SQL Server database using Entity Framework?

Where candidates lose points

Highlight Your Mission-Oriented Mindset

APL is dedicated to solving critical national challenges. Expressing a genuine interest in public service, national security, or scientific advancement will resonate strongly with your interviewers.

Be Ready for Detailed Resume Deep-Dives

Interviewers will ask detailed questions about your past projects. Be prepared to explain the technical choices you made, the obstacles you overcame, and the ultimate impact of your work.

Brush Up on Database and System Fundamentals

Even if you are applying for a generalist software role, expect questions on relational databases, SQL queries, and basic system design. Reviewing these fundamentals beforehand will prevent unexpected surprises.

Questions & practice

On a whiteboard, explain the fundamental concepts of digital signal processing and how you would implement a b

Medium · Domain-Specific & Analytical Problem Sol

On a whiteboard, explain the fundamental concepts of digital signal processing and how you would implement a basic filtering algorithm in software.

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 structure a data pipeline to preprocess unstructured text data for a Natural Language Processing

Medium · Domain-Specific & Analytical Problem Sol

How would you structure a data pipeline to preprocess unstructured text data for a Natural Language Processing (NLP) model?

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?

Describe how you would evaluate and validate a machine learning model designed for public health surveillance.

Medium · Domain-Specific & Analytical Problem Sol

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?

Write three SQL queries against a sample database (such as AdventureWorks) to extract complex relational data

Medium · Technical & Coding Fundamentals

Write three SQL queries against a sample database (such as AdventureWorks) to extract complex relational data using joins and aggregations.

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?

How do you add a new input field to an existing form in an ASP.NET MVC application and persist that data to a

Medium · Technical & Coding Fundamentals

How do you add a new input field to an existing form in an ASP.NET MVC application and persist that data to a SQL Server database using Entity Framework?

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?

Explain how you would optimize a slow-running database query that is causing latency in a web application.

Medium · Technical & Coding Fundamentals

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?

Why are you interested in leaving your current position to join The Johns Hopkins University Applied Physics L

Medium · Behavioral & Professional Fit

Why are you interested in leaving your current position to join The Johns Hopkins University Applied Physics Laboratory?

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?

How would you design a high-throughput, secure emailing and notification application?

Medium · 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?

Describe the architecture of a real-time decision support system that processes heterogeneous data feeds.

Medium · 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 design a system to ensure data explainability and auditability for critical decision-making process

Medium · System Design & Architecture

How do you design a system to ensure data explainability and auditability for critical decision-making processes?

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 architectural patterns would you use to transition a legacy desktop analytical tool into a scalable, clou

Medium · System Design & Architecture

What architectural patterns would you use to transition a legacy desktop analytical tool into a scalable, cloud-native application?

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?

Walk through the process of implementing a RESTful API endpoint using a language of your choice (e.g., Python,

Medium · Technical & Coding Fundamentals

Walk through the process of implementing a RESTful API endpoint using a language of your choice (e.g., Python, Java, or JavaScript).

Approach

  1. Say who the caller is and what they do when the call fails halfway.
  2. Define the identity of a request so a retry cannot double-apply it.
  3. Separate accepted, pending, failed and confirmed; they are different facts.
  4. Design the error taxonomy before the success shape; callers branch on it.

Follow-up

  • What happens if the caller retries after a timeout?
  • How does a client discover it is on an old version of this contract?

Every query on one table stalls for forty seconds mid-deploy

Medium · lock contention · ddl · migrations

During a release on PostgreSQL, every query touching resource times out for about 40 seconds and then recovers with no intervention. The release ran one migration, ALTER TABLE resource ADD COLUMN archived_reason TEXT, and the migration log shows it completing in 6 ms. Unrelated tables showed no change in error rate. Explain how a 6 ms statement caused a 40-second stall, give the ordered checks you would run on a live system to confirm it, and give the migration procedure that prevents a repeat.

Approach

  1. Separate the statement's duration from the lock's duration. ADD COLUMN with no default is a catalogue-only change and genuinely runs in milliseconds, but it requires ACCESS EXCLUSIVE, and it cannot acquire that until every transaction already touching the table has finished.
  2. Account for the queueing, which is the part that surprises people. A lock request that is waiting blocks later requests for conflicting modes behind it rather than letting them overtake, so one long-open transaction holds the DDL and the DDL holds all the traffic. The stall length is set by the longest open transaction, not by the size of the change.
  3. Confirm on a live system in this order: pg_stat_activity for that table ordered by xact_start, looking for the oldest transaction and specifically for state = idle in transaction; then pg_locks where granted = false to find the waiter; then join them on pid to name blocker and blocked. pg_blocking_pids() does that join for you and is the fastest single call.
  4. Prevent rather than merely time it better. Set lock_timeout to a second or two on the migration session so the DDL abandons the queue after a bounded wait and is retried, instead of holding it for as long as the oldest transaction lives. Be exact about what that buys: queries arriving during the wait still queue behind the pending ACCESS EXCLUSIVE request, so each attempt costs them up to one lock_timeout of added latency. The outage goes from 40 seconds to about one second per attempt, not to zero. Also run migrations away from deploy-time peaks, and put a statement timeout and an idle-in-transaction timeout on the analytics role that opens the long transactions.

Follow-up

  • The same release also wants NOT NULL on that column. What is the sequence that gets there without a long lock?
  • Your lock_timeout retry fails ten times in a row because the analytics transaction is always open. What do you change?

Suggested practice checklist

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

Day 1 — Map the The Johns Hopkins University Applied Physics Laboratory loop

  • Write out the reported sequence: HR Phone Screen, Technical Phone Screens, Onsite Interview.
  • 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 3 reported rounds, with the weakest marked.

Day 2 — Work Programming Language: Python

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

Deliverable: One timed worked example in Programming Language: Python.

Day 3 — Work SQL Server

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

Deliverable: One timed worked example in SQL Server.

Day 4 — Work System Design

  • Spend the session on System Design, which The Johns Hopkins University Applied Physics Laboratory 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 5 — Answer out loud: System Design & Architecture

  • Answer aloud, timed: How would you design a high-throughput, secure emailing and notification application?
  • Answer aloud, timed: Describe the architecture of a real-time decision support system that processes heterogeneous data feeds.

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

Day 6 — Answer out loud: Technical & Coding Fundamentals

  • Answer aloud, timed: Write three SQL queries against a sample database (such as AdventureWorks) to extract complex relational data using joins and aggregations.
  • Answer aloud, timed: How do you add a new input field to an existing form in an ASP.NET MVC application and persist that data to a SQL Server database using Entity Framework?

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

Day 7 — Answer out loud: Domain-Specific & Analytical Problem Solving

  • Answer aloud, timed: On a whiteboard, explain the fundamental concepts of digital signal processing and how you would implement a basic filtering algorithm in software.
  • Answer aloud, timed: How would you structure a data pipeline to preprocess unstructured text data for a Natural Language Processing (NLP) model?

Deliverable: Spoken answers to 2 reported Domain-Specific & Analytical Problem Solving question(s), under time.

Behavioural preparation

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

Describe a time when you had to resolve a technical disagreement with a teammate or project lead. How did you

Medium · Behavioral & Professional Fit

Describe a time when you had to resolve a technical disagreement with a teammate or project lead. How did you handle it?

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 is your greatest strength, and what is your greatest weakness as a software developer?

Medium · Behavioral & Professional Fit

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 manage your time and prioritize tasks when working on multiple projects with competing deadlines?

Medium · Behavioral & Professional Fit

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?