2 Lokal App Production Analyst Interview Questions & Answers | Complete Prep Guide 2025

Lokal App Production Analyst Interview Experiences

1 interview found

Production Analyst Interview Questions & Answers

Anonymous

posted on 13 Dec 2024

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

2-4 weeks

Result

Selected

I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Aptitude Test

5 SQL questions within 1 hour

Round 2 - One-on-one

(2 Questions)

Q1. Discuss more on my past experience and sql joins and basic questions

Add your answer

Q2. NA

Add your answer

Top trending discussions

View All

Interview Tips & Stories

5d (edited)

timepasstiwari

A Digital Markter

Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question

So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours... read more

Got a question about Lokal App?

Ask anonymously on communities.

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Treebo Hotels

Anonymous

posted on 5 Dec 2024

Interview experience

Average

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

No response

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

Round 1 - Assignment

SQL, excel, tableau , looker studio

Round 2 - HR

(1 Question)

Q1. What is your notice period.

Add your answer

Production Analyst Interview Questions & Answers

Cogoport

Anonymous

posted on 23 Mar 2024

Interview experience

Average

Difficulty level

Process Duration

Result

I applied via Campus Placement

Round 1 - Aptitude Test

C++ basics and Aptitude based questions

Round 2 - One-on-one

(1 Question)

Q1. Project experience, puzzle and product based questions.

Add your answer

Production Analyst Interview Questions & Answers

Cogoport

Anonymous

posted on 13 Oct 2023

Interview experience

Average

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via Campus Placement and was interviewed before Oct 2022. There were 3 interview rounds.

Round 1 - Aptitude Test

The test consists of 2 sections , Aptitude and SQL questions

Round 2 - Technical

(1 Question)

Q1. Case study and guesstimate questions

Add your answer

Round 3 - HR

(1 Question)

Q1. Normal questions

Add your answer

Data Analyst Interview Questions & Answers

ShareChat

Kartik Gogia

posted on 1 Nov 2023

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via Company Website and was interviewed before Nov 2022. There were 2 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 - Technical

(2 Questions)

Q1. SQL Joins Question

Add your answer

Q2. Tough Python Questions

Add your answer

Data Analyst Interview Questions & Answers

ShareChat

Anonymous

posted on 18 Jun 2024

Interview experience

Excellent

Difficulty level

Process Duration

Result

Round 1 - Technical

(1 Question)

Q1. Joins and basics

Add your answer

Round 2 - Case Study

Netflix user churn case study,
Uber booking number reduce

Production Analyst Interview Questions & Answers

ShareChat

Anonymous

posted on 15 Jul 2024

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via Referral and was interviewed before Jul 2023. There were 3 interview rounds.

Round 1 - Technical

(2 Questions)

Q1. General SQL questions

Add your answer

Q2. Questions around past projects

Add your answer

Round 2 - Technical

(2 Questions)

Q1. SQL questions & case study

Add your answer

Q2. Success metric questions

Add your answer

Round 3 - One-on-one

(1 Question)

Q1. Cultural fit questions

Add your answer

Production Analyst Interview Questions & Answers

ShareChat

Anonymous

posted on 22 Nov 2021

I applied via Referral and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire

4 Questions

Q1. Find average n days retention for all users given the user ID, date and activity table. Also another table with the date of joining for each user.

Ans.

Calculate the average n days retention for all users given their user ID, date, activity table, and a table with the date of joining for each user.

Join the activity table with the user table using the user ID
Calculate the number of days between the date of joining and the activity date
Filter out the activities that occurred after n days
Calculate the average retention for all users

Answered by AI

View 1 more answer

Q2. 25 horses, find 5 fastest horses, with the constraint that you're only allowed to race 5 horses at a time.

Ans.

Race 5 horses at a time to find the 5 fastest horses out of 25.

Divide the horses into 5 groups of 5 horses each.
Race all the horses in each group and note down the timings.
The top 3 horses from each group move to the next round.
Race all the horses that made it to the next round and note down the timings.
The top 2 horses from this round move to the final round.
Race these 2 horses and the fastest one is the winner.
The to...

Answered by AI

Add your answer

Q3. Find nth item without using limit and rank Remove duplicates from combination of two columns, so A1 A2 a b b a Given two columns, remove duplicates for any combination. So the above would be duplicates...

Ans.

To remove duplicates from two columns, use DISTINCT keyword in SELECT statement.

Use SELECT DISTINCT to retrieve unique combinations of two columns.
Combine the two columns using CONCAT function before applying DISTINCT.
Example: SELECT DISTINCT CONCAT(column1, column2) FROM table_name;

Answered by AI

Add your answer

Q4. Discussion about skewed Normal distribution, types of skew, impact of skew on mean and median.

Add your answer

Interview Preparation Tips

What is your professional and academic background?At the time of the interview, I had 1 - 3 years of experience.Sharechat interview Rounds:Round 1
Round type - Technical
Round duration - 60 Minutes
Round description -
Round to test basic sql, probability, statistics, and general ability.

Round 2
Round type - Technical
Round duration - 60 Minutes
Round description -
Multiple sql questions, advanced stats and probability questions

Round 3
Round type - General discussion
Round description -
Discussion based on the work that you have done, in depth questions about share chat app and why you're a good fit for the role.
Sharechat interview Preparation:What topics did you prepare for the interview? - SQL, data warehouses, statistical testing.What resources did you refer to prepare for the interview? - Gfg puzzles, introductory books on statistics and probability.What tips would you give to other job seekers? - 1. Be proficient in sql and statistics.
2. Do have a look at the sharechat app and the ecosystem in which it operates.
3. Prepare for puzzles and general problem solving on gfg or some other platform.What was the final outcome of your interview?Selected

Skills evaluated in this interview

Production Analyst Interview Questions & Answers

ShareChat

Anonymous

posted on 10 Jun 2024

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via Company Website and was interviewed before Jun 2023. There were 3 interview rounds.

Round 1 - Aptitude Test

SQL round and resume discussion

Round 2 - Case Study

Guesstimates and RCA around sharechat itself - revenue drop RCA

Round 3 - One-on-one

(4 Questions)

Q1. Resume discussion

Add your answer

Q2. Product design and general discussion

Add your answer

Q3. Experimentation

Add your answer

Q4. Behavioral questions

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Strong SQL is pre-req for this role, they will also look for mental aptitude via puzzles and product thinking.

Product Manager Interview Questions & Answers

Dailyhunt

Anonymous

posted on 18 Jun 2024

Interview experience

Good

Difficulty level

Process Duration

Result

Round 1 - One-on-one

(1 Question)

Q1. Root cause analysis question

Add your answer

Lokal App Interview FAQs

How many rounds are there in Lokal App Production Analyst interview?

Lokal App interview process usually has 2 rounds. The most common rounds in the Lokal App interview process are Aptitude Test and One-on-one Round.

How to prepare for Lokal App Production Analyst interview?

Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Lokal App. The most common topics and skills that interviewers at Lokal App expect are Analytical skills, Analytics, Problem Solving, Product Analysis and Product Management.

Business Analyst 11 salaries	₹0 L/yr - ₹0 L/yr
Content Writer 10 salaries	₹0 L/yr - ₹0 L/yr
Production Analyst 9 salaries	₹0 L/yr - ₹0 L/yr
Associate Product Manager 9 salaries	₹0 L/yr - ₹0 L/yr
Digital Marketing Executive 8 salaries	₹0 L/yr - ₹0 L/yr

Lokal App Production Analyst Interview Questions and Answers

Lokal App Production Analyst Interview Experiences

1 interview found

(2 Questions)

Interview questions from similar companies

(1 Question)

(1 Question)

(1 Question)

(1 Question)

(2 Questions)

(1 Question)

(2 Questions)

(2 Questions)

(1 Question)

Interview Questionnaire

4 Questions

Interview Preparation Tips

Skills evaluated in this interview

(4 Questions)

Interview Preparation Tips

(1 Question)

Lokal App Interview FAQs

Recently Viewed

Cubastion Consulting

Cubastion Consulting

Engineers India

Engineers India

Sabre

Engineers India

Cubastion Consulting

Cubastion Consulting

Engineers India

Engineers India

Tell us how to improve this page.

Lokal App Interviews By Designations

Interview Questions for Popular Designations

Lokal App Production Analyst Interview Process

Interview Questions from Similar Companies