Took 1 month for entire process from recuiter call to final result. Inbetween you have wake them up for next steps.
1. Home assignmment - Dimensional modelling
- They are asking to model theor gitlab process woth fact tables and Dim. I made it with what I had a data for and made few assumtions.
Overall waste of time, no one ask about it during an interview, it takes mmore than 8 hrs and they claim it for 3 hrs. One can ask them money for those hours.
Screening is done by some junior level person who has little experience,
1. sql query - simple one, but she ask open ended questions which made no sense.
One should ask, what is the score for sql and score for other q. Anyone you do wrong you fail so why waste time for 60 min.
2. next steps all functional and open ended questions
overall very bad experience, they will make you wait for a month , so ask the recruiter to complete everything in 2 days or forget it.
Interview questions [1]
Question 1
1. Have you done any complex data model in your life?
2. Anything which didnt work and what is the alternative you did?
3. 2 sql query - very easy one, using left join and right join
4.what are the types of fact tables
5. Mention ralf kimbell 10 times so that they hire you. :-)
I applied through a recruiter. I interviewed at GitLab (London, England) in Oct 2020
Interview
The interview process was very transparent and HR and all the member of interview panel were very cooperative in terms of time of interview also explaining the process. They were happy to answer any question either it is w.r.t to work culture or technical.
