Google Operations Center Business Intelligence Analyst and Tableau Developer Interview Questions and Answers for Freshers

Data structure and Algorithm problems.

It was 7 questions in which 5 were MCQ which had SQL etc
2 coding questions of medium level

Q1. 2 questions were asked. Both were coding questions and it was purely a coding round. Word problem based questions.
Add your answer

I was asked two problem solving question and i was able to code both problem with multiple approaches.
Also i was asked two technical question, in which i was able to answer one question. even then, i was not shortlisted for next round.

Hellbound test are not required to select 1 employee

Q1. Why r u here
Ans. 
I am here because I am passionate about analyzing data and providing valuable insights to drive decision-making.
• Passionate about data analysis

• Enjoy providing valuable insights

• Driven to help make informed decisions
Answered by AI
Add your answer
Q2. Tell me about something
Ans. 
I will tell you about my experience volunteering at a local animal shelter.
• Volunteered at local animal shelter for 6 months

• Assisted with feeding, cleaning, and socializing with animals

• Helped organize adoption events and fundraisers
Answered by AI
Add your answer

Q1. Unique Paths (2d-dp)
Add your answer
Q2. Flip any rows or columns at any time to make the sum of gird cells ofa provided square in a matrix should be minimum
Ans. 
To minimize the sum of grid cells in a square matrix, flip rows or columns as needed.
• Identify the rows or columns with the highest values and consider flipping them to reduce the sum

• Try different combinations of flipping rows and columns to find the minimum sum

• Consider using dynamic programming or backtracking to efficiently explore all possible combinations
Answered by AI
Add your answer

Q1. Tell me abt ur self
Add your answer
Q2. Ur education back ground
Add your answer
Q3. View and M> view
Add your answer

Preparing media plan for app campaign at a certain budget and expected installs first orders etc

Q1. Guessestimate and general mathematical aptitude
Add your answer
Q2. No of petrol pumps in city
Ans. 
The number of petrol pumps in the city is not available.
• I do not have access to the data on the number of petrol pumps in the city.

• It would be best to consult the city's government or relevant authorities for this information.

• Alternatively, one could conduct a survey or research to estimate the number of petrol pumps in the city.
Answered by AI
Add your answer
Q3. How would you optimize the campaigns in terms of bids budgets
Ans. 
Optimizing bids and budgets involves analyzing data, setting goals, and adjusting strategies accordingly.
• Analyze campaign data to identify top-performing keywords and adjust bids accordingly

• Set clear goals for each campaign and allocate budgets accordingly

• Regularly monitor and adjust bids and budgets based on performance data

• Consider using automated bidding strategies to save time and improve efficiency

• Use A/B testing ...read more
Answered by AI
Add your answer

Q1. Why do you want to join meesho
Add your answer
Q2. Basics of Digital marketing CPM CTR CPC difference
Add your answer

Q1. Find the missing smallest positive integer
Ans. 
Find the missing smallest positive integer in an array of integers
• Sort the array to easily identify missing integers

• Iterate through the sorted array to find the smallest missing positive integer

• Return the missing integer
Answered by AI
Add your answer
Q2. Given an array of 0,1,2, Sort the array
Ans. 
Sort an array of strings containing only 0, 1, and 2.
• Use a three-way partitioning algorithm like Dutch National Flag algorithm to sort the array in a single pass.

• Keep track of three pointers - low, mid, and high to partition the array into three sections.

• Swap elements based on their values to achieve the sorted array.
Answered by AI
Add your answer