
State Street General Intern Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 163 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at State Street.
Graduate Intern
So, first thing we had was this online assessment, it had like two coding questions and then some multiple choice stuff. Then, a few days later, they had this PPT thing where they told us who passed the online assessment, and after that, we went straight into the technical round. The tech round was mostly about SQL queries, like joins and subqueries. The guy also hit me with some basic DSA questions, like what's the deal between an array and an ArrayList? Oh, and he threw in a puzzle to see if I could think logically. He also asked me about the projects I've worked on. That whole technical interview was about 30 minutes. After that, I got through to the HR interview, and she just asked the usual HR questions.
- They asked about SQL queries, focusing on joins and subqueries.
- They also gave me a logical puzzle to gauge my thinking skills.
Technology Intern
It was an oncampus opportunity. I had an OA which included MCQs and one DSA problem. Then, shortlisted candidates were invited for a Technical Round. This round involved a deep dive into my resume projects, and I was asked one DSA (Easy) and one SQL question. The SQL question involved creating a database with a few tables and writing queries to retrieve data. After that, the final round was an HR round with typical HR questions.
- How would you fetch values from two tables given specific conditions?
- Could you solve a LeetCode easy problem, specifically one involving string manipulation?
Intern
HR reached out to me through a phone call and asked some basic screening questions like my interest in the role and availability. After about a week, I was invited for an interview. It was a relaxed, conversational interview with no technical questions. They were more interested in getting to know me, my schoolwork, and my hobbies. I had two back-to-back interviews with senior managers. Make sure to prepare many questions about State Street and the field/position.
- Do you have any experience using Excel?
State Street General Intern Interview Questions
Quoted word for word from State Street interview reports.
“And what is the integer portion of the square root of 2000?”
Read reports →“How does the expected value change if you have the option to roll once, twice, thrice, or n-times?”
Read reports →“Build a list-based shop page for a website selling coffee, tea, and milk, including images and descriptions.”
Read reports →“Given the employee and department tables, can you answer 5-6 questions and provide the corresponding SQL code?”
Read reports →“Could you please solve some DSA coding questions on pen and paper, and then walk me through the dry run?”
Read report →“Tell me about a time a teammate was having a hard time and how you assisted them.”
Read report →“Tell me about a time in class when you didn't perform at your best and explain why.”
Read report →“On a scale of 1 to 5, how would you assess your Excel proficiency?”
Read report →“Could you confirm your availability given that you're a student, as we've had past issues with interns regarding scheduling?”
Read report →Formats, difficulty and experience
Across all 163 State Street interview reports.