WinZO Senior Data Analyst Interview Questions and Answers

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
Add your answer
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...read more
Answered by AI
Add your answer

Q1. Details about the projects in your resume
Add your answer
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
Add your answer
Q3. Mostly questions related to cricket tables which was told to be assumed
Add your answer

Q1. SQL based questions
Add your answer
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
Add your answer

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

Python, Spark, Scala, Terraform

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

Q1. SQL query for root,leaf and other nodes Spark Optimizations Python Coding questions
Add your answer

Q1. About Project,Spark Questions, Optimizations, OOPS Concept. SQL Questions
Add your answer

Cultural discussion and briefing on job description

SQL logic test and pipeline design

Q1. Pretty simple and basic spark, very easy to crack, just be confident
Add your answer
Q2. Project discussion
Add your answer

Q1. Again a simple one, just need to know to basics of big data.
Add your answer

Q1. More on interpersonal skills and behavioral one
Add your answer

Q1. Basic questions around Data Engineering to check ad go through profile
Add your answer
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...read more
Answered by AI
Add your answer

Intermediate level Python and SQL question