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 2 Interview Questions and Answers

Updated 30 May 2024

Games24x7 Data Analyst 2 Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Assignment 

1 hr SQL assignment. Complete and send it to hr.

Round 2 - Technical 

(2 Questions)

  • Q1. Predictive Analytics and projects
  • Q2. Test and Control

Interview questions from similar companies

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
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
2-4 weeks
Result
No response

I applied via Company Website and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Coding Test 

SQL based leetcode medium and hackerrank

Round 2 - Assignment 

Python take home EDA case study assessment

Data Analyst Interview Questions & Answers

Octro user image Parth Jasathy

posted on 14 Jan 2025

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Different question were asked on sql python java

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

I applied via Campus Placement and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

70 Technical and Aptitude mcqs to solve in 50 minutes

Round 2 - Technical 

(2 Questions)

  • Q1. What is overloading and overriding?
  • Ans. 

    Overloading is having multiple methods with the same name but different parameters. Overriding is implementing a method in a subclass that is already defined in the parent class.

    • Overloading allows a class to have multiple methods with the same name but different parameters.

    • Overriding occurs when a subclass provides a specific implementation of a method that is already provided by its parent class.

    • Overloading is resolve...

  • Answered by AI
  • Q2. What is difference between Primary and unique key in dbms?
  • Ans. 

    Primary key uniquely identifies a record in a table, while unique key ensures all values in a column are distinct.

    • Primary key does not allow NULL values, while unique key allows one NULL value.

    • A table can have only one primary key, but multiple unique keys.

    • Primary key is a combination of unique and not null constraints.

    • Primary key is used to establish relationships between tables, while unique key is used to enforce un

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Octro Data Engineer interview:
  • OOPS
Interview preparation tips for other job seekers - Clear all the basics of things mentioned in resume.

Skills evaluated in this interview

I applied via LinkedIn and was interviewed in Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

8 Questions

  • Q1. What are the products you have worked upon?
  • Q2. What the unique feature you have added to that Product to increase it's efficiency?
  • Ans. 

    Implemented AI-powered recommendation engine to suggest personalized products based on user behavior.

    • Developed machine learning algorithms to analyze user data and suggest relevant products.

    • Implemented user feedback system to continuously improve recommendations.

    • Increased sales by 20% and customer satisfaction by 15%.

    • Reduced manual effort required for product selection and increased efficiency.

  • Answered by AI
  • Q3. What was the one mistake you have made and what you have learned from that ?
  • Q4. What was your biggest achievement?
  • Q5. What's your favourite product and why
  • Q6. How can you improve your favourite product?
  • Ans. 

    I would improve my favorite product by adding more customization options.

    • Add more color options for the product

    • Allow users to choose their preferred font style

    • Include the option to add personalized text or images

    • Provide different sizes or shapes for the product

  • Answered by AI
  • Q7. Why are you looking for a change?
  • Q8. What are the factors on which your performance gets assessed?

Interview Preparation Tips

Interview preparation tips for other job seekers - Improve your communication skills, be confident don't shy to be a bit personal in the interview. Do your homework about the JD and maybe search your interviewer on LinkedIn beforehand to give you an initial advantage. Don't talk about something you don't know like Analytics and tools that you have not worked upon. All the very best.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

DSA, problem solving

Round 2 - Case Study 

System design interview and prior experience in projects

Round 3 - Culture fit 

(2 Questions)

  • Q1. What was the toughest problem you encountered in your previous assignments ?
  • Q2. Given a choice, what would you have done differently in your previous assignments ?
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Three coding online assessments - screening round.

Round 2 - Coding Test 

Two to three coding questions based on dynamic programming.

Round 3 - Technical 

(1 Question)

  • Q1. Resume based and computer network
Round 4 - HR 

(1 Question)

  • Q1. Simple hr question

Interview Preparation Tips

Interview preparation tips for other job seekers - If clear coding is improved, the chances of being selected will increase.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    Experienced Senior Software Engineer with a passion for problem-solving and creating innovative solutions.

    • Over 8 years of experience in software development

    • Proficient in multiple programming languages such as Java, Python, and C++

    • Strong background in designing and implementing scalable systems

    • Led successful projects such as developing a real-time data analytics platform for a Fortune 500 company

  • Answered by AI
  • Q2. About techstacks

Games24x7 Interview FAQs

How many rounds are there in Games24x7 Data Analyst 2 interview?
Games24x7 interview process usually has 2 rounds. The most common rounds in the Games24x7 interview process are Assignment and Technical.
What are the top questions asked in Games24x7 Data Analyst 2 interview?

Some of the top questions asked at the Games24x7 Data Analyst 2 interview -

  1. Predictive Analytics and proje...read more
  2. Test and Cont...read more

Tell us how to improve this page.

Games24x7 Data Analyst 2 Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Pole To Win Interview Questions
3.4
 • 54 Interviews
Aristocrat Interview Questions
3.8
 • 45 Interviews
Dream11 Interview Questions
3.8
 • 36 Interviews
Light & Wonder Interview Questions
3.8
 • 29 Interviews
PurpleTalk Interview Questions
4.0
 • 27 Interviews
Electronic Arts Interview Questions
4.1
 • 22 Interviews
View all
Marketing Manager
46 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Deputy Manager Marketing
27 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Manager Marketing
27 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
23 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analytics Manager
21 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Games24x7 with

Dream11

3.8
Compare

Nazara Technologies

3.0
Compare

Octro

3.3
Compare

Moonfrog Labs

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