Skip to main content

Interview Questions

Review this list of 4,411 interview questions and answers verified by hiring managers and candidates.
  • Intuit logoAsked at Intuit 
    Product Manager
    Product Strategy
  • " 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"

    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

    BizOps & Strategy
    Behavioral
    +1 more
  • Meta logoAsked at Meta 
    Machine Learning Engineer
    System Design
  • +8

    "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"

    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

    Coding
    SQL
  • "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,"

    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

    Technical
  • 🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.

  • Walmart Labs logoAsked at Walmart Labs 
    +1

    "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"

    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

    Product Manager
    Analytical
    +2 more
  • Apple logoAsked at Apple 

    "Code reviews, automated linting, unit tests, integration tests, validation tests"

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

    Software Engineer
    Behavioral
  • Machine Learning Engineer
    Artificial Intelligence
    +2 more
  • +3

    "SELECT AVG(julianday(dateend) - julianday(datestart)) AS avgcampaignduration FROM campaign; `"

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

    Coding
    SQL
  • "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"

    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

    Product Manager
    Behavioral
  • Bloomberg logoAsked at Bloomberg 
    Software Engineer
    Behavioral
  • Remitly logoAsked at Remitly 

    "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. "

    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

    Product Manager
    Behavioral
  • +3

    "-- 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"

    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

    Coding
    SQL
  • "not able to understand the accent of the candidate"

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

    Data Engineer
    Data Modeling
  • BizOps & Strategy
    Behavioral
    +1 more
  • "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?"

    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

    Behavioral
  • "strengths- Working with engineering, working with metrics, execution Weakness- ideation and visioning, working with design"

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

    Product Manager
    Behavioral
  • Salesforce logoAsked at Salesforce 

    "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"

    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

    Product Manager
    Product Design
  • Product Manager
    Analytical
    +1 more
  • Product Manager
    Behavioral
    +1 more
Showing 1781-1800 of 4411