Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Scaler Academy Team. If you also belong to the team, you can get access from here

Scaler Academy Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Scaler Academy Production Analyst Interview Questions and Answers

Updated 21 Dec 2024

Scaler Academy Production Analyst Interview Experiences

3 interviews found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Dec 2023. There were 5 interview rounds.

Round 1 - Coding Test 

5 SQL Questions (Leetcode Level)

Round 2 - Assignment 

Uber is experiencing a decline in profits in the current quarter. How can this issue be addressed?

Round 3 - Technical 

(2 Questions)

  • Q1. Simple SQL based questions on Joins , Self Joins, Window Functions, Group Concat etc.
  • Q2. Difference between Rank, Dense Rank and Row number.
  • Ans. 

    Rank assigns a unique rank to each row, Dense Rank assigns a unique rank to each distinct row, and Row number assigns a unique sequential integer to each row.

    • Rank function does not skip any ranks if there are ties.

    • Dense Rank function skips ranks if there are ties.

    • Row number function assigns a unique sequential integer to each row.

    • Example: Rank - 1, 2, 2, 4; Dense Rank - 1, 2, 2, 3; Row number - 1, 2, 3, 4.

  • Answered by AI
Round 4 - Technical 

(2 Questions)

  • Q1. SQL Questions on Windows Functions , Self Join Etc.
  • Q2. Case Study: Suppose there is a resume builder in Scaler. What metrics should we track on Resume builder.
  • Ans. 

    Metrics to track on a resume builder in Scaler

    • Number of resumes created

    • Average time spent on creating a resume

    • Percentage of resumes completed

    • Number of templates used

    • Feedback ratings from users

  • Answered by AI
Round 5 - One-on-one 

(2 Questions)

  • Q1. Basic SQL Questions
  • Q2. What could be the root causes of the decline in transactions on an e-commerce platform?
  • Ans. 

    Possible root causes of decline in e-commerce transactions

    • Poor user experience leading to high bounce rates

    • Lack of marketing efforts resulting in decreased traffic

    • Technical issues causing website downtime or slow loading times

    • Increased competition from other e-commerce platforms

    • Changes in consumer behavior or preferences

    • Security concerns leading to lack of trust in the platform

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Campus Placement and was interviewed in Mar 2024. There were 4 interview rounds.

Round 1 - Case Study 

General Case Study on real life topic

Round 2 - Technical 

(1 Question)

  • Q1. SQL - Easy to Medium
Round 3 - Technical 

(1 Question)

  • Q1. SQL - Hard + Logical Thinking + Case Study
Round 4 - Technical 

(1 Question)

  • Q1. SQL + Resume + HR

Production Analyst Interview Questions Asked at Other Companies

asked in SPRINKLR
Q1. Minimum Time To Solve The Problems Given 'N' subjects, each conta ... read more
asked in SPRINKLR
Q2. Maximum of All Subarrays of Size K You are provided with an array ... read more
asked in CRED
Q3. you are PM of Netflix what will be the top 3 metrics you will loo ... read more
asked in SPRINKLR
Q4. LRU Cache Design Question Design a data structure for a Least Rec ... read more
asked in SPRINKLR
Q5. Shortest Path in a Binary Matrix Problem Statement Given a binary ... read more
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

SQL questions, easy, medium, hard

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Normal discussion
Round 2 - Technical 

(1 Question)

  • Q1. Excel,sql,python

Interview Preparation Tips

Interview preparation tips for other job seekers - they are rude af on the interview rounds, me and some of my connections reported that too
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - HR 

(2 Questions)

  • Q1. The first round of interviews was smooth; I had to visit their office in Andheri and then have a face-to-face conversation with Neeraj sir (Hr). The questions were to introduce yourself, what is big data, ...
  • Q2. After answering, he seemed somehow satisfied, but later he was encouraging me to enroll in their course and enhance my skills. And I'm still getting their emails and promotional messages for the same.
Round 3 - Technical 

(2 Questions)

  • Q1. The second round was on the call, which was rescheduled thrice. Then finally I got a call where Ashish sir (Hr) asked me to introduce myself, what are T&Z testing, overfitting, K neighbour algorithm, can w...
  • Q2. The job position was for a fresher Data analyst, but they were asking questions related to Data scientist position. Basically, they were looking for a candidate who has hands-on experience with real-time d...

Interview Preparation Tips

Topics to prepare for Imarticus Learning Data Analyst interview:
  • Data Science
  • R
  • Python
  • Excel
Interview preparation tips for other job seekers - Learn more about Data science, the company is into placing students in MNC's if they are skillful.

I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Will u be able to manage job stress

Interview Preparation Tips

Interview preparation tips for other job seekers - It was an average interview process nothing much difficult

Interview Questionnaire 

1 Question

  • Q1. Any type of questions in data field

I applied via Naukri.com and was interviewed before Sep 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Question was moderate.based on logical reasoning and math.

Round 2 - Coding Test 

Coding test question based on sql and python.

Interview Preparation Tips

Interview preparation tips for other job seekers - if u have good knowledge on python ,machine learning and sql, then u can easily crack the exam.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Excel assignment
Round 2 - Technical 

(2 Questions)

  • Q1. Sql based one on one round
  • Q2. Excel based one on one round
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Assignment 

Question about excel, pivot table , SQL and power bi

Contribute & help others!
anonymous
You can choose to be anonymous

Scaler Academy Interview FAQs

How many rounds are there in Scaler Academy Production Analyst interview?
Scaler Academy interview process usually has 3-4 rounds. The most common rounds in the Scaler Academy interview process are Technical, Assignment and One-on-one Round.
What are the top questions asked in Scaler Academy Production Analyst interview?

Some of the top questions asked at the Scaler Academy Production Analyst interview -

  1. Case Study: Suppose there is a resume builder in Scaler. What metrics should we...read more
  2. What could be the root causes of the decline in transactions on an e-commerce p...read more
  3. Difference between Rank, Dense Rank and Row numb...read more

Recently Viewed

SALARIES

Scaler Academy

INTERVIEWS

Testbook.com

No Interviews

SALARIES

Scaler Academy

SALARIES

Scaler Academy

INTERVIEWS

MeritNation

No Interviews

INTERVIEWS

Testbook.com

No Interviews

REVIEWS

Scaler Academy

No Reviews

INTERVIEWS

Cuemath

No Interviews

INTERVIEWS

MeritNation

No Interviews

INTERVIEWS

Testbook.com

30 top interview questions

Tell us how to improve this page.

Scaler Academy Production Analyst Interview Process

based on 3 interviews

Interview experience

4.7
  
Excellent
View more

Interview Questions from Similar Companies

Planet Spark Interview Questions
3.7
 • 359 Interviews
Whitehat jr Interview Questions
3.4
 • 262 Interviews
Unacademy Interview Questions
3.0
 • 206 Interviews
upGrad Interview Questions
3.7
 • 198 Interviews
Vedantu Interview Questions
3.3
 • 185 Interviews
NxtWave Interview Questions
3.8
 • 177 Interviews
Simplilearn Interview Questions
3.2
 • 101 Interviews
Testbook.com Interview Questions
3.6
 • 99 Interviews
View all
Scaler Academy Production Analyst Salary
based on 5 salaries
₹6 L/yr - ₹16 L/yr
15% less than the average Production Analyst Salary in India
View more details

Scaler Academy Production Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

4.0

Salary

4.0

Job security

4.0

Company culture

4.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Senior Business Development Associate
300 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Associate
192 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Manager
95 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Business Development Executive
54 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Executive
43 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Scaler Academy with

upGrad

3.7
Compare

Simplilearn

3.2
Compare

Great Learning

3.7
Compare

Imarticus Learning

4.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview