Travelkhana Interview Questions and Answers

Round duration - 120 minutes
Round difficulty - Medium

Round duration - 120 minutes
Round difficulty - Medium

- Discussion on the first round's assignment
- Was asked about adding unit tests in the assignment
- Fundamental questions on the approach used for the assignment.

Q1. What are some things that could have been done better in the system design problem given in the first round?
Ans. 
Some improvements in the system design problem could include better scalability planning, more efficient data storage solutions, and improved error handling.
• Implementing a more robust caching mechanism to improve performance under heavy load.

• Optimizing the database schema for better query performance and scalability.

• Introducing load balancing and horizontal scaling to handle increased traffic.

• Enhancing error handling t...read more
Answered by AI
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

Round was with tech lead. Was briefly asked about the problem I solved in the first round. Then I was asked to solve 1 medium level DSA based question. Some discussion on culture fit was also done.

Q1. Given the frequency of traffic lights' states, can you determine if there will ever be an invalid state for the traffic signal, and what are the conditions that lead to an invalid state?
Ans. 
Yes, an invalid state can occur if the traffic lights are in conflicting states simultaneously.
• An invalid state occurs when multiple traffic lights are showing conflicting signals, such as both red and green at the same time.

• This can happen due to a malfunction in the traffic light system or human error in programming the lights.

• For example, if a traffic light is stuck showing both red and green signals, it would be co
Answered by AI
Add your answer

Q1. Can you handle the situation if vendor payment not done for company side .
Ans. 
Yes, I have experience handling vendor payments and can address the situation effectively.
• I have experience in managing vendor relationships and ensuring timely payments.

• I would first investigate the reason for the missed payment, whether it was an oversight or a dispute with the vendor.

• I would communicate with the vendor to explain the situation and work towards a resolution, such as negotiating a new payment schedule...read more
Answered by AI
Add your answer
Q2. How to identify the root cause of supply not done
Ans. 
Identifying the root cause of supply not done involves analyzing processes, communication, and potential obstacles.
• Review the supply chain process from start to finish to identify any bottlenecks or inefficiencies

• Communicate with team members involved in the supply process to gather information on any issues or challenges faced

• Check for any external factors such as supplier delays or transportation issues that may be c...read more
Answered by AI
Add your answer

Q1. How would you rate your proficiency in data analysis?
Ans. 
I rate my proficiency in data analysis as advanced.
• Proficient in using statistical software such as R and Python for data analysis

• Experienced in cleaning and organizing large datasets

• Skilled in creating data visualizations to communicate insights

• Have successfully completed data analysis projects during my academic studies
Answered by AI
Add your answer
Q2. Can you provide an example of how you have utilized Excel to enhance a process or improve efficiency?
Ans. 
Yes, I used Excel to automate data entry and analysis for a research project.
• Created macros in Excel to automatically import and organize data from multiple sources

• Used pivot tables and charts to analyze and visualize data trends

• Implemented conditional formatting to quickly identify outliers and discrepancies

• Saved time by setting up formulas for calculations and generating reports
Answered by AI
Add your answer
Q3. What is the average number of flights that take off daily from Delhi Airport?
Ans. 
The average number of flights that take off daily from Delhi Airport is approximately 1,300.
• Approximately 1,300 flights take off daily from Delhi Airport.

• The number of flights can vary depending on the day of the week and time of year.

• Delhi Airport is one of the busiest airports in India, serving both domestic and international flights.
Answered by AI
Add your answer
Q4. What is the average monthly consumption of tea in Mumbai?
Ans. 
The average monthly consumption of tea in Mumbai is approximately 3-4 kg per person.
• The average monthly consumption of tea in Mumbai varies depending on individual preferences and habits.

• Tea is a popular beverage in Mumbai, with many people consuming multiple cups a day.

• Factors such as age, gender, and socio-economic status can also influence tea consumption in Mumbai.
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

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

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

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