Intuit interview experience Real time questions & tips from candidates to crack your interview
Data Engineer
Intuit
4 rounds | 15 Coding
problems
Selected Interview preparation journey
Preparation
Duration: 1 month
Topics: SQL, Data warehouse, Big Data, Data Modelling, Python
Tip 1 : Practice Coding Questions on a coding platform which covers test cases also and you can track of your speed as well
Tip 2 : Prepare various optimisation techniques implemented in your project, how big stream of data is ingested
Tip 3 : Refresh basics of every skill you mentioned in resume and prepare high level questions of your expertise skill
Application process
Where: Other
Eligibility: Above 2 years of experience
Tip 1 : Should be one page, brief and concluded
Tip 2 : Specify technologies used in every mentioned project
Interview rounds
01
Round
Medium
Video Call
Duration60 minutes
Interview date17 May 2021
Coding problem6
My Interview went pretty good. I was asked one coding question, 1 SQL and 1 python and various Spark, Big Data and Redshift questions.
1. Prime Factorisation of a Number
Moderate
50m average time
60% success
0/80
Asked in companies
You are given an integer 'N'.
You must return the unique prime factors of 'N' in increasing order.
For Example:
For ‘N’ = 10.
Unique prime factors are 2 and 5.
Hence we return {2, 5}.
Problem approach
I was asked to code in python specifically with some standard python libraries to check my understanding of the language.
2. Big Data Question
How to deploy a Big Data Model? Mention the key steps involved.
3. Big Data Question
What are the different big data processing techniques?
4. SQL Question
Given an Employee Table, find the Nth highest salary from it.
Problem approach
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
DECLARE M INT;
SET M=N-1;
RETURN (
SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT M, 1
);
END5. Redshift Question
How to use an AWS Data Pipeline to load CSV into Redshift?
6. Redshift Question
What is materialized views in Redshift?
04
Round
Easy
Video Call
Duration30 minutes
Interview date27 May 2021
Coding problem5
Data warehousing concepts and SQL questions were asked in this round
Timing : 1:30 PM - 2:15 PM
1. Data Warehouse Question
Differentiate between fact table and dimension table.
2. Data Warehouse Question
What are the different types of data marts in the context of data warehousing?
3. SQL Question
What is the difference between CHAR and VARCHAR2 datatype in SQL?
4. SQL Question
What is the view in SQL?
5. SQL Question
What is On Delete cascade constraint?
05
Round
Medium
Video Call
Duration30 minutes
Interview date27 May 2021
Coding problem3
Spark related questions
Timing : 2:30 PM - 3:00 PM
1. Spark Question
List the types of Deploy Modes in Spark.
2. Spark Question
What do you understand by Shuffling in Spark?
3. Spark Question
Explain the working of Spark with the help of its architecture.
06
Round
Easy
HR Round
Duration30 minutes
Interview date27 May 2021
Coding problem1
This was a casual HR round with some simple behavioural questions.
Timing : 3:15 PM - 3:45 PM
1. Basic HR Questions
1) Why should we hire you?
2) What are your expectations from the company?
3) How was your overall interview experience?
4) What are your strengths and weakness according to you?
5) Where do you see yourself in the next 5 years?
Problem approach
Tip 1 : The cross-questioning can go intense sometimes, think before you speak.
Tip 2 : Be open-minded and answer whatever you are thinking, in these rounds, I feel it is important to have an opinion.
Tip 3 : The context of questions can be switched, pay attention to the details. It is okay to ask questions in these round, like what are the projects currently the company is investing, and which team you are mentoring, how is the work environment etc.
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
What is recursion?
Choose another skill to practice
Similar interview experiences
Senior Software Engineer
4 rounds | 4 problems
Interviewed by Intuit
Selected 
1686 views
0 comments
0 upvotes
SDE - 2
5 rounds | 6 problems
Interviewed by Intuit
Selected 5209 views
1 comments
0 upvotes
SDE - 1
3 rounds | 6 problems
Interviewed by Intuit
Selected 1373 views
0 comments
0 upvotes
SDE - Intern
3 rounds | 6 problems
Interviewed by Intuit
Selected 1380 views
0 comments
0 upvotes
Companies with similar interview experiences
Data Engineer
2 rounds | 4 problems
Interviewed by Amazon
Rejected
1838 views
0 comments
0 upvotes