Photon Infotech Inc Interview Questions

Photon Infotech Inc Interview Guides

Click or hover over a slice to explore questions for that topic.
SQL
(50)
Data Structures & Algorithms
(38)
Machine Learning
(37)
Data Modeling
(14)
A/B Testing
(13)

Photon Infotech Inc Interview Questions

Practice for the Photon Infotech Inc 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 Photon questions

Challenge

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

Photon Infotech Inc Salaries by Position

Data Scientist*
$130K
Data Scientist
Median: $130K
Mean (Average): $130K
Data points: 1
$60K
$104K
Data Engineer
Median: $78K
Mean (Average): $79K
Data points: 6
Software Engineer*
$72K
$87K
Software Engineer
Median: $79K
Mean (Average): $79K
Data points: 2
$60K
$101K
Business Analyst
Median: $72K
Mean (Average): $76K
Data points: 109

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

Discussion & Interview Experiences

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