Intuit面经_Intuit面试真题及高频题

1. the challenge

2.General SQL questions

3.用R/Python做过的分析

4.用到tableau的project

5.The challenge

6.Snake exit

7.Subdomain Visit Count

8.Unique Email Addresses Count

9.Longest Substring Without Repeating Characters

10.Spiral Matrix Traversal

11.Behavioral Questions on Conflict Resolution

12.Discuss Traditional Model Fundamentals

13.System Design for Data Quality Check

14.Design a Classification Model

15.Data Analysis using Python Dataframes

16.Describe your ML project experience and follow-up details

17.Design and Implement a Transaction and Invoice Application

18.Managerial Round and Behavioral Questions

19.Advanced Technical Interview

20.Technical Problem-Solving in Work Context

21.Microservice Design Explanation and Related Questions

22.Craft Demo Microservice Implementation

23.Implement Request Rate Limitation

24.Write a Dockerfile

25.Handling Downstream Microservice Failure

26.OOD Parking Garage

27.Write a SQL Query

28.SQL vs NoSQL Choice Discussion

29.Build a Bid System

30.Design an app to record photo locations, event names, and event types

31.Discuss a machine learning algorithm and its loss function

32.Write a unit test and handle corner cases

33.Behavioral Questions

34.Longest Common Substring

35.Domain Address Click Count

36.Design a Multi-Shelf Bookcase System

37.Discussion of Design & Coding Approach

38.Presentation of Design & Coding Solution

39.Full-Stack Website Development in an Interview

40.Design & Coding Exercise Preparation

41.Behavioral Questions

42.CI/CD and Deployment Questions

43.Microservice Craft Exercise

44.Implement a Rate-Limiting Algorithm

45.Design a rate limiter using the sliding window algorithm

46.CheckSum Follow-up

47.CheckSum

48.Exclude Free Subscriptions from Metrics

49.Calculate Conversion Rate for December 2018

50.Year-over-Year Subscriber Comparison

51.Count New Subscribers Per Month

52.Course Scheduling Optimization Problem

53.Meeting Scheduler

54.Course Schedule Path Analysis

55.Given a set of sentences, describe an algorithm or method to identify which words require the first letter to be capitalized.

56.What is your favorite machine learning algorithm and explain its details?

57.System Design: Movie Ticket Selling Service

58.Coding: Two Sum Variant

59.Self-introduction with PowerPoint

60.Implement a Least Recently Used (LRU) Cache

61.Implement a Queue

62.Top K Elements Problem Using Heap

63.Going beyond expectations

64.Resolving team conflict

65.Describe a time you failed and what you learned

66.Discuss a project you are most proud of

67.Self-introduction and reasons for pursuing a career in software

68.Tile Disappearance Game

69.Find the Nearest Exit in a 2D Board for a Snake

70.Tree Level Traversal and Multi-threading

71.Micro Service Improvement and Deployment

72.Micro Service Deep Dive

73.Micro Service Implementation

74.Team conflict and how you resolved it.

75.Tell me about a time when you failed and what you've learned.

76.Why software engineering?

77.How would you make the signal for incoming phone calls more granular?

78.Describe an experience where you quickly learned a new skill and one where it took a long time to learn.

79.Describe an experience of working with people from different backgrounds.

80.Describe an experience where you used technical skills to create an impact for a customer.

81.Describe an experience where you helped a customer (stakeholder) solve a problem.

82.Behavioral Interview Question: STAR Method

83.Find the common ancestor in a binary tree

84.Analyze the time and space complexity of a DFS implementation

85.Chi-Square Testing in Analytics

86.Analyzing Delivery Cost Increase

87.SQL Churn Rate Calculation

88.What is serverless architecture?

89.What is Elasticsearch and why can it optimize search?

90.What is Docker?

91.What is a container in computing?

92.Difference between Error code 400 and 500

93.What happens when you type a URL into a browser?

94.Behavioral Interview

95.Object-Oriented Design, CI/CD, and A/B Testing

96.Multithreading and Memory Management in Android

97.Android Knowledge Assessment

98.Implement a Feature Based on User Stories

99.Handling Network Calls in a Page Component with Multiple Widgets

100.Binary Tree Maximum Path Sum

101.Workflow Stages Separation

102.Badge Records Security System

103.Top K Largest Elements Variant

104.Defining Success Metrics for an A/B Test

105.SQL Query for Conversion Rates

106.Identify Fraudulent Login Spikes from Email Domains

107.Explain Past Projects

108.Degrees of Separation Between Businesses Algorithm

109.Discover Relationships Between Companies in Their Networks

110.Implement a Rate Limiter

111.API Rate Limiter Implementation

112.Scaling a Project

113.Find Factors and Primes

114.SQL Query Writing

115.Reverse String Algorithm

116.Design and Implement Microservice APIs

117.Implement a Queue with a Given Size

1. the challenge

Tell me about the challenge you had with your co-worker and how you handled it.
mentioned blockers I had received in product release meetings from a particular individual

2. General SQL questions

| 1. How many new subscribers have we received every month starting Jan 2017?
2. How does that metric compare to the same month prior year'
3.What is the conversion rate of signups for Dec 2018?
4. There' s another table (Free Subs) with companyIDs that got a free subscription.How do we exclude them from our previous metrics？
Table:
+---------+---------+---------------+--------------+---+------+|
companyid I signupdate l subscriptiondate l terminationdate l year l month
+---------+---------+---------------+--------------+---+------+|
|13343128 | 2020-02-13 |2020-02-14 I NULL || 13343124 | 2020-02-13 I 2020-02-14 |NULL || 13343100 I 2020-02-13 I 2020-02-14 I NULL ll 13343090 | 2020-02-13 I NULL || 2020-02-13 || 13343074 I 2018-02-13 I 201 8-02-14I NULL ll 13342758 | 2018-03-23 I 2018-03-24 I NULL || 13342732 | 2018-04-05 | 2018-04-05 I NULL || 13342730 |2018-09-13 |NULL |I 2018-09-13 || 1342720 | 2017-01-05 |2017-01-06 I 2018-02- 13 || 11343128 |2017-02-08 |2017-02 -08 I 2018-08-13 || 11342610 |2017-03 -23 | 2017-04-23I 2018-11-21 || 11342720 | 2017-03-29 |2017-03-30

3. 用R/Python做过的分析

举例介绍一个用R/Python做过的分析

4. 用到tableau的project

举例介绍一个用到tableau的project

5. The challenge

Tell me about the challenge you had with your co-worker and how you handled it