Q: Questions around your solution to the take home coding challenge
Senior Backend Engineer Interview Questions
2,047 senior backend engineer interview questions shared by candidates
Write an API to return true or false as per the rate limiting criteria.
1) Coding question in a lang of your desire, here it is: Given the following class (JAVA): class Role { String title, LocalDate effectiveFrom } You need to calculate what role an employee had per a given set of dates, can be multiple roles of course. Need to implement the following function: Map rolesByDates(List history, List dates) Note that the history list is sorted by the effectiveFrom property in descending order. Here's the main function: public static void main(String[] args) { List history = Arrays.asList( new Role("Team Leader", LocalDate.of(2020, 8, 1)), new Role("Fullstack developer", LocalDate.of(2016, 5, 15)), new Role("Frontend developer", LocalDate.of(2015, 11, 17)) ); List dates = Arrays.asList( LocalDate.of(2021, 1, 1), LocalDate.of(2014, 1, 1), LocalDate.of(2016, 6, 1) ); Map rolesByDates = rolesByDates(history, dates); rolesByDates.forEach((key, value) -> System.out.println("date = " + key + ", role = " + value.getTitle())); } 2) Given a system that generates surveys (similar to google forms), need to represent its data in high level, like technical design on how to implement such data structure, only data. 3) Differences between SQL / NO-SQL, an easy question on sql syntax, related to the previous question and on which db it will be better to represent it.
Describe how you would make your system design more resilient and fault tolerant?
What if some records fail?
What do you know about Glovo?
Why do you wanna work with us?
One of the key topics discussed was database concurrency
What do you think about working overtime?
How do you optimise SQL Queries? Design SQL Tables for Employee and Department? What is Indexing in SQL? Questions on joins and overall performance of the application?
Viewing 151 - 160 interview questions