Below are FarEye interview questions for SDE2 role.
Round 1:
Hacker-rank Assessment Test
- https://stackoverflow.com/questions/48448432/fragment-of-missing-code-in-the-solution-movie-titles-complete-a-challenge-more/48656211
- Given two tables, Employee and Department, generate a summary of how many employees are in each department. Each department should be listed, whether they currently have any employees or not. The results should be sorted from high to low by number of employees, and then alphabetically by department when departments have the same number of employees. The results should list the department name followed by the employee count. The column names are not tested, so use whatever is appropriate.
Soln:
select d.name, count(unique(e.id)) as c
from department d, employee e
where d.id = e.dept_id
group by d.name
order by c desc, d.name;
select d.name, 0
from department d
left outer join employee e on d.id = e.dept_id
where e.id is null
group by d.name
order by d.name;
- Third question was simple based on String sorting
Round 2:
- Given a matrix with 0s and 1s with all rows sorted in order. Find the row containing maximum 1s and return the count of 1s.
- Find maximum not repeating character substring in the given string.
Round 3:
- Tell me about your project in full details.
- High level and low level design of Movie booking app (like Book My Show.