Viasat Interview Questions

Viasat Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(6)
Behavioral
(6)
Machine Learning
(3)
Business Case
(2)
SQL
(2)

Viasat Interview Questions

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

QuestionTopicDifficulty
SQL
Medium

Over budget on a project is defined when the salaries, prorated to the day, exceed the budget of the project.

For example, if Alice and Bob both combined income make 200K and work on a project of a budget of 50K that takes half a year, then the project is over budget given 0.5 * 200K = 100K > 50K.

Write a query to forecast the budget for all projects and return a label of "overbudget" if it is over budget and "within budget" otherwise.

Note: Assume that employees only work on one project at a time.

Example:

Input:

employees table

Column Type
id INTEGER
first_name VARCHAR
last_name VARCHAR
salary INTEGER
department_id INTEGER

projects table

Column Type
id INTEGER
title VARCHAR
state_date DATETIME
end_date DATETIME
budget INTEGER

departments table

Column Type
id INTEGER
name VARCHAR

employee_projects table

Column Type
project_id INTEGER
employee_id INTEGER

Output:

Column Type
title VARCHAR
project_forecast VARCHAR
Data Structures & Algorithms
Hard
Behavioral
Medium
Loading pricing options

View all Viasat Inc. questions

Challenge

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

Viasat Salaries by Position

$104K
$138K
Data Engineer
Median: $119K
Mean (Average): $120K
Data points: 12
$85K
$141K
Data Scientist
Median: $109K
Mean (Average): $111K
Data points: 8
$60K
$173K
Software Engineer
Median: $95K
Mean (Average): $104K
Data points: 526
Business Analyst*
$74K
Business Analyst
Median: $74K
Mean (Average): $74K
Data points: 2
Data Analyst*
$70K
$75K
Data Analyst
Median: $73K
Mean (Average): $73K
Data points: 2

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 $120,333 base salary while the Data Analyst role on average pays the least with a $72,500 base salary.

Discussion & Interview Experiences

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