Xoriant Lead Business Analyst Interview Questions and Answers

Q1. Diff between ipo fpo
Ans. 
IPO stands for Initial Public Offering, where a company offers shares to the public for the first time. FPO stands for Follow-on Public Offering, where a company already listed on the stock exchange offers additional shares to the public.
• IPO is the first time a company offers its shares to the public, while FPO is when a company already listed on the stock exchange offers additional shares.

• IPO is used by companies to r...read more
Answered by AI
Add your answer
Q2. Diff between diff types of banking
Ans. 
Different types of banking include retail banking, commercial banking, investment banking, and central banking.
• Retail banking focuses on individual customers and their personal financial needs, such as savings accounts and loans.

• Commercial banking serves businesses and provides services like business loans and checking accounts.

• Investment banking deals with helping companies raise capital through issuing stocks and bon...read more
Answered by AI
Add your answer

Q1. Do you understand capital market
Ans. 
Yes, I understand capital markets as the platforms where buyers and sellers trade financial securities.
• Capital markets are where companies and governments raise long-term funds through debt or equity securities.

• They include stock markets, bond markets, and other financial instruments.

• Investors buy securities in the hope of earning a return on their investment.

• Understanding market trends, regulations, and economic facto
Answered by AI
Add your answer
Q2. And the terms (ref below)
Add your answer

Q1. SQL and business Analyst questions
Add your answer

Q1. Situation based questions SQL
Add your answer

Q1. Screening round - telephonic interview
Add your answer

Q1. Technical round - Domain specific questions
Add your answer

Q1. Project Overview and Previous Work Experience related questions
Add your answer

Q1. Tell me about yourself
Ans. 
Experienced business analyst with a background in data analysis and process improvement.
• Over 5 years of experience in analyzing business processes and identifying areas for improvement

• Proficient in data analysis tools such as Excel, SQL, and Tableau

• Strong communication skills and ability to work with cross-functional teams

• Certified in Business Analysis Professional (CBAP)

• Previously led a project to streamline inventory...read more
Answered by AI
Add your answer
Q2. Which projects u have worked
Ans. 
I have worked on various projects including system implementation, process improvement, and data analysis.
• Implemented a new CRM system to streamline customer interactions

• Led a team to improve inventory management processes resulting in cost savings

• Conducted data analysis to identify trends and make recommendations for business growth
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Tell me projects you have worked upon
Add your answer

Q1. Tell me about yourself
Ans. 
I am a detail-oriented business analyst with a strong background in data analysis and problem-solving.
• Experienced in gathering and analyzing business requirements

• Skilled in creating data models and visualizations

• Proficient in using tools like SQL, Excel, and Tableau

• Strong communication and presentation skills

• Ability to work collaboratively with cross-functional teams
Answered by AI
Add your answer

Q1. Related to the work experience
Add your answer

Moderately Easy Aptitude

Moderately Easy GD, easy to clear

Q1. Final round is just a formal intro with the company
Add your answer
Q2. Tell me something about yourself
Add your answer