Upload Button Icon Add office photos

Morgan Stanley

Compare button icon Compare button icon Compare

Filter interviews by

Morgan Stanley Senior Business Analyst Interview Questions and Answers

Updated 16 Apr 2024

Morgan Stanley Senior Business Analyst Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Mar 2024.

Round 1 - Technical 

(3 Questions)

  • Q1. Design an order management system
  • Ans. 

    An order management system to streamline the process of receiving, tracking, and fulfilling customer orders.

    • Define user roles and permissions for accessing and managing orders

    • Create a user-friendly interface for entering and tracking orders

    • Integrate with inventory management system to ensure accurate stock levels

    • Automate order processing and notifications to improve efficiency

    • Generate reports on order status, sales tre

  • Answered by AI
  • Q2. Data points involved in the order management system
  • Ans. 

    Data points in an order management system include customer information, order details, payment information, shipping details, and order status.

    • Customer information (name, address, contact details)

    • Order details (products, quantities, prices)

    • Payment information (payment method, transaction ID)

    • Shipping details (shipping address, tracking number)

    • Order status (pending, processing, shipped, delivered)

  • Answered by AI
  • Q3. Trade life cycle

Skills evaluated in this interview

Interview questions from similar companies

I was interviewed before May 2016.

Interview Preparation Tips

Round: Written Test
Experience: I attended interview at hyderabad location for java Sr.Software Engineer.
1Q) Find out given string palindrome or not.
Ex: madam
2Q) Find first and last index searching number in a array.
Ex: [1,2,3,3,3,3,4,5]
Output : 2,5
3Q) Arrange Strings in alphabetical order.

Tips: Prepare numeric and string related algorithms

Interview Questionnaire 

1 Question

  • Q1. Probability based optimization problem
  • Ans. 

    Probability based optimization problem

    • Probability based optimization problems involve finding the optimal solution considering uncertain outcomes

    • These problems often require the use of mathematical models and statistical analysis

    • Examples include portfolio optimization, resource allocation, and production planning

    • Solving such problems involves determining the probabilities of different outcomes and optimizing the decisi

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Basic CAT level questions of Data Sufficiency
Tips: CAT preparation would help. Strong basics in High school mathematics needed, along with some smart thinking at times.
Duration: 30 minutes
Total Questions: 50

Round: Case Study Interview
Experience: 15 minutes given for an almost impossible to get an answer problem. Later asked to explain your solution. The approach matters much much more than the final answer.
Tips: Be cool, think basics. Don't forget elementary things that units conversion, unitary methods, probability distributions etc. If while explaining, you realize you actually made a mistake while attempting the problem, acknowledge it and explain the correct approach from there on, rather than trying to disguise your mistake.

Round: Technical Interview
Experience: Things like, why Citi, prior experience with data analytics, examples from real life for mathematical concepts highlighted in Resume. Some general awareness related questions asked!
Tips: Be thorough through the resume. Act smart and reply what they want to hear. It's okay to ask them for a few minutes in case you want to think before answering something rather than mumbling what comes to your mind first!

Round: HR Interview
Experience: Again things like why Citi, why analytics. This round seemed more out of formality than for selection.

General Tips: Keep calm, and take the interview as a conversation - unless it's a stress interview. Always take your time and think before you answer anything rather than mumbling out the first thing that comes to your mind.
Skills: Probability, Statistics, Analytical skills
College Name: IIT MADRAS
Motivation: Needed a break into the Finance sector!

I applied via Campus Placement and was interviewed in Aug 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SQL queries you
  • Ans. 

    I am proficient in writing complex SQL queries for data retrieval and manipulation.

    • I have experience in using various SQL functions like JOIN, GROUP BY, HAVING, etc.

    • I can write subqueries and nested queries to fetch data from multiple tables.

    • I am familiar with using SQL for data analysis and reporting purposes.

    • I have worked with different database management systems like MySQL, Oracle, and SQL Server.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I had a good experience in the interview

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Excel

I applied via Referral and was interviewed before Jul 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Be clear with your basics
Round 2 - Technical 

(1 Question)

  • Q1. Maven basics, Design Patterns

Interview Preparation Tips

Interview preparation tips for other job seekers - Be clear with your basics and be confident

Interview Questionnaire 

1 Question

  • Q1. It was mostly about the instrument reference data and typical business analyst question about change management, BRD, Agile and technology we use.

Interview Questionnaire 

2 Questions

  • Q1. Questions on Kubernetes, AWS, Spring batch, Java threads and Apace Kafka
  • Q2. Questions on Executor service and Reentrant Lock in Java

I applied via Approached by Company and was interviewed before Mar 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL Questions, Case statements, Difference between Tree map and heat map, visualization charts, primary key foreign key
Round 2 - One-on-one 

(1 Question)

  • Q1. SSRS reporting, sql query test, group by, drill down reports

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident, If you don't know anything show enthusiasm that you are willing to learn

I applied via Naukri.com and was interviewed before Aug 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical and behavioral questions only. I went through Manpower. It was third party payroll.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare as per job description.

Morgan Stanley Interview FAQs

How many rounds are there in Morgan Stanley Senior Business Analyst interview?
Morgan Stanley interview process usually has 1 rounds. The most common rounds in the Morgan Stanley interview process are Technical.
How to prepare for Morgan Stanley Senior Business Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Morgan Stanley. The most common topics and skills that interviewers at Morgan Stanley expect are Asset Management, Business Analysis, Business Solutions, Data Analysis and Financial Services.
What are the top questions asked in Morgan Stanley Senior Business Analyst interview?

Some of the top questions asked at the Morgan Stanley Senior Business Analyst interview -

  1. Data points involved in the order management sys...read more
  2. Design an order management sys...read more
  3. Trade life cy...read more

Tell us how to improve this page.

Morgan Stanley Senior Business Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Morgan Stanley Senior Business Analyst Salary
based on 18 salaries
₹9 L/yr - ₹30.5 L/yr
48% more than the average Senior Business Analyst Salary in India
View more details

Morgan Stanley Senior Business Analyst Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

4.0

Salary

5.0

Job security

5.0

Company culture

4.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Associate
3.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Manager
2.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
1.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
1.6k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Vice President
1.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Morgan Stanley with

JPMorgan Chase & Co.

4.0
Compare

Goldman Sachs

3.5
Compare

TCS

3.7
Compare

Deloitte

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview