i
Games24x7
Filter interviews by
Contained aptitude test with both numericals as well as coding questions
It was a one on one round
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.
DSA Basic and 1 medium level
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.
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...
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
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
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
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 ...
I applied via LinkedIn and was interviewed in Jan 2024. There were 5 interview rounds.
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
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
Increase rev by 10% with a feature in gane of choice
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...
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...
posted on 1 Mar 2022
I applied via Approached by Company and was interviewed in Feb 2022. There was 1 interview round.
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
posted on 7 Oct 2024
I applied via Approached by Company and was interviewed before Oct 2023. There was 1 interview round.
Topological Sort based question and it's follow up
based on 1 interview
Interview experience
based on 3 reviews
Rating in categories
Marketing Manager
46
salaries
| ₹20 L/yr - ₹40 L/yr |
Associate Manager Marketing
28
salaries
| ₹13 L/yr - ₹20.5 L/yr |
Deputy Manager Marketing
27
salaries
| ₹19.3 L/yr - ₹30.5 L/yr |
Data Analyst
23
salaries
| ₹10 L/yr - ₹17 L/yr |
Software Developer
22
salaries
| ₹18 L/yr - ₹30 L/yr |
Pole To Win
International Game Technology
Ubisoft Entertainment
Aristocrat