NetApp Interview Questions

NetApp Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(60)
Machine Learning
(29)
SQL
(23)
A/B Testing
(12)
Statistics
(12)

NetApp Interview Questions

Practice for the NetApp interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

You have a table containing information about the time that employees have worked on a project.

Write a query to find how many unique calendar days each employee worked. Order your query by the employee_id.

Example:

An employee worked on two projects, and recorded their time like this:

employee_id project_id start_date end_date
1 1 2024-01-01 2024-01-06
1 2 2024-01-03 2024-01-07

The number of unique calendar days is therefore 7.

Schema

Input:

projects table

Columns Type
employee_id INTEGER
project_id INTEGER
start_date DATE
end_date DATE

Output:

Columns Type
employee_id INTEGER
unique_days_worked INTEGER

Example

Input:

projects table

employee_id project_id start_date end_date
1 1 2024-01-01 2024-01-15
1 1 2024-01-21 2024-01-31
1 2 2024-01-25 2024-02-28
2 3 2024-01-01 2024-01-31

Output:

employee_id unique_days_worked
1 54
2 31
Statistics
Easy
Statistics
Easy
Loading pricing options

View all Netapp questions

Challenge

Check your skills...
How prepared are you for working at Netapp?

NetApp Salaries by Position

$136K
$209K
Data Engineer
Median: $165K
Mean (Average): $165K
Data points: 5
$119K
$189K
Product Manager
Median: $160K
Mean (Average): $156K
Data points: 4
Data Analyst*
$145K
Data Analyst
Median: $145K
Mean (Average): $145K
Data points: 1
$63K
$210K
Software Engineer
Median: $139K
Mean (Average): $137K
Data points: 86
$94K
$166K
Data Scientist
Median: $130K
Mean (Average): $130K
Data points: 5
$107K
$147K
Business Intelligence
Median: $110K
Mean (Average): $119K
Data points: 7
$90K
$150K
Business Analyst
Median: $108K
Mean (Average): $116K
Data points: 6

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Data Engineer role pays the most with a $165,200 base salary while the Business Analyst role on average pays the least with a $115,833 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.