National Stock Exchange of India Business Analyst Interview Questions and Answers

Q1. About DB schema design
Add your answer
Q2. Design patterns you have used
Ans. 
I have used design patterns such as Singleton, Factory, and Observer in my projects.
• Singleton pattern ensures a class has only one instance and provides a global point of access to it.

• Factory pattern creates objects without specifying the exact class of object that will be created.

• Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and
Answered by AI
Add your answer

Q1. Questions on probability and puzzles
Add your answer

Q1. Risk & Surveillance related question.
Add your answer
Q2. Rms process related questions.
Add your answer

I had a very bad interview experience. The interviewer didn't start with any introduction and immediately jumped into asking case study. After giving a case, he would leave for a few minutes, which made it seem like he was not interested in the process.

Questions asked:
Q1: You are an Analyst at UBER. The gross cab cancellation rate daily is 5% whereas on a particular day, it goes up to 10%. What could be the factors affecting the same?
To analyze the same list down the tables required in the database along with all the columns and write the query using the same table name & columns to find the required metrics.

Q2: Assume you work for YouTube Music and the CEO wants you to create a Business Health Dashboard. List down all the metrics the CEO will be interested in looking at.

Q1. Current CTC, Preferred location
Ans. 
Current CTC and preferred location are confidential information.
• Current CTC and preferred location are personal and confidential details.

• It is common practice not to disclose current CTC during interviews.

• Preferred location may vary based on individual circumstances and preferences.
Answered by AI
Add your answer

Q1. About yourself, projects worked, sql questions, Python questions
Add your answer

A problem on portfolio optimization was given.

Q1. What is p-value and A/B testing
Ans. 
P-value is a statistical measure that helps determine the significance of results in hypothesis testing. A/B testing is a method of comparing two versions of a webpage or app to see which one performs better.
• P-value is the probability of obtaining a result as extreme or more extreme than the observed result, assuming the null hypothesis is true.

• A/B testing involves randomly dividing a sample into two groups and exposin...read more
Answered by AI
Add your answer
Q2. ARMA, ARIMA and stationarity in time series.
Ans. 
ARMA and ARIMA are models used for time series analysis. Stationarity refers to the statistical properties of a time series remaining constant over time.
• ARMA stands for Autoregressive Moving Average model and is used to model stationary time series data.

• ARIMA stands for Autoregressive Integrated Moving Average model and is used to model non-stationary time series data.

• Stationarity is an important concept in time series...read more
Answered by AI
Add your answer

Q1. Managerial round. Scenario based questions like how to find rca for slowness in web application.
Add your answer