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

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
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
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
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 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
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Mar 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Aptitude Test 

The aptitude test was not that difficult.

Round 3 - Coding Test 

The coding test was of moderate difficulty

Interview Preparation Tips

Topics to prepare for Koantek Senior Data Engineer interview:
  • SQL
  • Python
Interview preparation tips for other job seekers - Study the data related concepts of SQL and python thoroughly to get this job.
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
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Machine Learning
Round 2 - Technical 

(1 Question)

  • Q1. Machine Learning
Round 3 - Case Study 

Approach check for multiple case studies

Interview Preparation Tips

Interview preparation tips for other job seekers - Never received the final response after the 3rd round which was with the CTO. The HR kept saying we are yet to get the feedback.
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 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
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 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.

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.

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