APAC Financial Services Business Analyst Interview Questions and Answers

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. 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

Good,it was a great experience to me

Q1. Amalgamation and absorption differences
Ans. 
Amalgamation and absorption differences
• Amalgamation is a merger of two or more companies into a new entity, while absorption is when one company takes over another and the absorbed company ceases to exist

• In amalgamation, the shareholders of the merging companies become shareholders of the new entity, while in absorption, the shareholders of the absorbed company become shareholders of the absorbing company

• Amalgamation c...read more
Answered by AI
Add your answer
Q2. Private company rules and regulations
Ans. 
Private companies have their own set of rules and regulations that govern their operations.
• Private companies are not subject to the same regulations as public companies.

• They have more flexibility in terms of decision-making and operations.

• However, they still need to comply with laws and regulations related to taxation, employment, and other areas.

• Private companies may also have their own internal policies and procedure...read more
Answered by AI
Add your answer

Q1. Past experience queries and some tech questions related to past projects
Add your answer

Q1. Some mainframe, CIBIL and db2 questions
Add your answer

Q1. General questions
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