Ispace Interview Questions

Ispace Interview Guides

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

Ispace Interview Questions

Practice for the Ispace 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
Data Structures & Algorithms
Hard
Loading pricing options

View all Ispace questions

Challenge

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

Ispace Salaries by Position

$60K
$115K
Data Engineer
Median: $90K
Mean (Average): $85K
Data points: 39
$60K
$113K
Business Intelligence
Median: $76K
Mean (Average): $81K
Data points: 16
Software Engineer*
$75K
$80K
Software Engineer
Median: $78K
Mean (Average): $78K
Data points: 2
Business Analyst*
$77K
Business Analyst
Median: $77K
Mean (Average): $77K
Data points: 1

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 $85,423 base salary while the Business Analyst role on average pays the least with a $77,418 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