Skip to contentSkip to footer

Software Engineer Google Interview Questions

Salaries
Interviews

711 software engineer google interview questions shared by candidates

Q1) Let's assume we have a master table and transaction table. How would you join those tables, inner join or left (right join)? And why? --> he did not give me any details about what data we have and what he wants to know. it really depends on purpose & situation in reality. I asked him of more details about situations, but his explanation was still very ambiguous. Nobody can answer this kind of questions clearly. He should've questioned like "I'd like to compute the sum of revenues by segmenting gender and age. We have a customer master table and transaction table. How would you join those tables? What are the outputs of inner join or left join?" Q2) What is "Index" in database? --> very useless, unpractical and broad question, but I did my best. Q3) Can you explain a columnar database? --> I have no experience using a columnar database, but I tried to explain what I know about it. However, this question has nothing to do with my experience! So, it's actually impossible to answer questions clearly. Data science is very broad field, so nobody knows everything. His technical questions should've been on my experience and projects. If not, job description should've mentioned what specific knowledge they are looking for.
avatar

Google Customer Engineer

Interviewed at Google

4.4★
Sep 21, 2021

Q1) Let's assume we have a master table and transaction table. How would you join those tables, inner join or left (right join)? And why? --> he did not give me any details about what data we have and what he wants to know. it really depends on purpose & situation in reality. I asked him of more details about situations, but his explanation was still very ambiguous. Nobody can answer this kind of questions clearly. He should've questioned like "I'd like to compute the sum of revenues by segmenting gender and age. We have a customer master table and transaction table. How would you join those tables? What are the outputs of inner join or left join?" Q2) What is "Index" in database? --> very useless, unpractical and broad question, but I did my best. Q3) Can you explain a columnar database? --> I have no experience using a columnar database, but I tried to explain what I know about it. However, this question has nothing to do with my experience! So, it's actually impossible to answer questions clearly. Data science is very broad field, so nobody knows everything. His technical questions should've been on my experience and projects. If not, job description should've mentioned what specific knowledge they are looking for.

Viewing 171 - 180 interview questions

Glassdoor has 711 interview questions and reports from Software engineer google interviews. Prepare for your interview. Get hired. Love your job.