Oportun Interview Questions

Oportun Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(41)
Machine Learning
(37)
SQL
(30)
A/B Testing
(11)
Probability
(10)

Oportun Interview Questions

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

QuestionTopicDifficulty
SQL
Easy

We’re given two tables, a users table with demographic information and the neighborhood they live in and a neighborhoods table.

Write a query that returns all neighborhoods that have 0 users. 

Example:

Input:

users table

Columns Type
id INTEGER
name VARCHAR
neighborhood_id INTEGER
created_at DATETIME

neighborhoods table

Columns Type
id INTEGER
name VARCHAR
city_id INTEGER

Output:

Columns Type
name VARCHAR
SQL
Easy
SQL
Medium
Loading pricing options

View all Oportun questions

Challenge

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

Oportun Salaries by Position

$113K
$169K
Data Scientist
Median: $160K
Mean (Average): $148K
Data points: 6
$127K
$175K
Software Engineer
Median: $127K
Mean (Average): $145K
Data points: 3
Data Engineer*
$131K
$149K
Data Engineer
Median: $140K
Mean (Average): $140K
Data points: 2
Business Analyst*
$110K
Business Analyst
Median: $110K
Mean (Average): $110K
Data points: 1
Business Intelligence*
$66K
$75K
Business Intelligence
Median: $70K
Mean (Average): $70K
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 Scientist role pays the most with a $147,500 base salary while the Business Intelligence role on average pays the least with a $70,000 base salary.

Discussion & Interview Experiences

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