Acadia Technologies, Inc. Interview Questions

Acadia Technologies, Inc. Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(8)
SQL
(5)
Product Sense & Metrics
(5)
Machine Learning
(4)
Business Case
(3)

Acadia Technologies, Inc. Interview Questions

Practice for the Acadia Technologies, Inc. interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Easy

Write a SQL query to select the 2nd highest salary in the engineering department.

Note: If more than one person shares the highest salary, the query should select the next highest salary.

Example:

Input:

employees table

Column Type
id INTEGER
first_name VARCHAR
last_name VARCHAR
salary INTEGER
department_id INTEGER

departments table

Column Type
id INTEGER
name VARCHAR

Output:

Column Type
salary INTEGER
SQL
Medium
Data Structures & Algorithms
Medium
Loading pricing options

View all Acadia Technologies questions

Challenge

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

Acadia Technologies, Inc. Salaries by Position

Data Scientist*
$94K
$96K
Data Scientist
Median: $95K
Mean (Average): $95K
Data points: 2
Software Engineer*
$78K
Software Engineer
Median: $78K
Mean (Average): $78K
Data points: 2
$58K
$92K
Data Analyst
Median: $75K
Mean (Average): $74K
Data points: 13
$55K
$64K
Business Analyst
Median: $55K
Mean (Average): $58K
Data points: 5

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 $95,451 base salary while the Business Analyst role on average pays the least with a $58,000 base salary.

Discussion & Interview Experiences

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