BankBazaar Associate Analyst Interview Questions and Answers

Q1. Tell me about you
Ans. 
I am a dedicated and experienced professional with a strong background in leadership and team management.
• Over 5 years of experience in retail management

• Proven track record of increasing sales and improving customer satisfaction

• Strong communication and problem-solving skills

• Ability to motivate and lead a team towards achieving goals
Answered by AI
Add your answer

Aptitude test and reasoning test very simple

Q1. What is NSE ans BSE
Ans. 
NSE and BSE are the two main stock exchanges in India, where companies list their shares for trading.
• NSE stands for National Stock Exchange and BSE stands for Bombay Stock Exchange

• Both NSE and BSE facilitate trading of stocks, derivatives, and other financial instruments

• Companies list their shares on NSE and BSE to raise capital from investors

• NSE is headquartered in Mumbai while BSE is also located in Mumbai
Answered by AI
Add your answer
Q2. What is stock market,all technalities if stock market, read basic things about stocks market
Add your answer

Q1. Questions asked mostly related to SQL only.
Add your answer

Q1. Mix of questions are expected depending on interviewer i guess, -> few apititude questions on probability, PnC, 6 * 6 Grid Square questions -> Business case study questions on [how will you evaulate few m...read more
Add your answer

Q1. This is probably the elimination round. Majorly focus on 2 portions 1. project discussions mentioned in your resume [cross questioning will be here alot] 2. Case study dicussion
Add your answer

Q1. Joins, get a thorough understanding.
Add your answer
Q2. Window Functions
Add your answer

Puzzles are a large component for entry-level.

RCA as well as business case studies are asked

Q1. Difference between rank & dense rank
Ans. 
Rank assigns unique numbers to each row based on the order specified, while dense rank assigns consecutive numbers without gaps.
• Rank leaves gaps in the ranking sequence if there are ties, while dense rank does not

• Rank function is used to assign a unique rank to each row, while dense rank function is used to assign a unique rank to each distinct row

• For example, if there are two rows with the same value and rank 1, the n...read more
Answered by AI
Add your answer
Q2. Given two tables Tell how many values would be there for left right inner outer join
Ans. 
The number of values in different types of joins depends on the relationship between the tables.
• In a left join, all values from the left table are included along with matching values from the right table. The number of values will be equal to the number of rows in the left table.

• In a right join, all values from the right table are included along with matching values from the left table. The number of values will be equ...read more
Answered by AI
Add your answer
Q3. Find the newest customer id for every product
Ans. 
Use SQL query to find the newest customer id for every product
• Use GROUP BY clause to group by product

• Use MAX() function to find the newest customer id for each product

• Join the tables if necessary
Answered by AI
Add your answer