"Situation: While in the middle of a migration project, which required rewrite of services of my product into a cloud infra., we needed to configure our rules management services onto cloud as per legacy platform. The data extract of all the rules from legacy platform in a csv file needed heavy formatting to be usable for configuration of the new service. My entire engineering capacity was allocated on other prioritized ongoing feature migration and I had no bandwidth left in the ongoing spri"
Geetesh T. - "Situation: While in the middle of a migration project, which required rewrite of services of my product into a cloud infra., we needed to configure our rules management services onto cloud as per legacy platform. The data extract of all the rules from legacy platform in a csv file needed heavy formatting to be usable for configuration of the new service. My entire engineering capacity was allocated on other prioritized ongoing feature migration and I had no bandwidth left in the ongoing spri"See full answer
"Here's some thought on what I'll be doing in this situation:
Identify the root cause (I'll try to assess WHY the engineers don't action these tickets). In order to identify the potential reasons, I'd have 1:1s with team members, observe participation and engagement in backlog grooming sessions and check in with leads and my peers.
Lack of clarity on requirements or acceptance criteria.
Skill gaps.
Dependency on other teams or missing prerequisites.
Team capaci"
Anonymous Dingo - "Here's some thought on what I'll be doing in this situation:
Identify the root cause (I'll try to assess WHY the engineers don't action these tickets). In order to identify the potential reasons, I'd have 1:1s with team members, observe participation and engagement in backlog grooming sessions and check in with leads and my peers.
Lack of clarity on requirements or acceptance criteria.
Skill gaps.
Dependency on other teams or missing prerequisites.
Team capaci"See full answer
"Applying the STAR method to explain a time when I had to teach myself certain skills to meet project demands.
Situation : I was working for a medical devices company that didn't have CI-CD setup for its embedded software
Task : Build the entire CI-CD pipeline from scratch using the tools available within a month
Action : I had to learn Docker and other basic DevOps technologies to build this
Result : We were able to reduce build time by 70% and create a process for package manage"
Soutrik M. - "Applying the STAR method to explain a time when I had to teach myself certain skills to meet project demands.
Situation : I was working for a medical devices company that didn't have CI-CD setup for its embedded software
Task : Build the entire CI-CD pipeline from scratch using the tools available within a month
Action : I had to learn Docker and other basic DevOps technologies to build this
Result : We were able to reduce build time by 70% and create a process for package manage"See full answer
Product Manager
Behavioral
🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.
"First, I’d want to clarify what’s driving the lack of adoption.
I’d ask:What does “unclear roadmap” mean? Is this an internal issue where we’re not addressing customer pain points, or is it a matter of customers not understanding how to use the product?
Is this feedback coming from all enterprise customers across verticals, or is it isolated to a specific group?
How long has this been going on? Has it been over a quarter?
Assuming this is a widespread issue impacting all customers"
Noe L. - "First, I’d want to clarify what’s driving the lack of adoption.
I’d ask:What does “unclear roadmap” mean? Is this an internal issue where we’re not addressing customer pain points, or is it a matter of customers not understanding how to use the product?
Is this feedback coming from all enterprise customers across verticals, or is it isolated to a specific group?
How long has this been going on? Has it been over a quarter?
Assuming this is a widespread issue impacting all customers"See full answer
"Clarifications:
Which aspect of birthday are we thinking about designing a product for? Birthday reminder, birthday planning, event management or birthday wishing?-
People are generally reminded of their birthdays by their friends/family, social media, their own self awareness, so its not a critical problem to solve
Social apps like FB have birthday wishing features for the larger audience & for wishing friends/family, people would generally call or wish in person
Manag"
Debajyoti B. - "Clarifications:
Which aspect of birthday are we thinking about designing a product for? Birthday reminder, birthday planning, event management or birthday wishing?-
People are generally reminded of their birthdays by their friends/family, social media, their own self awareness, so its not a critical problem to solve
Social apps like FB have birthday wishing features for the larger audience & for wishing friends/family, people would generally call or wish in person
Manag"See full answer
"My weakness was stage fright and talking in front of a large audience. This TPM role does offer me an opportunity to do both but not at the scale at which impacts my day to day role. Also over many years I have taken remedial action e.g. joined a Toast Masters club to overcome my weakness."
Anonymous Mollusk - "My weakness was stage fright and talking in front of a large audience. This TPM role does offer me an opportunity to do both but not at the scale at which impacts my day to day role. Also over many years I have taken remedial action e.g. joined a Toast Masters club to overcome my weakness."See full answer
"No Interoperability between Digital Wallet Payments ?
User Pain Points:
Lack of Interoperability: Digital wallets operate in silos, forcing users to rely on inefficient workarounds, such as transferring funds to a bank account and then to another wallet, resulting in delays and extra effort.
Time-Consuming Process: Current methods to move money between wallets are tedious, often taking 1-3 business days, which can be especially inconvenient for time-sensitive transactions.
High Friction fo"
Pradeep V. - "No Interoperability between Digital Wallet Payments ?
User Pain Points:
Lack of Interoperability: Digital wallets operate in silos, forcing users to rely on inefficient workarounds, such as transferring funds to a bank account and then to another wallet, resulting in delays and extra effort.
Time-Consuming Process: Current methods to move money between wallets are tedious, often taking 1-3 business days, which can be especially inconvenient for time-sensitive transactions.
High Friction fo"See full answer
"SELECT
s.Sale_Date,
SUM(si.Quantity * si.SalePrice) AS TotalRevenue
FROM Sales s
JOIN SaleItems si ON s.SaleID = si.Sale_ID
GROUP BY s.Sale_Date
ORDER BY s.Sale_Date;
"
Bala G. - "SELECT
s.Sale_Date,
SUM(si.Quantity * si.SalePrice) AS TotalRevenue
FROM Sales s
JOIN SaleItems si ON s.SaleID = si.Sale_ID
GROUP BY s.Sale_Date
ORDER BY s.Sale_Date;
"See full answer
"Explained the charts with using
Scatter Plot with Size and Color Encoding
X-axis: Ride duration (in minutes).
Y-axis: Total fare (in dollars).
Point size: Encodes the star rating (e.g., larger points for higher ratings).
Point color: Indicates whether the rating is favorable (green) or unfavorable (red).
Heatmap for Correlation Analysis
Why: Heatmaps are ideal for quickly identifying patterns and correlations between variables.
How:
Create a heatmap matrix where rows represent ride durat"
Saisandeep M. - "Explained the charts with using
Scatter Plot with Size and Color Encoding
X-axis: Ride duration (in minutes).
Y-axis: Total fare (in dollars).
Point size: Encodes the star rating (e.g., larger points for higher ratings).
Point color: Indicates whether the rating is favorable (green) or unfavorable (red).
Heatmap for Correlation Analysis
Why: Heatmaps are ideal for quickly identifying patterns and correlations between variables.
How:
Create a heatmap matrix where rows represent ride durat"See full answer
"after completing my project, I asked my manager for feedback on my performance. My aim was to identify areas for improvement, and learn more about new technologies which are in the"
Sugrim S. - "after completing my project, I asked my manager for feedback on my performance. My aim was to identify areas for improvement, and learn more about new technologies which are in the"See full answer
"BETWEEN and HAVING clauses in SQL serve different purposes:
1. BETWEEN Clause
Used to filter rows based on a range of values.
Works with numeric, date, or text values.
Can be used with WHERE or HAVING clauses.
The range includes both lower and upper bounds.
Example: Filtering employees with salaries between 30,000 and 50,000
`SELECT * FROM Employees
WHERE salary BETWEEN 30000 AND 50000;`
2. HAVING Clause
Used to filter **groups"
Meenakshi D. - "BETWEEN and HAVING clauses in SQL serve different purposes:
1. BETWEEN Clause
Used to filter rows based on a range of values.
Works with numeric, date, or text values.
Can be used with WHERE or HAVING clauses.
The range includes both lower and upper bounds.
Example: Filtering employees with salaries between 30,000 and 50,000
`SELECT * FROM Employees
WHERE salary BETWEEN 30000 AND 50000;`
2. HAVING Clause
Used to filter **groups"See full answer
"System Components
Data Collection Layer
Posts with hashtags are asynchronously sent to Kafka topics
Each message contains: hashtag, timestamp, userid, postid
Multiple Kafka partitions ensure scalability and fault tolerance
Processing Layer
Apache Flink processes streams in real-time
Implements sliding window aggregation (1hr, 24hr, 7d windows)
Calculates topic popularity using weighted metrics:
Post count
User engagement (likes, comments)
Unique user"
Usman B. - "System Components
Data Collection Layer
Posts with hashtags are asynchronously sent to Kafka topics
Each message contains: hashtag, timestamp, userid, postid
Multiple Kafka partitions ensure scalability and fault tolerance
Processing Layer
Apache Flink processes streams in real-time
Implements sliding window aggregation (1hr, 24hr, 7d windows)
Calculates topic popularity using weighted metrics:
Post count
User engagement (likes, comments)
Unique user"See full answer