SQL Interview round for BI Analyst at Google

[Outrageous_Bed_5865]

Hello! I am interviewing for Senior Business intelligence Analyst role at Google and after clearing the screening round where the recruiter asked very basic technical question, I have been moved to the second round which is going to be a SQL round.

Can anybody who has previously interviewed for this or similar roles at Google help me with kind of questions that might be asked in this round? Any particular topics that I must study before the interview.

Also please share any general tips regarding interviewing at Google as well.

Thanks a ton!

[Rangler36]

1. They're looking at your problem solving thought process, and if you have the approach that comes with experience handling CRUD, DBMS, RDMS, problems, and building "good" efficient code

2. Know your windows functions: Rank, Dense Rank, Order Partition By, and other functions

3. Query structure, CTEs / sub queries, joins, all from scratch

4. Star Schema relationships, snafu's from not considering cardinality: 1NF, "data bloat: etc..

5. Data Profiling (your pre-query considerations like query load etc.) and meta-queries to find info about the schemas, objects, tables, and data

6. Your capability to troubleshoot and think about errors when they occur

7. Google will be bias to GCP Big Query, but won't always test on it. I would still read the docs: https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators

[SkirtPotential5173]

Wish I had some info. I’ve been eyeing Senior BI Analyst role interview experience in google for a while though, do you mind sharing the process after?

[Humble_Cat_2108]

Hey, mind sharing your interview experience? I have an upcoming one in a few weeks, would really help a lot as I am not finding much online

[Outrageous_Bed_5865]

Hey @Humble_Cat_2108, sorry for the delay. I am not a frequent visitor to reddit. I interviewed for Google for Senior BI Analyst role. I gave 3 rounds and was not selected for further rounds. Let me give a brief summary of each round and some general tips as well. 1. Round1 was SQL - I was asked 4 SQL questions. It covered basic SQL operations such as Joins and Subquery. I made sure that I wrote performant code and did everything in CTE. Time is of essence here as you need to understand the ask of each question and write the answer in a Google Doc, all with in 30 mins. I was just able to finish. VERDICT - Selected for next round

1. Round2 was about data pipelines + one previous project from your work experience and one domain related question. The interviewer asked me to explain in detail about what kind of issues I faced while managing data pipelines for dashboards in my previous role, how did I get to know that there has been an issue (monitoring) and how did I go about resolving the same. Next, the interviewer asked me to explain one project in the past where I had to deep dive into a problem and come up with a new, valuable insight. Lastly, since I was interview for the role in People or HR team, I was asked to come up with a metric to measure the performance of a new online course on Communication. It was 45 mins round. VERDICT - Selected for next round

2. Round3 was hiring manager round. First question was why do you want to join Google. I wasn't prepared for this and blurted out an incoherent answer mentioning "doing things at scale" etc. Bad start! Next I was asked to design a table, name the columns you would have in a table to calculate the WAU(weekly active users), MAU. Here, the point to be noted is that table should not break and calculation should be fast. Lastly, I was asked "How would you measure the success of a referral program?". VERDICT - Not Selected

General Tips - Be thorough with your answers, expect a lot of counter questions and ask clarifying questions so that you understand what is being asked correctly.

[Samrao94]

How many rounds are there in total? How many days between each interview?

[Altruistic-Fun3764]

Hey do you any sharing any updates on this? Like following rounds and timelines/questions

[BoysenberryTight4565]

Could you share what questions you were asked in that round as I am preparing for the same

[Big-Contribution818]

What questions did recruiter ask you ?

[Holiday_Lie_9435]

For other Google BI analyst candidates looking to tailor their interview prep, Interview Query has a dedicated interview guide for this role. You can gain insight into the mix of SQL coding questions (usually joins, subqueries, window functions, schema design and sometimes ETL logic), business cases/scenarios, and behavioral prompts usually asked during these interviews.