Sploot interview experience Real time questions & tips from candidates to crack your interview

Product Analyst

Sploot
upvote
share-icon
1 rounds | 3 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 2 months
Topics: Retention, Measuring KPI, Root cause analysis, Guesstimate, Case study
Tip
Tip

Tip 1 : Practice with ample of guesstimates
Tip 2 : Do at least 2 product teardowns

Application process
Where: Linkedin
Eligibility: Need 2 projects on resume
Resume Tip
Resume tip

Tip 1 : Have projects that outline your contribution clearly
Tip 2 : Have at least 3 projects with ample product problems

Interview rounds

01
Round
Easy
Video Call
Duration90 minutes
Interview date20 Jan 2022
Coding problem3

The round was pretty generic with common guesstinates and sql problem and a coding question

1. Guesstimate Question

I wish to open a taxi business from and to airports. What is the amount of investment I need and when will I break even.

2. DBMS Questions

  • What are the types of joins and how do they work?
  • Design a query to join 2 tables with a unique key and assume data where ever required

3. Queue Using Stack

Moderate
30m average time
60% success
0/80
Asked in companies
GE (General Electric)ZSGoldman Sachs

Implement a queue data structure which follows FIFO(First In First Out) property, using only the instances of the stack data structure.


Note:
1. To implement means you need to complete some predefined functions, which are supported by a normal queue such that it can efficiently handle the given input queries which are defined below.


2. The implemented queue must support the following operations of a normal queue: 

a. enQueue(data) : This function should take one argument of type integer and place the integer to the back of the queue.

b. deQueue(): This function should remove an integer from the front of the queue and also return that integer. If the queue is empty, it should return -1.

c. peek(): This function returns the element present in the front of the queue. If the queue is empty, it should return -1.

d. isEmpty(): This function should return true if the queue is empty and false otherwise.


3. You will be given q queries of 4 types:

a. 1 val - For this type of query, you need to insert the integer val to the back of the queue.

b. 2 - For this type of query, you need to remove the element from the front of the queue, and also return it.

c. 3 - For this type of query, you need to return the element present at the front of the queue(No need to remove it from the queue).

d. 4 - For this type of query, you need to return true if the queue is empty and false otherwise.


4. For every query of type:

a. 1, you do not need to return anything.

b. 2, return the integer being deQueued from the queue.

c. 3, return the integer present in the front of the queue.

d. 4, return “true” if the queue is empty, “false” otherwise.
Example
Operations: 
1 5
1 10
2
3
4

Enqueue operation 1 5: We insert 5 at the back of the queue.
Queue: [5]

Enqueue operation 1 10: We insert 10 at the back of the queue.
Queue: [5, 10]

Dequeue operation 2: We remove the element from the front of the queue, which is 5, and print it.
Output: 5
Queue: [10]

Peek operation 3: We return the element present at the front of the queue, which is 10, without removing it.
Output: 10
Queue: [10]

IsEmpty operation 4: We check if the queue is empty.
Output: False
Queue: [10]
Try solving now

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

What is recursion?

Choose another skill to practice
Similar interview experiences
company logo
SDE - 1
3 rounds | 7 problems
Interviewed by OYO
4657 views
0 comments
0 upvotes
company logo
SDE - Intern
2 rounds | 3 problems
Interviewed by Amazon
960 views
0 comments
0 upvotes
company logo
SDE - 1
2 rounds | 5 problems
Interviewed by Meesho
6450 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 9 problems
Interviewed by Salesforce
3451 views
0 comments
0 upvotes
Companies with similar interview experiences
company logo
Product Analyst
5 rounds | 5 problems
Interviewed by Sprinklr
5469 views
0 comments
0 upvotes