Morgan Stanley · OA → Phone screen → Onsite
In processMorgan Stanley Intern Tech Rounds: 5 Experiences (Part 2 of 5)
Morgan Stanley technology intern interviews, 2024: debugging and aptitude OAs, then technical rounds on SQL, OS, Java and classic coding problems.
At a glance
- Process: OA (debugging, aptitude, three coding tasks) → technical interview of 45 minutes to over an hour → HR, hiring manager or technical+HR round (entries 06–09).
- Asked recently: SQL queries in 3 of 4 current reports (07, 08, 06 joins); Merge Intervals, level-order traversal, reverse a number, Two Sum and a ticket double-booking design.
- Difficulty: OA coding medium to hard; one candidate solved all three tasks (07).
- Practise first: Second and Third Lowest Order Values, Merge Intervals and Target-Sum Subarray.
Coverage: 4 technology intern reports from February to March 2024 plus one undated six-month spring internship (India where stated), and one 2023 recorded-interview report in History.
Morgan Stanley reports by hiring path
- Internship Part 1: 2024–2026 internship reports, with the current question tables.
- Internship Part 2 (current): late 2023 to 2024 internship reports.
- Internship Part 3: 2022–2023 internship reports (History).
- Internship Part 4: 2021–2022 internship reports (History).
- Internship Part 5: 2016, 2020–2021 and undated internship reports.
- New grad technology analyst: 2014 and 2018 new grad reports (History).
- Apprenticeship and level not reported: 2026 technology apprenticeship and unclassified reports.
What came up
The technical rounds mixed a little coding with a lot of fundamentals: SQL, OS memory, Java internals and concurrency. HR rounds probed projects and Morgan Stanley's values.
| Topic | Reports | Last seen |
|---|---|---|
| CS fundamentals (OS, DB, Java, concurrency) | 4 of 4 | Mar 2024 |
| SQL queries or joins | 3 of 4 | Mar 2024 |
| Live coding | 3 of 4 | Feb 2024 |
| Project and values questions | 3 of 4 | Feb 2024 |
Questions we found
Algorithms / Data Structures
| Question | Reports | Last seen |
|---|---|---|
| Merge Intervals | 1 | Feb 2024 |
| Binary-tree level-order traversal | 1 | Feb 2024 |
| Reverse a number | 1 | Feb 2024 |
| Second- and third-lowest order values (SQL) | 1 | Feb 2024 |
| Binary-tree preorder, iterative and recursive | 1 | — |
| Two Sum | 1 | — |
| Subarray with a given sum | 1 | — |
System Design
| Question | Reports | Last seen |
|---|---|---|
| Stop two people booking the same ticket at once | 1 | — |
CS and behavioral questions
| Question | Reports | Last seen |
|---|---|---|
| Blocking vs nonblocking I/O; concurrency vs parallelism; B+ tree and composite indexes; JVM GC | 1 | Mar 2024 |
| Disagreement with a classmate | 1 | Mar 2024 |
| An infinitely recursive C function with a local array and 2 MB of memory: what fails? | 1 | Feb 2024 |
| Late delivery versus shipping with bugs before a client deadline | 1 | Feb 2024 |
| Why MongoDB over SQL in your project; an ethical compromise | 1 | Feb 2024 |
4 detailed candidate timelines
06: a first round with a broad systems discussion
Interview date: March 27, 2024 · Role: Technology intern · Result: Passed the first round
- Why Morgan Stanley, and how technology can be used in finance.
- Nonblocking versus blocking I/O, concurrency versus parallelism, SQL joins, B+ tree and composite indexes, memory leaks, processes versus threads, a sorting algorithm of choice, JVM garbage collection and encryption algorithms.
- How to handle a disagreement with a classmate. A second interview was scheduled.
07: SQL and a recursive crash scenario
Interview date: February 15–22, 2024 · Role: Summer Technology Analyst · Result: Positive shortlisting email about three weeks later
- OA (invited February 12): 20 minutes of debugging, ten aptitude questions in 20 minutes, three coding tasks all solved, including Merge Intervals and level-order traversal.
- Technical (over an hour): nine or ten SQL queries; an infinitely recursive C function with a local array of ten integers and 2 MB of memory: what error follows; call by value versus by reference; an unnamed medium DSA task in pseudocode.
- HR (about 30 minutes): why MongoDB rather than SQL, career plans, the firm's business and values, a Python or C++ team, an ethical compromise, an interesting project incident, and a client deadline a month out with too many bugs.
08: number reversal, SQL and a long project talk
Interview date: mid-February 2024 · Role: Two-month Summer Technology Analyst Intern · Location: India · Applied: referral · Result: Internship obtained
- OA: nine debugging questions, 20 aptitude questions, three coding problems (brute force, hashing, a multimap task).
- Technical (about 1.2 hours, two interviewers): reverse a number; two supplied tables for joins, sorting, grouping and normalization, including the second- and third-lowest order values with several approaches; compilers versus interpreters, Java bytecode and portability, OOP pillars, virtual memory, paging and parallel processing.
- Technical + HR (about an hour): projects with demos, technology choices, education, community work, hackathons and situations.
09: a spring internship with three coding tasks and a booking race
Interview date: not given · Role: Six-month Spring Analyst Intern · Location: India · Result: Selected
- Two-hour test: 15 aptitude questions, five debugging tasks, three medium-to-hard coding tasks. A recruiter later checked whether a six-month internship was allowed.
- Technical (45–60 minutes): ACID, paging, thrashing, normalization, virtual functions; preorder traversal, iterative and recursive, Two Sum, and a subarray with a given sum.
- Hiring manager (25–30 minutes): leading a group, the firm's values and living them, why Morgan Stanley; how to prevent two people booking the same ticket; hackathons and a past internship. Selected after five to six weeks.
Common questions
What SQL does Morgan Stanley ask interns?
Joins, grouping and normalization on supplied tables, such as the second- and third-lowest order values (08), and a long run of queries (07).
How long is the Morgan Stanley intern OA?
About two hours in entry 09; entry 07 gave 20 minutes of debugging and 20 of aptitude before the coding tasks.
History (before 2024)
H10: three recorded questions
Interview date: by July 2023 · Role: Technology Summer Analyst applicant · Result: Not stated
- Recorded answers: introduce yourself; a favorite project and why; working on a project in a team.
Keep practicing
- From these reports: Merge Intervals and level order (07); reverse a number and order values SQL (08); preorder, Two Sum, target-sum subarray and ticket booking (09).
- Morgan Stanley question banks: algorithms, system design (sign-in needed).
- Everything Morgan Stanley in one place: the Morgan Stanley interview page.
- More firsthand reports: the Experience feed.
Morgan Stanley reports by hiring path
- Internship Part 1
- Internship Part 2 (current)
- Internship Part 3
- Internship Part 4
- Internship Part 5
- New grad technology analyst
- Apprenticeship and level not reported
Sources: Anywhere useful interview info can be found.
Comments
0No comments yet — be the first to share what you know.