I applied online. The process took 2 months. I interviewed at Microsoft (Ban Pra Suk) in Jan 2022
Interview
Microsoft Prague:
There was first series of the interview with HR then they hold for 1 month with the reply. 2d round is technical interview where I was requested to write simple algorithm in python. Then was series consists of 4 interviews: 1 again simple algorithm in python. 2 Interview with the data engineer without specific technical questions on data engineering, though they ask to propose the design of LinkedIn news list specific for each user implementation. That was the only interesting task. 3 is management interview with standard questions - how do you handle stress at work etc. 4. interview with data engineer again basic sql knowledge is enough to pass. Remarkable that during the whole process nor salary nor specific role description is not provided and despite I answered all the questions and mentioned that senior role is the only I can accept. They didn't came up with the offer and didn't explain why. My thoughts is that they couldn't manage to open Senior position for this Job.
Interview questions [1]
Question 1
Write a function that return N-th distinct element from array. example: N=2 Array=[a,a,b,c,d,c,e]
Answer = d
because a and c is not distinct in array and omitted
I applied online. The process took 2 weeks. I interviewed at Microsoft
Interview
Entrevista preliminar com recrutador. Entrevista técnica. Entrevista em vídeo com várias pessoas o que pode incluir fazer testes práticos de código, e responder perguntas sobre seu histórico e suas experiências profissionais.
Interview questions [1]
Question 1
Descrição de antigas atividades exercidas. Situações do dia a dia de projeto e problemas relacionados ao cargo.
I applied online. The process took 3 weeks. I interviewed at Microsoft (Noida) in Jan 2022
Interview
Interviewer does not gave look to my resume & even does not introduced himself. Busy with mobile during video call.
Look like he is not interested to take interview or confused with something.
Precisely interview took 57:30 Min (as joined 2:30 min late) and 21 questions were asked.
Majorly they will ask SQL, although in my case , interviewer itself confused with his own examples. Mixing OLAP and OLTP in same questions and forcing his own solution over candidate solutions.
Interview questions [1]
Question 1
Why Azure synapse ? Pro and cons
Different File Storage format with pro and cons ? which to use & when
Factors applicable while selecting a storage type ?
If sudden slowness between two different system what can be root cause ?
Partition , why to use and how to use
what is data skewness , effect of same in synapse and query processing with example
Integration Runtime
Factors to be considered for injection or set of answers you are looking for.
4-5 SQL questions