Gameskraft Senior Business Analyst Interview Questions and Answers

DSA, problem solving

System design interview and prior experience in projects

Q1. What was the toughest problem you encountered in your previous assignments ?
Add your answer
Q2. Given a choice, what would you have done differently in your previous assignments ?
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. 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
Add your answer
Q2. About techstacks
Add your answer

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. 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

Q1. Nth Greatest Element III (Leetcode)
Ans. 
Find the Nth greatest element in an array without sorting
• Use a priority queue to keep track of the N greatest elements

• Iterate through the array and add elements to the priority queue

• Return the top element from the priority queue as the Nth greatest element
Answered by AI
Add your answer
Q2. Heater Problem (Leetcode)
Ans. 
Heater Problem - Find minimum radius to cover all houses with heaters
• Sort the houses and heaters arrays

• For each house, find the closest heater using binary search

• Calculate the minimum radius needed to cover all houses
Answered by AI
Add your answer

A SQL test with 5 questions in increasing order of difficulty

Q1. Results on joining two tables with different join conditions
Add your answer
Q2. Question on windows functions
Add your answer

Q1. Strength and weakeness
Add your answer
Q2. Where do you see yourself in 5 years
Ans. 
In 5 years, I see myself as a senior data analyst leading a team of analysts, implementing advanced analytics techniques, and contributing to strategic decision-making.
• Leading a team of analysts

• Implementing advanced analytics techniques

• Contributing to strategic decision-making
Answered by AI
Add your answer