I applied online. I interviewed at Tengizchevroil (Atyrau) in Sept 2020
Interview
I expected some tech questions, but there were no tech questions, just basic technical questions in english with a team of 5-6 members + techlead and scrum master.
introducing myself and talking about projects i have done before at previous place
Interview questions [4]
Question 1
what is the diff btw datalake and DWH?
oltp vs olap?
star & snowflake schema - the diff?
fact table vs dimension table.
what is index and what is it used for?