Your AI Wingman for your next interview

The most comprehensive bank Interview Answer Review tooling available online.

Behavioral
If you ever made an unpopular decision, tell me about that
Product ManagerSoftware EngineerTechnical Program ManagerBackend Engineer

Interactive Brokers

Deliveroo Logo

Deliveroo

Pendo Logo

Pendo

+6

while reviewing one of the older projects that was currently implemented in the company I noticed that there was no alerting in place if the data pipeline breaks, the data pipeline has never been broken and it never failed for the last 2 years. it was a pipeline where the data would be dropped into an sftp bucket by the customer every hour and then it was moved to an s3 bucket where s3 triggers were implemented to moved the data in to queue. So in case there is an issue with the data not being processed we would only know when the we see a drop in volume. I identified it as a potential issue with the system and worked on a proposal to have monitoring in place so we are notified when there is an error. I worked with the program manager and devised a plan on how to implement the alerting and the time lines as well as the effort that will be needed to implement it. I mapped the impact of not having it to the current goals of the company and then put forward a proposal of implementing the alerts to the business and took their buyins. after getting the buyins I proposed the task to my team and some of the sr devlopers were not too keen on implenting the alerts, I gave the task to some of the Jr devlopers and the alerts were implemented. after the implementation we discovered that for some hrs in a day we werent getting any files so instead of getting 24 files in a day we were getting 20 files a day in an average. This was rectified by talking to the customer and the missing data was solved. but this made the whole team realize the importance of monitoring and alerting. It also bosted the moral of the Jr developers seeing the direct impact they made to the business goals


3 months ago
3 months ago
Product Execution
Describe one metric that you worked on, that hasn't been reached, in the past two years.
Product Manager

Interactive Brokers

Okta Logo

Okta

Bosch Logo

Bosch

I'd like to share a personal anecdote about a time when I failed to reach a metric as a Manager in a Data Engineering project.



Metric: Reduce data ingestion latency to under 10 minutes within 3 months to improve real-time analytics capabilities.



Context: Our team was responsible for building a data pipeline that ingested large volumes of data from various sources into a cloud-based data warehouse. The data was then used to power real-time analytics and reporting for our business stakeholders.



Goal: Our goal was to reduce the data ingestion latency to under 10 minutes to ensure that our analytics capabilities were as close to real-time as possible. This would enable our stakeholders to make informed decisions quickly and respond to changing market conditions.



Plan: Our plan was to optimize the data ingestion process by:



Improving the efficiency of our data processing algorithms

Increasing the scalability of our cloud infrastructure

Implementing a more efficient data storage solution

What went wrong: Despite our best efforts, we were unable to meet the metric. We encountered several issues that slowed us down, including:



Underestimating the complexity of the data processing algorithms, which required more development time than anticipated

Difficulty in scaling our cloud infrastructure due to vendor limitations and cost constraints

Unexpected issues with our data storage solution, which required additional debugging and testing

Impact: Missing this metric had a significant impact on our project. Our stakeholders were not able to get the real-time analytics they needed, which delayed their decision-making and affected our business outcomes.



Lessons learned: This experience taught me several valuable lessons, including:



The importance of robust planning and contingency planning to account for unexpected setbacks

The need for more accurate estimation of development time and resources required for complex tasks

The value of prioritizing and focusing on the most critical components of the project to ensure success

Actions taken: To address these issues, we:



Revised our estimates and created a more realistic project plan

Broke down the task into smaller, more manageable components to improve development efficiency

Implemented additional monitoring and testing to ensure that our data ingestion process was stable and performant

By learning from our mistakes and taking corrective actions, we were able to eventually meet the metric and improve our data ingestion latency to under 10 minutes.



3 months ago
Behavioral
Let me know about the time you failed in your efforts to achieve something.
Product ManagerBackend EngineerSoftware EngineerTechnical Program Manager

Interactive Brokers

Okta Logo

Okta

Stitch Fix Logo

Stitch Fix

8 months ago

Showing 1 to 10 of 112 results

*All interview questions are submitted by recent Interactive Brokers Product Manager candidates, labelled and categorized by Prepfully, and then published after being verified by Product Managers at Interactive Brokers.