OSB India Business Analyst Interview Questions and Answers

Mcqs and coding questions

Q1. Oops python sql
Add your answer

Q1. About u and ur family background
Add your answer

Q1. Basic Introduction and work experience
Add your answer

Q1. In depth discussion about the job role and requirements
Add your answer
Q2. Why choosing this role and skills you have
Add your answer

Q1. Write me a query to get the last month's data and it only runs 1st of everymonth
Ans. 
Query to retrieve last month's data on the 1st of every month
• Use the DATEADD function to subtract a month from the current date

• Filter the results to only include data from the 1st of the month

• Example: SELECT * FROM table_name WHERE date_column = DATEADD(month, -1, DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0))
Answered by AI
Add your answer

Q1. Situational Questions
Add your answer

Q1. What do you know about the company?
Add your answer

Q1. Questions overall on work experience
Add your answer
Q2. Technical questions on skills mentioned
Add your answer

Q1. Resume Discussion thorough
Add your answer
Q2. Resume Discussion Thorough
Add your answer

Q1. DWH Concepts and ETL
Add your answer
Q2. Related to RDBMS, ETL and DWH
Add your answer

Q1. Stick to Basics to clear
Add your answer

Q1. What is agile methology?
Ans. 
Agile methodology is a project management approach that emphasizes flexibility, collaboration, and incremental progress.
• Focus on delivering working software in short iterations

• Embrace changing requirements

• Encourage frequent collaboration between team members

• Use feedback to continuously improve the product

• Common frameworks include Scrum and Kanban
Answered by AI
Add your answer
Q2. Write a user story and edge cases
Ans. 
User story for a shopping website
• As a user, I want to be able to add items to my cart

• As a user, I want to be able to view my cart and update quantities

• As a user, I want to be able to proceed to checkout and make a payment
Answered by AI
Add your answer

Q1. What were your biggest weaknesses
Add your answer
Q2. Tell me about a time when you went above and beyond
Ans. 
I volunteered to work overtime to complete a critical project ahead of schedule.
• Offered to work extra hours to meet project deadline

• Took on additional tasks to ensure project success

• Collaborated with team members to streamline processes and improve efficiency
Answered by AI
Add your answer