Care Health Insurance Abdm Business Interview Questions and Answers

I had a very bad interview experience. The interviewer didn't start with any introduction and immediately jumped into asking case study. After giving a case, he would leave for a few minutes, which made it seem like he was not interested in the process.

Questions asked:
Q1: You are an Analyst at UBER. The gross cab cancellation rate daily is 5% whereas on a particular day, it goes up to 10%. What could be the factors affecting the same?
To analyze the same list down the tables required in the database along with all the columns and write the query using the same table name & columns to find the required metrics.

Q2: Assume you work for YouTube Music and the CEO wants you to create a Business Health Dashboard. List down all the metrics the CEO will be interested in looking at.

Q1. How does reconciliation happens in AEPS
Ans. 
Reconciliation in AEPS involves matching the transactions between the bank and the service provider to ensure accuracy.
• Reconciliation involves comparing the transactions recorded by the bank with those recorded by the service provider.

• Any discrepancies are identified and resolved to ensure accurate financial records.

• Reconciliation helps in detecting errors, fraud, or any other discrepancies in the transactions.

• Examples...read more
Answered by AI
Add your answer
Q2. Tell me about yourself
Add your answer

Q1. About projects i have written in resume
Add your answer
Q2. Sql simple queries on window functions
Add your answer

Q1. Asked few sql queries
Add your answer
Q2. General discussions on my daily work in office
Add your answer

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. 1.Walkthrough of your profile. 2.Know about the company
Add your answer
Q2. 2.What do you know about the company
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. What is waterfall, agile ceremonies etc
Ans. 
Waterfall and Agile are project management methodologies. Agile ceremonies are regular meetings in Agile methodology.
• Waterfall is a linear and sequential approach to project management.

• Agile is an iterative and flexible approach to project management.

• Agile ceremonies include daily stand-up meetings, sprint planning, sprint review, and retrospective meetings.

• Waterfall focuses on detailed upfront planning, while Agile al...read more
Answered by AI
Add your answer
Q2. Wealth related, scenarios?
Add your answer
Q3. How will you manage your day?
Add your answer

They will give you 2 questions to solve and reply back in half an hour.

Q1. Current CTC, Preferred location
Ans. 
Current CTC and preferred location are confidential information.
• Current CTC and preferred location are personal and confidential details.

• It is common practice not to disclose current CTC during interviews.

• Preferred location may vary based on individual circumstances and preferences.
Answered by AI
Add your answer

Q1. About yourself, projects worked, sql questions, Python questions
Add your answer