Chai Kings Interview Questions and Answers

Two medium DSA questions based on strings.

Q1. Design Google Meet
Ans. 
Design a video conferencing platform similar to Google Meet.
• Implement real-time video and audio streaming

• Include features like screen sharing, chat, and participant management

• Ensure scalability to support large number of users

• Focus on security and privacy measures

• Optimize for low latency and high quality video/audio
Answered by AI
Add your answer

Hellbound test are not required to select 1 employee

Q1. Why r u here
Ans. 
I am here because I am passionate about analyzing data and providing valuable insights to drive decision-making.
• Passionate about data analysis

• Enjoy providing valuable insights

• Driven to help make informed decisions
Answered by AI
Add your answer
Q2. Tell me about something
Ans. 
I will tell you about my experience volunteering at a local animal shelter.
• Volunteered at local animal shelter for 6 months

• Assisted with feeding, cleaning, and socializing with animals

• Helped organize adoption events and fundraisers
Answered by AI
Add your answer

DSA, 1 hour with 2 LC medium questions

Q1. Low level design
Add your answer
Q2. Design lld for Dream 11
Ans. 
Designing the low-level design for Dream 11 platform.
• Use microservices architecture for scalability and flexibility.

• Implement a robust database schema to handle large amounts of user data.

• Utilize caching mechanisms to improve performance, especially during peak usage times.

• Include authentication and authorization mechanisms to ensure data security.

• Design APIs for seamless integration with third-party services.

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

Q1. High level design
Add your answer
Q2. Design HLD for rider management system
Ans. 
Design HLD for rider management system
• Use microservices architecture for scalability and flexibility

• Implement user authentication and authorization for security

• Include features like ride tracking, payment processing, and feedback system

• Utilize databases for storing rider information and ride history
Answered by AI
Add your answer

Q1. Screening questions
Add your answer
Q2. Name, age, qualification, prior experience etc
Add your answer

Operation questions like vlookups, Hlookups, xlookups etc,.

Reporting questions like pivot tables, typing speed, power pivots, pricing sheet preparation

SQL queries like joins, aggregation functions, filters etc,.

Q1. Advanced analytics and finding trends and patterns with MH - operations data
Add your answer
Q2. How fast can you prepare a bar chart with product operations data
Ans. 
I can prepare a bar chart with product operations data within a few minutes.
• I have experience using data visualization tools like Tableau, Power BI, or Excel to quickly create bar charts.

• I am proficient in organizing and cleaning data to ensure accurate representation in the chart.

• I can customize the chart with relevant labels, colors, and titles to make it visually appealing and easy to understand.
Answered by AI
Add your answer
Q3. How can I do merge multiple excel files together
Ans. 
You can merge multiple Excel files together using the 'Consolidate' feature in Excel.
• Open Excel and go to the 'Data' tab

• Click on 'Consolidate' in the 'Data Tools' group

• Select the files you want to merge and choose the desired options

• Click 'OK' to merge the files together
Answered by AI
Add your answer

Basic RCA question to diagnose falling numbers in a matrix.

Basic left join, right join, sub query, ranking etc.

Q1. Joins, operations questions not data analysis questions
Add your answer
Q2. Customer retention case study
Add your answer
Q3. Cumulative sum for given table
Ans. 
To calculate cumulative sum for a given table
• Sort the table in ascending order based on the column you want to calculate the cumulative sum for

• Add a new column to the table to store the cumulative sum

• Iterate through each row of the table and calculate the cumulative sum by adding the current row's value to the previous row's cumulative sum

• Store the cumulative sum in the new column for each row
Answered by AI
Add your answer
Q4. Do you have experience in operations/data entry role
Ans. 
Yes, I have experience in both operations and data entry roles.
• I have worked as a data entry operator for a pharmaceutical company where I was responsible for entering patient data into the system.

• In my previous role as an operations analyst, I was responsible for analyzing data and creating reports for the management team.

• I have experience using various data entry software such as Microsoft Excel and Google Sheets.

• I a...read more
Answered by AI
Add your answer
Q5. As a data analyst can you do data entry work also?
Ans. 
Yes, I can do data entry work as a data analyst.
• Data entry work is a part of data analysis process.

• I have experience in data entry work and can perform it efficiently.

• Data entry work includes entering data into spreadsheets, databases, or other software.

• I understand the importance of accurate data entry for effective analysis.
Answered by AI
Add your answer
Q6. Normal excel statements like if, vlookup, xlookups etc.,
Add your answer