Upload Button Icon Add office photos
Engaged Employer

i

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

WinZO Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

WinZO Senior Data Analyst Interview Questions and Answers

Updated 6 Jun 2024

WinZO Senior Data Analyst Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Dec 2023. There was 1 interview round.

Round 1 - Coding Test 

Intermediate SQL Topics - Window Function, Subquery, Joins

Tables:
registration (userid string, regdate date);
txn(txndate date, userid string, amt int, game string);

1. Write a query to get proportion of users who have played a game within 2 days of registration
2. Find the most money spent on a game for each user
3. Get the list of users who played poker but not ludo

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice SQL questions before interview

Interview questions from similar companies

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

I applied via LinkedIn and was interviewed in Dec 2024. There were 2 interview rounds.

Round 1 - Assignment 

Based on my CV, they assigned me a task related to data migration.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Project reviews
  • Q2. Attendance regarding
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Write a sql query
  • Ans. 

    SQL query to retrieve employee names and their salaries from a table

    • Use SELECT statement to retrieve data

    • Specify the columns you want to retrieve (employee names and salaries)

    • Specify the table name where the data is stored

  • Answered by AI
  • Q2. Formula of vlookup
  • Ans. 

    VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value.

    • VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.

    • The formula syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

    • Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 and return the...

  • Answered by AI

Skills evaluated in this interview

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

I applied via Recruitment Consulltant and was interviewed in Dec 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 

(3 Questions)

  • Q1. Details about the projects in your resume
  • Q2. MYSQL codes in window function
  • Ans. 

    MYSQL window functions allow for calculations across rows in a result set.

    • Window functions are used to perform calculations across rows in a result set

    • They are used with the OVER() clause

    • Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()

    • They can be used to calculate running totals, moving averages, and more

  • Answered by AI
  • Q3. Mostly questions related to cricket tables which was told to be assumed

Interview Preparation Tips

Interview preparation tips for other job seekers - Disappointing experience
Interviewer was a young girl she didn't gave any data or material.
Everything was assumption assume tables and she asked me to code in paper
never had such experience.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL based questions
  • Q2. Guesstimate on estimating # users on the application
  • Ans. 

    Estimate the number of users on the application based on market research, user demographics, and industry trends.

    • Consider the total addressable market (TAM) for the application

    • Analyze user demographics and behavior to estimate adoption rate

    • Look at industry benchmarks and competitor data for reference

    • Use surveys, focus groups, and user feedback to gather insights

    • Consider factors like market saturation, growth potential,

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

I applied via Recruitment Consulltant and was interviewed before Jan 2022. There were 4 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 - Coding Test 

Coding skills in Python, Spark/Scala are a must.

Round 3 - Coding Test 

Python, Spark, Scala, Terraform

Round 4 - One-on-one 

(2 Questions)

  • Q1. Why are you changing the job
  • Q2. What is your strong suite

Interview Preparation Tips

Interview preparation tips for other job seekers - Coding skills are a must. Cannot survive without that.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

I applied via Job Fair and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL query for root,leaf and other nodes Spark Optimizations Python Coding questions
Round 2 - Technical 

(1 Question)

  • Q1. About Project,Spark Questions, Optimizations, OOPS Concept. SQL Questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Jul 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all Resume tips
Round 2 - Aptitude Test 

Cultural discussion and briefing on job description

Round 3 - Coding Test 

SQL logic test and pipeline design

Interview Preparation Tips

Topics to prepare for Koantek Senior Data Engineer interview:
  • SQL
  • ETL
Interview preparation tips for other job seekers - Just be honest on what you know and what you have been doing. If you don't know what you are asked to answer, don't pretend to know but be frank on answering.
Interview experience
3
Average
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. Pretty simple and basic spark, very easy to crack, just be confident
  • Q2. Project discussion
Round 2 - Technical 

(1 Question)

  • Q1. Again a simple one, just need to know to basics of big data.
Round 3 - Behavioral 

(1 Question)

  • Q1. More on interpersonal skills and behavioral one
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - HR 

(2 Questions)

  • Q1. Basic questions around Data Engineering to check ad go through profile
  • Q2. Basic working of spark
  • Ans. 

    Spark is a distributed computing framework that provides an interface for programming entire clusters with implicit data parallelism and fault tolerance.

    • Spark is designed for speed and ease of use in data processing.

    • It can run programs up to 100x faster than Hadoop MapReduce in memory, or 10x faster on disk.

    • Spark provides high-level APIs in Java, Scala, Python, and R.

    • It supports a wide range of data processing tasks, i...

  • Answered by AI
Round 2 - Coding Test 

Intermediate level Python and SQL question

Skills evaluated in this interview

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

WinZO Interview FAQs

How many rounds are there in WinZO Senior Data Analyst interview?
WinZO interview process usually has 1 rounds. The most common rounds in the WinZO interview process are Coding Test.

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

INTERVIEWS

Smarter BIZ Technologies

No Interviews

INTERVIEWS

Fidelity Investments

No Interviews

DESIGNATION

REVIEWS

Corizo

No Reviews

INTERVIEWS

Plada Infotech Services

No Interviews

INTERVIEWS

Movate

No Interviews

INTERVIEWS

ShareChat

No Interviews

INTERVIEWS

TCS iON

No Interviews

Tell us how to improve this page.

WinZO Senior Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Dream11 Interview Questions
3.8
 • 36 Interviews
NexTurn Interview Questions
4.2
 • 26 Interviews
Bonami Software Interview Questions
4.1
 • 21 Interviews
Koantek Interview Questions
3.4
 • 17 Interviews
Ivanti Interview Questions
3.6
 • 14 Interviews
TestVagrant Interview Questions
3.4
 • 13 Interviews
SentientGeeks Interview Questions
4.6
 • 13 Interviews
View all
Product Manager
16 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

QA Engineer
8 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Graphic Designer
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare WinZO with

Mpl

Compare

Dream11

3.8
Compare

Mobile Premier League

3.4
Compare

Rummy Circle

4.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent