AliveCor Interview Questions and Answers

Q1. SQL question ( window functions) dense_rank
Add your answer
Q2. SQL question(window function) aggregation, there were 5 tables and you had to do some joins
Add your answer
Q3. Some question on spark optimisations
Add your answer

Q1. Online DSA round where question to be solved in front of interviewer and we need to pass all the cases. Question was based on frequency sort. This was to be done on HackerRank platform for which interviewe...read more
Add your answer
Q2. Basic question based on internal working of hashmap, inter threads communication, Concurrent HashMap working and how it handles thread safety.
Add your answer

Q1. Basic introduction and question asked based on my previous projects that i worked on. Few follow ups on the same.
Add your answer
Q2. Was asked to design a ratelimiter service
Add your answer
Q3. Question on synchronized keyword and it works internally. Threads and its inter communication.
Add your answer

Q1. How to calculate requirement of Banana is a city like Mumbai
Ans. 
The requirement of bananas in a city like Mumbai can be calculated based on population, consumption habits, and availability.
• Calculate the population of Mumbai

• Estimate the average consumption of bananas per person

• Consider factors like tourism and events that may increase demand

• Take into account the availability of bananas from local markets and imports
Answered by AI
Add your answer
Q2. How to know , difference between a good or bad retailer
Ans. 
A good retailer focuses on customer satisfaction, product quality, and efficient operations.
• Good retailers prioritize customer satisfaction by providing excellent customer service and addressing customer needs.

• Good retailers offer high-quality products that meet customer expectations.

• Good retailers have efficient operations, including inventory management, supply chain logistics, and streamlined processes.

• Bad retailers...read more
Answered by AI
Add your answer
Q3. Simple SQL questions
Add your answer

Total 25 questions in 30 min

GD is on social effect

Q1. 1 min talk on a specific given topic
Add your answer

Q1. Some technical questions as am from Entc bg...try to clear your own technical clear ... nothing extra
Add your answer

Q1. All about HR QUESTIONS
Add your answer

Q1. What is the Total Experience as the All Lines
Add your answer

Group Discussion as the ABM ,GM , Founder and Co Fouder

Q1. What is the Experience total years
Add your answer
Q2. Where are you Working Location
Add your answer

Q1. Which is the Reporting Manager
Ans. 
The Reporting Manager is the individual to whom the Business Development Manager will report to.
• The Reporting Manager is typically a higher-level manager within the organization

• They are responsible for overseeing the work and performance of the Business Development Manager

• The Reporting Manager provides guidance, feedback, and support to the Business Development Manager

• Examples of Reporting Managers could include the Di...read more
Answered by AI
Add your answer
Q2. What is the Experience in All sector
Add your answer

Written test with 16 aptitude and 10 pseudo code

6 questions with moderate level

Q1. Self introduction
Add your answer
Q2. Resume based questions
Add your answer

Q1. Tell me about yourself?
Add your answer
Q2. Tell me about your work experience?
Add your answer
Q3. Why do you want to switch to Edtech?
Add your answer

Q1. Here the interview was with VP Sales, again tell me about yourself?
Add your answer
Q2. Asked questions related to my resume experience ?
Add your answer
Q3. Why do you want to switch to Edtech ?
Add your answer

Q1. This round was with the Co-founder Vivek. He wanted to know everything in detail about the work I did? How I did? What were my targets? How did I achieve them ? What different things I did? What exactly wa...read more
Add your answer

Q1. Crawler Design Problem
Ans. 
Design a web crawler to efficiently crawl and index web pages.
• Consider using a breadth-first or depth-first search algorithm to traverse the web pages.

• Implement a system to handle duplicate content and avoid infinite loops.

• Use a priority queue to prioritize which pages to crawl next based on relevance or importance.

• Include a mechanism to handle dynamic content and JavaScript-rendered pages.

• Optimize the crawler for spee...read more
Answered by AI
Add your answer
Q2. System Scalability and Distributed Systems
Add your answer