Interview Questions

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

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

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

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

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

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

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

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

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

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

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

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