State Street Business Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 45 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at State Street.
State Street
Business Analyst
Entry Average Positive experience No offer 1 round
Interview process
Technical screen
Interview formats
Technical Coding
It was a technical interview where they asked about SQL, ETL, and python. They also asked about my resume experiences and object-oriented design principles like inheritance. It was pretty casual and they didn't focus on behavioral questions.
Confirmed questions1 question
- Can you instantiate an object from an abstract class?
State Street
Business Analyst
Senior Average Negative experience No offer 1 round
Interview process
Recruiter call
Interview formats
Behavioral
Applied for the role and got a call from a recruiter, followed by an email. I replied with my availability and asked for hers. She responded two days later with another call while I was asleep and I again asked to schedule a time and gave my availability. She ignored this and kept calling me all week while I was asleep. I explicitly asked to schedule a time because of the time difference, but she ignored this. I suggested a specific time and date, and she ignored that too. The recruiter was in India and wouldn't cooperate in setting up a time to interview me, despite me being an international applicant for a role in Germany.
Confirmed questions0 questions
No confirmed questions were included in this interview report.
State Street
Business Analyst
Mid Easy Positive experience Accept offer 2 rounds
Interview process
Recruiter call Group Offer
Interview formats
Behavioral Group
I was interviewed for another position in the same company. First, I had a 1:1 interview with my new manager. Then, I got a chance for a group interview via video with my manager's manager (in Sydney) and my matrix manager (in Boston). On the same day, they also interviewed another candidate for the same position. I got the offer finally. I heard from my manager that my English skills helped me win the offer compared with my competitor. My advice is, if you want to apply for a position that requires working with native English speakers, and English is not your mother tongue, good English skills will help you get the position.
Confirmed questions1 question
- Could you describe your responsibilities and accomplishments in your prior role?
State Street Business Analyst Interview Questions
Quoted word for word from State Street interview reports.
“What's your best guess for the total number of kindergarten teachers in the United States?”
Read reports →“Can you instantiate an object from an abstract class?”
Read reports →“Could you explain the difference between char and varchar data types?”
Read reports →“When given two database tables, like a users table and an addresses table, how would you construct a SQL query to determine which addresses are associated with a particular user?”
Read reports →“What are the differences between joins and subqueries, and what is the NVL function?”
Read report →“Can you explain the difference between a unique key and a primary key, and also the difference between DELETE and TRUNCATE statements?”
Read report →“Could you write a SQL query that uses CTEs, group-by, and window functions?”
Read report →“Can you explain what a process diagram is and the steps you take to create one?”
Read report →“Do you have knowledge of basic Unix commands and process-related commands?”
Read report →Formats, difficulty and experience
Across all 45 State Street interview reports.