KreditBee Analyst Interview Questions and Answers

Q1. In this round basic SQL questions were asked.
Add your answer
Q2. In addition to SQL questions the business case study was discussed and some questions were asked around confusion metrics.
Add your answer

Q1. In this round two business case studies were discussed.
Add your answer

Q1. In this round basic HR questions related to my resume and profile were asked
Add your answer

1. Tell me about yourself
2. Estimate the number of hospitals in India

1. There has been a decrease in 20% of the users in the past 3 days in online pharmacy application, what will you do now?

Q1. Salary negotiation on what were last salary and related questions
Add your answer
Q2. How soon can you join?
Add your answer
Q3. Are you holding any other offer, in case you do..they will try to match it which ideally depends on your interview.
Add your answer
Q4. Are you comfortable relocating to the office location?
Add your answer

General SQL and Python questions for Data analysis and Visualization tools

Q1. What do you understand y Churn Rate ?
Ans. 
Churn Rate is the percentage of customers who stop using a product or service over a certain period of time.
• Churn Rate is calculated by dividing the number of customers who stopped using the product by the total number of customers at the beginning of the period.

• It is used to measure customer retention and satisfaction.

• A high churn rate indicates that a company may be losing customers at a high rate, while a low churn ...read more
Answered by AI
Add your answer
Q2. What can be done to increase retention rate ?
Ans. 
To increase retention rate, companies can focus on improving employee engagement, providing opportunities for growth and development, offering competitive compensation and benefits, and creating a positive work culture.
• Improve employee engagement through regular feedback sessions and recognition programs

• Provide opportunities for growth and development through training programs and career advancement opportunities

• Offer ...read more
Answered by AI
Add your answer

Round 1 is Cognitive aptitude test.

Next round had business case study with two model responses and you have to choose better response and give reason.

Q1. Previous experience and projects.
Add your answer

Basic questions from quantitative and logical reasoning

Q1. Guesstimate question about number of ott subscribers all over India.
Ans. 
There are approximately 100 million OTT subscribers in India.
• Consider the total population of India (around 1.3 billion)

• Estimate the percentage of people using OTT platforms (around 30-40%)

• Calculate the number of OTT subscribers based on the percentage

• Example: 1.3 billion * 0.35 = 455 million OTT subscribers
Answered by AI
Add your answer
Q2. Logical question.
Add your answer
Q3. How will you chech validity of a claim, online( research based question)
Add your answer
Q4. Projects you did in graduation.
Ans. 
Developed a project on analyzing customer behavior using data analytics tools.
• Used Python for data collection and analysis

• Implemented machine learning algorithms for predictive modeling

• Created visualizations using Tableau for presenting insights
Answered by AI
Add your answer
Q5. What do you know about LLMs?
Ans. 
LLMs stand for Legal Entity Identifiers, unique codes used to identify legal entities involved in financial transactions.
• LLMs are unique 20-character alphanumeric codes used to identify legal entities participating in financial transactions.

• They were introduced as part of the global LEI system to improve transparency and reduce risks in financial markets.

• LLMs are required for reporting under regulations such as MiFID I...read more
Answered by AI
Add your answer

Q1. Explain market research type
Ans. 
Market research types include primary research, secondary research, qualitative research, quantitative research, and exploratory research.
• Primary research involves collecting data directly from the source, such as surveys, interviews, and observations.

• Secondary research involves analyzing existing data sources, such as reports, articles, and databases.

• Qualitative research focuses on understanding attitudes, behaviors, ...read more
Answered by AI
Add your answer
Q2. Explain database type
Ans. 
Database type refers to the structure and organization of data within a database system.
• Database types include relational, NoSQL, object-oriented, and hierarchical databases.

• Relational databases store data in tables with rows and columns, using SQL for querying.

• NoSQL databases are non-relational and can store unstructured data, such as MongoDB or Cassandra.

• Object-oriented databases store data as objects, with attribute...read more
Answered by AI
Add your answer
Q3. Father daughter age questions
Add your answer