KhataBook Collections Manager Interview Questions and Answers

Q1. Asking about previous company job profile
View 3 more answers
Q2. Say about yourself
Add your answer
Q3. How much your portfolio size and how many employees under you who work with you
View 3 more answers
Q4. What is your speciality
Add your answer
Q5. What Is Your previous package and why you leaves the previous company
View 3 more answers

Q1. You want to come on board
Add your answer
Q2. Why should we hire you
Add your answer

Q1. Joins outputs for various types of joins
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FU...read more
Answered by AI
Add your answer
Q2. Query using window functions
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations on a set of rows related to the current row.

• They allow you to perform calculations like ranking, moving averages, and cumulative sums.

• Examples of window functions include ROW_NUMBER(), RANK(), and SUM() OVER().
Answered by AI
Add your answer

Quantitative case study on cost benefit analysis of 2 types of public buses running in a city. Need to choose one of them with higher profits

Fraud detection model: 3rd party firm proposing to use thier model for fraud detection. Need to profit analysis of whether to go for it or not.

Q1. Culture fit round to understand if compatible with the company
Add your answer

Sql and excel then tableu

Q1. Sql and excel and basic questions
Add your answer

Q1. Longterm aspiration
Add your answer

Q1. Based on previous experience
Add your answer

Q1. SQL, Python and Excel
Add your answer

Case studies about Navi UPI

Case studies about Navi UPI App