Interview Questions

Derrick M. - "SELECT o.order_amount FROM orders o JOIN departments d ON d.departmentid = o.departmentid WHERE d.department_name = 'Fashion' ORDER BY order_amount DESC LIMIT 1 OFFSET 1; `"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

Charu S. - "Engineering efficiency - dev time per launch developer SAT"See full answer

Sagrika S. - "The biggest factor that excites me about technology is its ever changing and dynamic trend. In my life, I have seen the transition from landlines to simple mobile to smartphones, from Cathode tube desktop screen to super slim TFT and many more. I think technology has now (with time) become integral part of human life and getting in-sync with it is like a normal and very cool phenomena."See full answer

Vihari K. - "Clarify Questions • Target Audience: Are we focusing on existing TikTok users, new users, or both? • Scope of Search Features: Are we looking at in-app search, search engine optimization (SEO), or both? • Geographical Focus: Are there specific regions we are targeting for user acquisition? Goal Our primary goal is to increase user adoption and market share by making it easier for users to discover and engage with TikTok Shop through optimized search features. User Segments Current TikTo"See full answer

Pree M. - "What is shopper demand? Let's say the ability to predict whether x number of shoppers are available during a certain time of day based on a some factors Variables: \# number of orders /per hour /per day /per week Shopping Time: time taken for a shopper to prep an order (how many orders can a shopper prep) $ average order value geographic factors since demand will vary by city number of stores or any other multiplying factor which help us predict order volume (which is dire"See full answer

Mrinalini A. - "Clarifying question - Who are we? Any constraints - time/money? What region are we going to focus on? Do we have a goal in mind? I'm assuming a product like this does not exist in today's world. How do you define kids - any specific age range? User Segments - 1) Beginner - don't know what an ATM is/don't understand money that well 2) Intermediate - have a basic understanding of ATMs 3) Advanced - have a really good understanding - maybe are on the older side Segment chosen is the Intermediate"See full answer

Azeezat R. - "/* You are with your friends in a castle, where there are multiple rooms named after flowers. Some of the rooms contain treasures - we call them the treasure rooms. Each room contains a single instruction that tells you which room to go to next. * instructions1 and treasurerooms_1 * lily* --------- daisy sunflower | | | v v v jasmin --> tulip* violet* ----> rose* --> ^ | ^ ^ | "See full answer

Farza S. - "It is the smallest level of significance at which the null hypothesis gets rejected"See full answer

Nayla D. - "Instagram is social media app where you can share photo and video to others. Impressions is an important metrics to track because it shows how many contents that users see. Clarify Questions: Is this drop happen suddenly or gradually? - Gradually How long has it been happening? - Last 3 months Is it happen globally or in certain region? - Globally Is the drop happen to all user segments (age, new/existing, active/less active users)? - all user segments When calculating an impressions,"See full answer

Ankita G. - "Merge Sort"See full answer

Vineet M. - "Each flip is independent. P(10 heads)=(1/2​)^10"See full answer

Anjali M. - "Several reasons why eCommerce will capture a trillion$ market in the next 10 years. User consumption habits have changed and the pandemic has only accelerated user behavior to order online from the convenience of buying from home. The supply chain is becoming better with partnerships and digital products are making shipping and deliveries much more convenient. Many companies investing in automated shipping vehicles eg Drone deliveries and in near future we might see automated driving v"See full answer

Kavya C. - "MTBF is Mean time between failures. This is measured to figure out how reliable a system is by what is the gap between 2 failures. (Total time elapsed- Down time)/No of failures"See full answer

Krutarth S. - "Hi, is this question part of the Powerday interview or the Mini-case interview?"See full answer