General Dynamics Mission Systems Interview Questions

General Dynamics Mission Systems Interview Guides

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

General Dynamics Mission Systems Interview Questions

Practice for the General Dynamics Mission Systems 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 General Dynamics questions

Challenge

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

General Dynamics Mission Systems Salaries by Position

Data Engineer*
$150K
Data Engineer
Median: $150K
Mean (Average): $150K
Data points: 1
$79K
$142K
Software Engineer
Median: $110K
Mean (Average): $113K
Data points: 21
Data Scientist*
$108K
Data Scientist
Median: $108K
Mean (Average): $108K
Data points: 1
$64K
$96K
ML Engineer
Median: $84K
Mean (Average): $83K
Data points: 14

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 $150,000 base salary while the ML Engineer role on average pays the least with a $82,958 base salary.

Discussion & Interview Experiences

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

Discussion & Interview Experiences

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

Jump to Discussion