"There are way more learning opportunities for us here if we acknowledge that this was not a good example and provide tips on how to improve the answer. All the answers here are superficial and it is clear that the interviewee was unprepared.
.
The mention of quote "a wise man told me..." (instead of getting to his own personal points) and some lack of confidence with the metrics portion are red flags.
.
For more concrete example, it is hard to believe that no one wants to fix the slow build proc"
Danny - "There are way more learning opportunities for us here if we acknowledge that this was not a good example and provide tips on how to improve the answer. All the answers here are superficial and it is clear that the interviewee was unprepared.
.
The mention of quote "a wise man told me..." (instead of getting to his own personal points) and some lack of confidence with the metrics portion are red flags.
.
For more concrete example, it is hard to believe that no one wants to fix the slow build proc"See full answer
"I recently led the development and implementation of a data analytics platform tailored for credit unions and mortgage companies, which was suffering from fragmented systems, inconsistent data fields across LOS platforms, and outdated reporting practices. Here's how I managed the full lifecycle:
✅ Initiation / Discovery
Conducted executive interviews across five financial institutions to understand reporting and visibility gaps.
Shadowed loan officers and underwriters"
Simran S. - "I recently led the development and implementation of a data analytics platform tailored for credit unions and mortgage companies, which was suffering from fragmented systems, inconsistent data fields across LOS platforms, and outdated reporting practices. Here's how I managed the full lifecycle:
✅ Initiation / Discovery
Conducted executive interviews across five financial institutions to understand reporting and visibility gaps.
Shadowed loan officers and underwriters"See full answer
"Step 1: Clarifying the Problem Scope
We will focus on designing the leaderboard for Dream11 with these assumptions:
Registered teams: 100,000 users are actively participating and ranked.
Real-time updates: Leaderboard updates frequently as players accumulate points based on live sports events.
Multiple leagues: Each user can participate in different leagues, so we will need to maintain a separate leaderboard for each league.
Query efficiency: Users frequently"
Ramendra S. - "Step 1: Clarifying the Problem Scope
We will focus on designing the leaderboard for Dream11 with these assumptions:
Registered teams: 100,000 users are actively participating and ranked.
Real-time updates: Leaderboard updates frequently as players accumulate points based on live sports events.
Multiple leagues: Each user can participate in different leagues, so we will need to maintain a separate leaderboard for each league.
Query efficiency: Users frequently"See full answer
"The interviewer was interested how the system design would be for files, directories, symbolic links.
After proposing my idea, I was asked to print all files for a given path."
B. T. - "The interviewer was interested how the system design would be for files, directories, symbolic links.
After proposing my idea, I was asked to print all files for a given path."See full answer
"Best practices for prioritizing customer service requests
Prioritizing support requests is a key part of creating a customer journey optimized for maximum revenue. If you want to start using a ticket prioritization process that will boost both customer satisfaction and your bottom line, we've got nine proven best practices below:
Respond to your most loyal customers first
Tag repeat customers as high-priority tickets
Automate simple requests wherever possible
Mark tickets with urg"
Hayatu H. - "Best practices for prioritizing customer service requests
Prioritizing support requests is a key part of creating a customer journey optimized for maximum revenue. If you want to start using a ticket prioritization process that will boost both customer satisfaction and your bottom line, we've got nine proven best practices below:
Respond to your most loyal customers first
Tag repeat customers as high-priority tickets
Automate simple requests wherever possible
Mark tickets with urg"See full answer
"I firstly discuss the brute force approach in O(n^2) time complexity , than i moved to O(nlogn) tine complexity than i discussed the O(n) time complexity and O(n) space complexity . But interviewer want more optimised solution , in O(n) time complexity without using extra space ,
The solution wants O(1) space complexity i have to do changes in same array without using any space . This method is something like i have to place positive values to its original position by swapping and rest negativ"
Anni P. - "I firstly discuss the brute force approach in O(n^2) time complexity , than i moved to O(nlogn) tine complexity than i discussed the O(n) time complexity and O(n) space complexity . But interviewer want more optimised solution , in O(n) time complexity without using extra space ,
The solution wants O(1) space complexity i have to do changes in same array without using any space . This method is something like i have to place positive values to its original position by swapping and rest negativ"See full answer
"This is the answer I have prepared. Please let me know your comments and how I can improve the answer.
I have worked on many process improvement initiatives and projects. I want to share an initiative that I led and delivered while at my previous employer. It had a great impact on over 60 programs and projects across teams in six different countries. Analysts and program managers used to generate a monthly program performance report that deals with all aspects, including schedule, risks, costs"
Balaji G. - "This is the answer I have prepared. Please let me know your comments and how I can improve the answer.
I have worked on many process improvement initiatives and projects. I want to share an initiative that I led and delivered while at my previous employer. It had a great impact on over 60 programs and projects across teams in six different countries. Analysts and program managers used to generate a monthly program performance report that deals with all aspects, including schedule, risks, costs"See full answer
"I tried solving this problem and here is the recorded video for the answer.
https://www.youtube.com/watch?v=d1tOkeQjyI4
And here is the link to Excalidraw board - https://excalidraw.com/#json=uabNFHcZm5qNh8CInMvyh,Wn9Vf1ZhGdl_iBCQYFkYdw"
Rjj - "I tried solving this problem and here is the recorded video for the answer.
https://www.youtube.com/watch?v=d1tOkeQjyI4
And here is the link to Excalidraw board - https://excalidraw.com/#json=uabNFHcZm5qNh8CInMvyh,Wn9Vf1ZhGdl_iBCQYFkYdw"See full answer
"Functional Requirement
Ingest Book Reviews in real time
User in the website needs specify title tho search books, return response is the list of reviews on the books.
Non Functional Requirement:
User get real-time book reviews>
It nees to handle the search among 1 million of active users daily"
Simon O. - "Functional Requirement
Ingest Book Reviews in real time
User in the website needs specify title tho search books, return response is the list of reviews on the books.
Non Functional Requirement:
User get real-time book reviews>
It nees to handle the search among 1 million of active users daily"See full answer
"I: Design a banking app for kids S: Sure, let me start with clarifying questions. What is our goal for building this app? I: To create financial literacy early in childhood and also increase our customer base. S: Sure. Are we going to launch it globally or in any specific geography or demography? I: Globally. S: Sure, Any resource or time constraints to keep in mind because I need to prioritize the features on the roadmap based on that? Also, are we launching it on iOS or Android? I: No resource"
Sameer S. - "I: Design a banking app for kids S: Sure, let me start with clarifying questions. What is our goal for building this app? I: To create financial literacy early in childhood and also increase our customer base. S: Sure. Are we going to launch it globally or in any specific geography or demography? I: Globally. S: Sure, Any resource or time constraints to keep in mind because I need to prioritize the features on the roadmap based on that? Also, are we launching it on iOS or Android? I: No resource"See full answer
"In my role as a Product Owner, I was developing a platform for a logistics company.
As a PO and that too of a digital agency, my work was mostly before-end-to-after-end, it would start from pitching, strategy, product management, launch, funding deck prep.
In mid of the product management cycle, the client starts adding pressure to deliver way before the deadline, as they had found the PE firm that conceptually was ready to start funding discussion, since this was not scoped before the start,"
Umang S. - "In my role as a Product Owner, I was developing a platform for a logistics company.
As a PO and that too of a digital agency, my work was mostly before-end-to-after-end, it would start from pitching, strategy, product management, launch, funding deck prep.
In mid of the product management cycle, the client starts adding pressure to deliver way before the deadline, as they had found the PE firm that conceptually was ready to start funding discussion, since this was not scoped before the start,"See full answer
"We were working on a very high stake migration project where were suppose to migrate all the traffic (more than 40 million users per day) from legacy to modern micro-services based architecture.
Before making this massive migration decision, company has already developed a lot of services outside monolith and we were suppose to utilise those services. Some these services there were PADs responsible to communicate the specific vendor APIs. For each vendor we had a dedicated PAD.
Fast forward"
Mohammad shahid S. - "We were working on a very high stake migration project where were suppose to migrate all the traffic (more than 40 million users per day) from legacy to modern micro-services based architecture.
Before making this massive migration decision, company has already developed a lot of services outside monolith and we were suppose to utilise those services. Some these services there were PADs responsible to communicate the specific vendor APIs. For each vendor we had a dedicated PAD.
Fast forward"See full answer
"Found bug will not impact on the new requirements, if the engineering team aware of the source of the bug and the severity, than it can easily be handled and regression test to perform for a quality check. The new requirement should be equally prioritize for groom and start creating task and team to work on it. Finally based on the severity of the bug you can shuffle the resources between these items."
Jagat mohan B. - "Found bug will not impact on the new requirements, if the engineering team aware of the source of the bug and the severity, than it can easily be handled and regression test to perform for a quality check. The new requirement should be equally prioritize for groom and start creating task and team to work on it. Finally based on the severity of the bug you can shuffle the resources between these items."See full answer
"select employeename, employeeid, salary, department, DR
from (
select employeename, employeeid, salary, dense_rank() over (partition by department order by salary desc) DR, department from employee
)
where DR <=3
order by department, DR"
Sreeram reddy B. - "select employeename, employeeid, salary, department, DR
from (
select employeename, employeeid, salary, dense_rank() over (partition by department order by salary desc) DR, department from employee
)
where DR <=3
order by department, DR"See full answer
"I will divide my answer in 2 parts:
Process I use for managing risks in any Project
I will explain a real life situation where a Risk occurred and how I managed it
Process for Risk Management can be broken down into 3 parts:
Risk Identification: Risk identification is a team effort and is an ongoing process that happens throughout the Project. Technical Risks are usually identified during design/build/testing stage. I maintain a Risk register document to capture all the risks identified"
Saket S. - "I will divide my answer in 2 parts:
Process I use for managing risks in any Project
I will explain a real life situation where a Risk occurred and how I managed it
Process for Risk Management can be broken down into 3 parts:
Risk Identification: Risk identification is a team effort and is an ongoing process that happens throughout the Project. Technical Risks are usually identified during design/build/testing stage. I maintain a Risk register document to capture all the risks identified"See full answer
"Since there is a need for the data to be accurate and consistent without any latency to allocate a spot, can't the data be synchronously synced to replicas after every write as the number of writes are not many per min, instead of read lock phenomena
Let me know if i am on a wrong thought here."
Chitapuram N. - "Since there is a need for the data to be accurate and consistent without any latency to allocate a spot, can't the data be synchronously synced to replicas after every write as the number of writes are not many per min, instead of read lock phenomena
Let me know if i am on a wrong thought here."See full answer
"Situation:
While working at CVS Health, our inventory management system for OTCHS products was facing challenges. We had increasing stock outs, and our existing data was insufficient to fully understand and address the issue since it has been only a year this product line was initiated.
Action:
Although we do have a forecasting model to predict demand and other algorithms to trigger out of stock flags to warehouses to fill them, lack of data points on seasonality, supplier delays, compliance"
Vihari K. - "Situation:
While working at CVS Health, our inventory management system for OTCHS products was facing challenges. We had increasing stock outs, and our existing data was insufficient to fully understand and address the issue since it has been only a year this product line was initiated.
Action:
Although we do have a forecasting model to predict demand and other algorithms to trigger out of stock flags to warehouses to fill them, lack of data points on seasonality, supplier delays, compliance"See full answer