AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Scaler Academy
Compare
Filter interviews by
Scaler Academy Production Analyst Interview Questions and Answers
Scaler Academy Production Analyst Interview Experiences
3 interviews found
Anonymous
Selected
I applied via LinkedIn and was interviewed before Dec 2023. There were 5 interview rounds.
5 SQL Questions (Leetcode Level)
Uber is experiencing a decline in profits in the current quarter. How can this issue be addressed?
(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.
(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
(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
Aditya
I applied via Campus Placement and was interviewed in Mar 2024. There were 4 interview rounds.
General Case Study on real life topic
(1 Question)
- Q1. SQL - Easy to Medium
(1 Question)
- Q1. SQL - Hard + Logical Thinking + Case Study
(1 Question)
- Q1. SQL + Resume + HR
SQL questions, easy, medium, hard
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed before Sep 2021. There were 2 interview rounds.
Question was moderate.based on logical reasoning and math.
Coding test question based on sql and python.
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. How do you measure growth of startup
- Ans.
Startup growth can be measured through various metrics such as revenue, user acquisition, market share, and customer satisfaction.
Revenue growth is a key metric for measuring startup growth. This can be tracked through sales figures, profit margins, and overall revenue growth rate.
User acquisition is another important metric. This can be measured through the number of new users acquired over a period of time, as well a...
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
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Jan 2024. There were 3 interview rounds.
(1 Question)
- Q1. Technical questions mostly around sql, project based and few theoretical questions on python
(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...
(1 Question)
- Q1. Was asked basic HR questions
Interview Preparation Tips
- SQL
- Python
- Excel
- Case Studies
I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.
(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.
(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...
Selected
I applied via Referral and was interviewed in May 2024. There were 5 interview rounds.
(2 Questions)
- Q1. Question based on Window Functions in sql
- Q2. Order of execution
- Ans.
Order of execution refers to the sequence in which operations are carried out in a program or system.
Execution starts from the top of the program and moves downwards.
Operations within parentheses are executed first.
Multiplication and division are executed before addition and subtraction.
Functions are executed when they are called.
Control structures like loops and conditionals affect the order of execution.
(2 Questions)
- Q1. Write a sql query to find out different routes for a airline. Table has two columns which are destination and source
- Ans.
Use a SQL query to find different routes for an airline based on source and destination columns in a table.
Use a SELECT statement to retrieve the distinct combinations of source and destination.
Use the DISTINCT keyword to ensure only unique routes are returned.
Order the results by source and destination for easier analysis.
- Q2. Situational questions based on Business KPI
(1 Question)
- Q1. Simple discussion on the role and company culture
(1 Question)
- Q1. Case study question
(1 Question)
- Q1. Basic Discussion on relocation and interest in joining the company.
Interview Preparation Tips
Skills evaluated in this interview
Country Brute's
(2 Questions)
- Q1. Tell me about yourself
- Ans.
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
I have a Bachelor's degree in Statistics and have completed multiple data analysis projects during my studies.
I am proficient in using statistical software such as R and Python to analyze and interpret data.
I have experience in creating visualizations and reports to communicate findings to stakeholders.
I am a quic...
- Q2. Why do you join our company?
- Ans.
I am impressed by your company's innovative approach and strong reputation in the industry.
I am attracted to the company's commitment to innovation and cutting-edge technology.
I admire the company's strong reputation and track record of success.
I believe that the company's values align with my own professional goals and aspirations.
Scaler Academy Interview FAQs
Some of the top questions asked at the Scaler Academy Production Analyst interview -
Tell us how to improve this page.
Scaler Academy Interviews By Designations
- Scaler Academy Senior Business Development Associate Interview Questions
- Scaler Academy Business Development Associate Interview Questions
- Scaler Academy Business Development Executive Interview Questions
- Scaler Academy Senior Business Development Executive Interview Questions
- Scaler Academy Business Development Manager Interview Questions
- Scaler Academy Production Analyst Interview Questions
- Scaler Academy (Bde)business Development Executive Interview Questions
- Scaler Academy Operations Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Production Engineer Interview Questions
- Production Supervisor Interview Questions
- Production Manager Interview Questions
- Production Officer Interview Questions
- Executive Production Interview Questions
- Production Interview Questions
- Senior Production Engineer Interview Questions
- Production Graduate Engineer Trainee Interview Questions
- Show more
Scaler Academy Production Analyst Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Scaler Academy Production Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Business Development Associate
279
salaries
|  ₹7 L/yr - ₹15.1 L/yr |
|
Business Development Associate
202
salaries
| ₹4.5 L/yr - ₹12 L/yr |
|
Business Development Manager
95
salaries
| ₹8 L/yr - ₹20.4 L/yr |
|
Senior Business Development Executive
54
salaries
| ₹7 L/yr - ₹14 L/yr |
|
Business Development Executive
45
salaries
| ₹5 L/yr - ₹11.5 L/yr |
Whitehat jr
Unacademy
Extramarks Education
Planet Spark
- Home >
- Interviews >
- Scaler Academy Interview Questions >
- Scaler Academy Production Analyst Interview Questions
