KhataBook Collections Executive Interview Questions and Answers

Q1. Intro and how to deal with this job
Add your answer
Q2. Intro then job description
Add your answer
Q3. About family background ...living style ...any movie recently watched....
Add your answer
Q4. What you tell when customer said I don't pay this amount? ?
Ans. 
Explain the importance of paying the amount and address any concerns the customer may have.
• Explain the reasons for the amount owed (e.g. services provided, products purchased)

• Discuss the consequences of not paying the amount (e.g. late fees, credit score impact)

• Offer solutions or payment plans to help the customer meet their financial obligations

• Listen to the customer's concerns and try to find a mutually beneficial re
Answered by AI
Add your answer

Q1. Tell about your work experience
Ans. 
I have over 5 years of experience in collections, managing accounts, negotiating payment plans, and reducing delinquency rates.
• Managed a portfolio of over 500 accounts, consistently meeting collection targets

• Negotiated payment plans with clients to ensure timely payments and reduce delinquency rates

• Utilized collection software to track and prioritize accounts for follow-up

• Worked closely with legal team on escalated cas
Answered by AI
Add your answer
Q2. Tell about collection
Ans. 
Collection is the process of recovering outstanding debts from individuals or businesses.
• Collection involves contacting debtors to remind them of their outstanding debts

• Negotiating payment plans with debtors to settle the debts

• Taking legal action if necessary to recover the debts

• Maintaining accurate records of all collection activities

• Examples: calling customers for overdue payments, sending reminder letters, negotiati
Answered by AI
Add your answer

Q1. About previous experience
Add your answer
Q2. What was your previous experience
Add your answer

Q1. How will you deal with pressure
Add your answer

Q1. Introduce about yourself
Add your answer
Q2. Previous job experience
Add your answer

Q1. 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. SQL, Python and Excel
Add your answer