KFintech Business Analyst Interview Questions and Answers

Quantitative aptitude, verbal ability, critical reasoning

Q1. SQL: find store with highest AOV
Add your answer
Q2. Generic behavioural questions
Add your answer

Q1. Project related questions
Add your answer
Q2. Financial instruments knowledge
Add your answer

Q1. General project related questions
Add your answer
Q2. Financial domain in depth questions
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. SQL joins inner join, outer join and left join
Add your answer
Q2. It was about window function , like we have to use row_number.....don't remberer exact question
Add your answer

Q1. SQL Queries for JOINS
Ans. 
SQL queries for JOINS
• Use INNER JOIN to retrieve rows from both tables that have matching values

• Use LEFT JOIN to retrieve all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to retrieve all rows from the right table and the matched rows from the left table

• Use FULL JOIN to retrieve rows when there is a match in either table
Answered by AI
Add your answer
Q2. QUERY FOR metrics given in the sheet
Ans. 
The query is asking for metrics provided in a specific sheet.
• Identify the specific sheet being referred to in the question

• Review the metrics listed in the sheet

• Analyze the relevance of each metric to the query
Answered by AI
Add your answer

This is a case study round revolve around a business problem in which we have to analyse data driven solutions.

Q1. How would you copy a large dataset
Ans. 
Use a data migration tool to copy the dataset efficiently.
• Utilize a data migration tool like AWS Data Pipeline, Apache Nifi, or Talend to copy the dataset.

• Break down the dataset into smaller chunks to avoid overwhelming the system.

• Ensure proper data validation and error handling during the copying process.

• Consider using parallel processing to speed up the copying process.

• Monitor the progress of the dataset copying to t
Answered by AI
Add your answer
Q2. Do you think data analysis job is overrated?
Ans. 
No, data analysis job is not overrated as it plays a crucial role in decision-making and problem-solving.
• Data analysis helps in identifying trends and patterns in data

• It provides valuable insights for businesses to make informed decisions

• Data analysis is essential for optimizing processes and improving efficiency

• It can uncover hidden opportunities and potential risks

• Many industries rely on data analysis for strategic p
Answered by AI
Add your answer

Q1. Experience related to fintech
Add your answer

Q1. Online banking application
Ans. 
Online banking application is a web-based platform that allows customers to perform financial transactions remotely.
• Customers can view account balances and transaction history.

• They can transfer funds between accounts or to other people.

• They can pay bills and set up automatic payments.

• The application should have strong security measures to protect customer data.

• It should also have a user-friendly interface for easy navi...read more
Answered by AI
Add your answer

Q1. Why are you looking for a change?
Add your answer
Q2. Tell me about yourself.
Add your answer

Q1. Jira,product backlog
Add your answer