Asked about projects, ETL pipelines, Gave some ETL scenarios and asked how to solve them, diff between Natural key and Surrogate key, Asked to write a lot of SQL queries (~12 questions), questions about joins, dimensional modeling Asked questions focusing on the tech stack used by them, indexing, coalesce, if null, how to increase query performance, factless fact, list vs tuple
Q: Do you know about columnar data format?
Why are interested in this specific role?
Java, spark
It was mostly about the technical expertise.
what is the process for training a NLP algorithm
what is the process of integrating a UDF into a workflow
Given a list of attributes and graph of relationships, compute the total list of properties for each node in the graph.
I know this is not precisely your purview but talk to me about any machine learning algorithms you have come across during your work and explain them
Why did you move to another country?
Viewing 361 - 370 interview questions