Interview Questions

Scott S. - " Situation Our data engineering team was tasked with developing a new real-time analytics platform for derivatives trading. To ensure the project’s success, we needed buy-in and support from various non-technical teams, including finance, compliance, and senior management. These teams needed to understand the importance of the project, the resources required, and how it would benefit the organization. Task My task was to effectively communicate the technical requirements and benefits of"See full answer

Jessica C. - "select customer_id, order_date, orderid as earliestorder_id from ( select customer_id, order_date, order_id, rownumber() over (partition by customerid, orderdate order by orderdate) as orderrankper_customer from orders ) sub_table where orderrankper_customer=1 order by orderdate, customerid; Standard solution assumed that the orderid indicates which order comes in first. However this is not always the case, and sometime orderid can be random number withou"See full answer

Surbhi G. - "While serverless computing has its merits due to removing the need for server management and auto-scaling abilities, several challenges might arise when deploying machine learning models using this setup. Cold-start latency is a key issue where an Amazon Lambda function, for example, would take more time than usual to run after being idle. This could affect the performance of real-time ML applications negatively. A way to keep the functions warm might be required to avoid this latency. Moreover,"See full answer

Shashi R. - "How do you define Retention? Let’s assume a user comes back tomorrow and scroll for a 10s or so Do we mean to improve the daily retention or weekly/monthly retention? Take a call I think we should look at the weekly retention as checking LinkedIn daily could be a cumbersome task for some and daily retention data may have frequent fluctuations due to several reasons such as professionals are too busy to check LinkedIn on a daily basis Has retention dropped recently, or do we just need to"See full answer

Anonymous Jaguar - "Code reviews, automated linting, unit tests, integration tests, validation tests"See full answer

Salome L. - "SELECT AVG(julianday(dateend) - julianday(datestart)) AS avgcampaignduration FROM campaign; `"See full answer

Joohi M. - "Drew a framework - Where are we - do competitive analysis of the company Where do we want to go - Align business strategy with product strategy What can we do in the given roadmap - prioritize solutions"See full answer

Sergio C. - "There are many places where you can gather feedback. We can divide the feedback from external and internal sources External sources: facebook twitter reddit G2. Internal sources: on-app surveys or chats support Support engineers Sellers Recordings or notes from other PMs However, you always have to talk with the customers so customer interviews are very important. "See full answer

Alexey T. - "-- The text of the task is a bit confusing. If the status is repeated several -- times, then in the end you should show as start_date the date of the first -- occurrence, and in end_date the date of the last occurrence of this status, -- and not the date of the beginning of the next status with t1 as (select order_id, status, orderdate as startdate, lead(orderdate) over (partition by orderid order by orderdate) as enddate, ifnull(lag(status) over (partition by order_id order by or"See full answer

Akash A. - "not able to understand the accent of the candidate"See full answer

Vivek S. - "Hey team, the title says a "GTM campaign" whereas the video is about "favorite marketing campaign" example. Are they supposed to be the same? If not, can you please fix it?"See full answer

George A. - "strengths- Working with engineering, working with metrics, execution Weakness- ideation and visioning, working with design"See full answer

Sandeep B. - "This is my first attempt. Requesting feedback - Design a bookshelf for the users. I would like to create a framework to solve this problem and follow it. It will have the below sections - Goals User Persona Use Cases Pain Points Features Prioritization Metrics Few clarifying questions - What is the objective of doing this? (User engagement, matching a product that a competition has just launched) What type of industry we are in? (Are we a furniture design company, ar"See full answer