I interviewed at GreenRoad Technologies (Tel Aviv-Yafo)
Interview
explaining about the company and the job, it felt like they were looking for someone to rewrite the entire frontend. The work sounded like it was to redevelop the frontend side with the help of other people.
He was expecting to be familiar with hard-core SQL because part of the job is to understand the hard queries that they have in the code base.
He asked me the following questions:
what are indexes? what are they good for?
why don't we use indexes for everything?
what is an inner / left / right join?
after that there were 4 more interviews
Interview questions [1]
Question 1
questions about sql like:
what are indexes? what are they good for?
why don't we use indexes for everything?
what is an inner / left / right join?
I applied online. The process took 1 day. I interviewed at GreenRoad Technologies (Holon) in July 2024
Interview
first on call, the hiring manager asked about my experience with multithreaded multi-processing development.
asked me about the object Task in cshap to explain what it is , and why there are indexes for a table in SQL database.
asked me about my experience with real-time technology.
moved to interview at the company site.
question about creating a tasks in csharp and then how to run them
was pretty hard ,not a leetcode problem.
Interview questions [1]
Question 1
write a function that gets a number and create a list of actions that print their index and then delay sleep for a random amount of time from 1 to 10 seconds. and it return that list
then the second function they asked to write is a function that will take that list and will run it with an number it gets to point the amount of threads it will be using to run them.