Ball Aerospace Interview Questions

Ball Aerospace Interview Guides

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

Ball Aerospace Interview Questions

Practice for the Ball Aerospace 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 Ball aerospace questions

Challenge

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

Ball Aerospace Salaries by Position

$89K
$138K
Software Engineer
Median: $138K
Mean (Average): $120K
Data points: 3

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

From the graph we can see that on average the Software Engineer role pays the most with a $119,667 base salary while the Software Engineer role on average pays the least with a $119,667 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