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

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

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

Interview Questionnaire 

1 Question

  • Q1. Previous Experience, Some SQL Questions, Business Acumen.

Interview Preparation Tips

Interview preparation tips for other job seekers - Was tested mostly on SQL. A little bit of business knowledge and framework of thoughts and approach to solving a problem.

Interview Questionnaire 

2 Questions

  • Q1. Google sheet
  • Q2. Sql

Interview Preparation Tips

Interview preparation tips for other job seekers - learn google sheet and sql basic formulas

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

I applied via Campus Placement and was interviewed before Dec 2020. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. SQL questions
  • Q2. Guestimates around sizing
  • Ans. 

    Guestimates around sizing

    • Guestimates are rough estimates based on limited information

    • They are useful in situations where precise data is not available

    • Factors such as historical data, industry benchmarks, and expert opinions can be used to make guestimates

    • Guestimates should be clearly communicated as rough estimates and not taken as exact figures

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and curious
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Jan 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Technical questions mostly around sql, project based and few theoretical questions on python
Round 2 - Technical 

(1 Question)

  • Q1. This was one of the most grilled interview i have given, require moderate level of sql understanding, was asked to share screen and solve it , also i had show how it is working then basic questions of py...
Round 3 - HR 

(1 Question)

  • Q1. Was asked basic HR questions

Interview Preparation Tips

Topics to prepare for Simplilearn Data Analyst interview:
  • SQL
  • Python
  • Excel
  • Case Studies
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Dec 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Asked about the Statistics concepts hypothesis,pvalue,mean,meadian.mode,normaldistrubution?
  • Q2. Sql joins questions based on three tables, complex joins

Interview Preparation Tips

Topics to prepare for Simplilearn Data Analyst interview:
  • Statistics
  • SQL
  • joins
Interview preparation tips for other job seekers - brush up all skills be polite while answering
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - HR 

(1 Question)

  • Q1. The first round was a basic telephonic interview. Then simple basic SQL questions and some question based on Normalisation and DBMS were asked.
Round 2 - Technical 

(1 Question)

  • Q1. This was the toughest Data Analyst Interview I have faced till now. Interview was of 1 hr. Required higher level of SQL understanding. Asked to share screen and then solve SQL queries. Question based on jo...

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, Case Study and Aptitude Test.
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

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
 • 369 Interviews
Whitehat jr Interview Questions
3.4
 • 262 Interviews
Unacademy Interview Questions
3.0
 • 207 Interviews
upGrad Interview Questions
3.6
 • 201 Interviews
NxtWave Interview Questions
3.8
 • 186 Interviews
Vedantu Interview Questions
3.3
 • 184 Interviews
Simplilearn Interview Questions
3.2
 • 104 Interviews
Testbook.com Interview Questions
3.5
 • 100 Interviews
View all
Scaler Academy Production Analyst Salary
based on 5 salaries
₹6 L/yr - ₹16 L/yr
16% 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
271 salaries
unlock blur

₹7 L/yr - ₹15.1 L/yr

Business Development Associate
183 salaries
unlock blur

₹4 L/yr - ₹12 L/yr

Business Development Manager
95 salaries
unlock blur

₹8 L/yr - ₹20.4 L/yr

Senior Business Development Executive
54 salaries
unlock blur

₹7 L/yr - ₹14 L/yr

Business Development Executive
45 salaries
unlock blur

₹5 L/yr - ₹11.5 L/yr

Explore more salaries
Compare Scaler Academy with

Whitehat jr

3.4
Compare

Unacademy

3.0
Compare

Extramarks Education

3.4
Compare

Planet Spark

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