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

Product Analyst

CRED
upvote
share-icon
2 rounds | 5 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 2 Months
Topics: Basic sql, RCA, guesstimate, joins, window funtions, python, pandas
Tip
Tip

Tip 1 : practice ample of question on stratascratch and hackerrank
Tip 2 : practice ample gusstimates

Application process
Where: Other
Eligibility: No criteria
Resume Tip
Resume tip

Tip 1 : try to have some internship experience
Tip 2 : try to include some real life usecase of data analytics

Interview rounds

01
Round
Medium
Online Coding Interview
Duration75 Minutes
Interview date7 Sep 2022
Coding problem2

1. SQL Question

Write a query to return date vs daily active users on the platform. Return only the dates having an odd number of daily active users. A user is considered active if they have completed an order on a particular date

Problem approach

Tip 1 : practice joins between table
Tip 2 : practice question of nesting queries

2. SQL Question

Write a query to display top three buyers whose orders are marked completed

02
Round
Medium
Video Call
Duration60 Minutes
Interview date15 Sep 2022
Coding problem3

1. Puzzle

You have 3 switches and 1 fan. The switches are outside the room and fan is inside. You can go into room once and once you go you cannot touch the switches. Now you need to figure out which switch turns on the fan

Problem approach

Tip 1 : Practice aptitude question

2. Puzzle

Given are ten balls, the task is to place these 10 balls in five lines such that each line contains exactly 4 balls.

3. Python Implementation Question

Find the most expensive products on Amazon for each product category. Output category, product name and the price (as a number)

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
Backend Developer
3 rounds | 3 problems
Interviewed by CRED
3889 views
0 comments
0 upvotes
company logo
Backend Developer
2 rounds | 4 problems
Interviewed by CRED
4892 views
0 comments
0 upvotes
company logo
SDE - Intern
3 rounds | 5 problems
Interviewed by CRED
3590 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 9 problems
Interviewed by Salesforce
3452 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