Upload Button Icon Add office photos
Engaged Employer

i

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

Games24x7 Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Games24x7 Data Analyst Interview Questions and Answers

Updated 8 May 2023

Games24x7 Data Analyst Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
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 - Assignment 

Contained aptitude test with both numericals as well as coding questions

Round 3 - Case Study 

It was a one on one round

Round 4 - HR 

(2 Questions)

  • Q1. Final discussion
  • Q2. If ready to relocate
  • Ans. 

    Yes, I am open to relocation for the right opportunity.

    • I am willing to relocate for a job that aligns with my career goals and offers growth opportunities.

    • I am open to exploring new cities and cultures.

    • I understand that relocation may come with some challenges, but I am prepared to face them.

    • I am excited about the prospect of working with a new team and contributing to the success of the company.

  • Answered by AI

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

DSA Basic and 1 medium level

Round 2 - Group Discussion 

Based on solutions we have written and rest on CV

I applied via Company Website and was interviewed in Dec 2019. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Questions were mostly asked on SQL, Python libraries, Machine learning and Excel, puzzles to solve before interview there was test case study to solve.
  • Q2. What is row number, rank, dense rank? explain partition by, indexing joins, query optimization techniques
  • Ans. 

    Explanation of row number, rank, dense rank, partition by, indexing joins, and query optimization techniques.

    • Row number is a function that assigns a unique number to each row in a result set.

    • Rank is a function that assigns a rank to each row based on the values in a specified column.

    • Dense rank is a function that assigns a rank to each row based on the values in a specified column, but with no gaps in the ranking.

    • Partit...

  • Answered by AI
  • Q3. Real-time examples on data analytics with examples
  • Ans. 

    Real-time examples of data analytics

    • Predictive maintenance in manufacturing

    • Real-time fraud detection in banking

    • Personalized recommendations in e-commerce

    • Real-time traffic analysis for smart cities

    • Real-time health monitoring in medical devices

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What is the difference between Union and Union all ?
  • Ans. 

    Union combines the results of two or more SELECT statements, while Union all includes all rows, including duplicates.

    • Union removes duplicate rows from the result set, while Union all includes all rows.

    • Union sorts the result set, while Union all does not.

    • Union is slower than Union all because it performs a distinct operation.

    • Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

    • Example: SELECT column1 FRO

  • Answered by AI
  • Q2. Which query is more faster , joins or union?
  • Ans. 

    Joins are generally faster than unions.

    • Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.

    • Joins can utilize indexes on the columns being joined, which can improve performance.

    • Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Aristocrat Data Analyst interview:
  • SQL
  • Power BI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
No response

I applied via LinkedIn and was interviewed in Jan 2024. There were 5 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Resume based questions on past experience
  • Q2. Case study based questions
Round 2 - Technical 

(3 Questions)

  • Q1. Resume based questions,
  • Q2. Moderate SQL Coding question
  • Q3. Case study based questions
Round 3 - HR 

(1 Question)

  • Q1. General HR related questions
Round 4 - Behavioral 

(1 Question)

  • Q1. Managerial & Aptitude questions
Round 5 - Behavioral 

(1 Question)

  • Q1. Managerial discussion about role & industry

Data Engineer Interview Questions & Answers

Zupee user image Vaibhav Ashok Tandale

posted on 24 Sep 2023

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
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 

(2 Questions)

  • Q1. How to read parquet and csv file in spark .
  • Ans. 

    To read parquet and csv files in Spark, use SparkSession's read method with appropriate options.

    • Create a SparkSession object

    • Use the read method of SparkSession to read parquet files with .parquet() method

    • Use the read method of SparkSession to read csv files with .csv() method

    • Specify options like header, delimiter, inferSchema, etc. as needed

    • Load the data into a DataFrame for further processing

  • Answered by AI
  • Q2. How to check second highest sallery.
  • Ans. 

    To check the second highest salary, use the SQL query with ORDER BY and LIMIT.

    • Use SQL query with ORDER BY clause to sort salaries in descending order.

    • Use LIMIT 1,1 to select the second highest salary.

    • Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't wait for thing to happen, make things happen, take the initiative to identify and solve peoblem.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Assignment 

Increase rev by 10% with a feature in gane of choice

Round 2 - One-on-one 

(1 Question)

  • Q1. Deconstruct a game, propose how to imporve rev for a product
  • Ans. 

    Deconstructing a game to improve revenue for a product

    • Analyze the game's monetization strategy, including in-app purchases, ads, and subscriptions

    • Identify key metrics such as user retention, average revenue per user, and lifetime value

    • Implement A/B testing to optimize pricing, promotions, and features

    • Leverage data analytics to understand user behavior and preferences

    • Consider partnerships with other apps or brands for c...

  • Answered by AI
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. How would you go about building game economics for a game?
  • Ans. 

    Building game economics involves balancing in-game currency, rewards, and purchases to create a sustainable and engaging experience.

    • Define the in-game currency and its value in relation to real money.

    • Design a reward system that incentivizes player engagement and progression.

    • Implement a balanced pricing strategy for in-game purchases to drive revenue without alienating players.

    • Analyze player behavior and adjust the econ...

  • Answered by AI

Skills evaluated in this interview

I applied via Approached by Company and was interviewed in Feb 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. There is one black king and N number of white knights. You need to find is king under attack and is checkmate?
  • Ans. 

    Check if the black king is under attack and if it is checkmate.

    • Check if any white knight can capture the black king

    • Check if the black king has any legal moves to escape capture

    • If the black king is under attack and has no legal moves, it is checkmate

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Do not expect to go to next round even if you give o(1) solution for the question they ask. They only asked one question in technical round and I provided solution with o(1) time, even though they rejected. Please don't waste time, I think they also don't know how to hire..
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - Coding Test 

Topological Sort based question and it's follow up

Interview Preparation Tips

Interview preparation tips for other job seekers - NA

Games24x7 Interview FAQs

How many rounds are there in Games24x7 Data Analyst interview?
Games24x7 interview process usually has 4 rounds. The most common rounds in the Games24x7 interview process are Resume Shortlist, Assignment and Case Study.
How to prepare for Games24x7 Data 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 Games24x7 . The most common topics and skills that interviewers at Games24x7 expect are Business Analysis, Business Intelligence, Data Analysis, Data Modeling and Data Warehousing.

Tell us how to improve this page.

Games24x7 Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Pole To Win Interview Questions
3.4
 • 57 Interviews
Aristocrat Interview Questions
3.8
 • 45 Interviews
Dream11 Interview Questions
3.8
 • 37 Interviews
Light & Wonder Interview Questions
3.8
 • 29 Interviews
Electronic Arts Interview Questions
4.1
 • 22 Interviews
Zupee Interview Questions
3.7
 • 15 Interviews
View all
Games24x7 Data Analyst Salary
based on 23 salaries
₹10 L/yr - ₹17 L/yr
98% more than the average Data Analyst Salary in India
View more details

Games24x7 Data Analyst Reviews and Ratings

based on 3 reviews

4.1/5

Rating in categories

4.4

Skill development

4.4

Work-life balance

3.7

Salary

4.4

Job security

5.0

Company culture

3.1

Promotions

4.1

Work satisfaction

Explore 3 Reviews and Ratings
Marketing Manager
46 salaries
unlock blur

₹20 L/yr - ₹40 L/yr

Associate Manager Marketing
28 salaries
unlock blur

₹13 L/yr - ₹20.5 L/yr

Deputy Manager Marketing
27 salaries
unlock blur

₹19.3 L/yr - ₹30.5 L/yr

Data Analyst
23 salaries
unlock blur

₹10 L/yr - ₹17 L/yr

Software Developer
22 salaries
unlock blur

₹18 L/yr - ₹30 L/yr

Explore more salaries
Compare Games24x7 with

Pole To Win

3.4
Compare

International Game Technology

3.3
Compare

Ubisoft Entertainment

3.8
Compare

Aristocrat

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview