LenDenClub BI Analyst Interview Questions and Answers

It was hackerrank test

30 minutes Aptitude test

1 Hour 30 minutes on SQL screening test

Q1. Are you comfortable working late hours?
Add your answer
Q2. Yes, Because I complete my work with dedication and commitment.
Add your answer

Hackerrank test mostly on python and sql

Q1. SQL based questions
Add your answer
Q2. Python based questions
Add your answer

Q1. Business Head will take the interview regarding job
Add your answer

Q1. Hr will take interview
Add your answer

Q1. How event loop works?
Add your answer

2 leetcode medium questions were asked

Q1. 1 feature design end to end
Ans. 
Designing a feature for a social media platform to allow users to create and share photo albums.
• Allow users to create and name albums

• Provide an interface for users to upload and organize photos within albums

• Implement privacy settings to control who can view and contribute to albums

• Include features like tagging, commenting, and liking photos within albums

• Enable users to share albums with others via links or social media
Answered by AI
Add your answer

Q1. Basic hr questions
Add your answer

Q1. Design Zomato Ordering System
Ans. 
Design a Zomato Ordering System for online food delivery.
• Allow users to browse restaurants and menus

• Implement user authentication and profile management

• Enable users to place orders and make payments online

• Include features like order tracking and ratings/reviews

• Integrate with restaurant partners for order fulfillment
Answered by AI
Add your answer