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. :-)
got contacted by the recruiter for a job that wasn't available on the website and other job board. got the interview with the hiring manager, even if they announced layoffs for the beginning of June
Interview questions [1]
Question 1
it was the same interview, nothing special 3-4 classic questions, like why this place, who you are, what are doing for creating your pipeline, what's your key of success in sales
Straightforward and well communicated scheduling. Everyone was helpful and open to questions. Multiple rounds with varying levels of technical and management interviewers. STAR method preferred. Plenty of opportunities to ask questions.
First round was with the hr, she asked general questions about my experience
Second round was with the hiring manager- overall experience and situational questions
Case studies and sql rounds
