Collins Aerospace Interview Questions

Collins Aerospace Interview Guides

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

Collins Aerospace Interview Questions

Practice for the Collins 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
Behavioral
Medium
Machine Learning
Medium
Loading pricing options

View all Collins Aerospace questions

Challenge

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

Collins Aerospace Salaries by Position

$74K
$115K
Software Engineer
Median: $88K
Mean (Average): $91K
Data points: 10

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 $90,600 base salary while the Software Engineer role on average pays the least with a $90,600 base salary.

Discussion & Interview Experiences

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