Interview Questions

Dhruv M. - "During my internship at Econalytica Solutions, I was assigned to help improve internal reporting for the procurement team. The department wanted more dynamic insights but didn’t have the budget for premium BI tools or new software licenses. My task was to enhance reporting and analytics capabilities using only the tools already available, primarily Excel, while still delivering insights that would support decision-making. I got creative by using advanced Excel features like Power Query, pivot ta"See full answer

Sg S. - "Let’s talk about goals first Goals are: Yelp:
1
I assumed that main goal is the revenue from advertising. It PPC advertising so we want more people to click on it.
2 Keep high user engagement level advertisers: want to keep the CR and CPS. Let’s discuss how can we define the appropriate number of ads: We can set up AB testing with different number of ads. We want to see if there is significant revenue increase when we show 1,3,5 ads.
We also want to check the tradeoffs and be sure tha"See full answer

Mark M. - "I don't have experience working with alot of Biological Scientists. Most of my experience comes with Data Scientists. Described how I used ideation techniques like brainstorming and other creative ways to get people to find common ground. I also mentioned how I like to do survey's before meetings to prompt people and also get unbiased opnions"See full answer

Alina G. - "SELECT upsellcampaignid, COUNT(DISTINCT trans.userid) AS eligibleusers FROM campaign JOIN "transaction" AS trans ON transactiondate BETWEEN datestart AND date_end JOIN user ON trans.userid = user.userid WHERE iseligibleforupsellcampaign = 1 GROUP BY upsellcampaignid `"See full answer

Scott S. - "As engineering managers, it’s our obligation to prioritize and manage technical debt properly. However, achieving the correct mix between reducing technical debt and providing new features while meeting deadlines can be fairly tough.To manage technical debt efficiently, it’s vital to first understand how to detect it inside your projects. One way to do this is by doing regular code reviews and encouraging your team to share any concerns or areas where they feel the codebase may be improved. This"See full answer

jainneha - "this answer seems incorrect talking about google assistant and not google fi?"See full answer

Sarabjeet S. - "Clarification: What type of business partners are these, some examples? Why isn't a phone/Google meet sufficient for communication? Any specific countries - abroad? With unlimited resources: Mission - To drive increases in Google's business through partnerships Goal of this project - Enable Sundar to communicate quickly and effectively with partners Product vision - Multi-language simulcast of Sundar's message tailored for individual partners Details: Allow Sundar to relay the same message t"See full answer

SG - "Clarification - Are we referring to HW or SW/experience or overall product? Choose any. Choosing overall product. Are we targeting a particular use case - such as health/commerce/or am I free to choose one? Choose on your own. Any other constraints that I should be aware or? Lastly, does it have to meet both AR and VR, or can we prioritize one at this time? And if so, any concerns with prioritizing one? I am choosing to prioritize AR this point .. and I'll walk you thoroug"See full answer

Partha pratim S. - "You are working on a SaaS product that currently uses Basic Authentication (username/password) for API and application access. The security and compliance teams have mandated moving to a more secure, modern authentication mechanism — OIDC (OpenID Connect). Design the authentication system migration from Basic Authentication to OIDC. Discuss the architecture changes, the migration approach, and the rollout strategy. What are the technical challenges, impacts on customers, backward compatibility"See full answer