They asked about the different types of dbt materializations, gave me some SQL exercises, and asked how to optimize certain queries.
Analytics Senior Interview Questions
960 analytics senior interview questions shared by candidates
What project did you do, etc
What can you do to contribute
About my experience. Situational Qs. Gave assignment.
PIVOT,CUBES,Inline views, Pandas - joins, Merge
Expect questions such as: Tell me about yourself. Describe your largest analytics transformation. How have you influenced executive decisions? Tell me about a difficult stakeholder. How do you prioritize competing initiatives?
One of the key questions involved data modeling. I was given a set of database tables and asked to design a data model that would enable the business to answer specific analytical and reporting questions. The task required identifying relationships between the tables, defining appropriate entities and dimensions, and structuring the data in a way that supported efficient querying and business insights.
Lots of business specific stuff. Less focus on answers, more on thought process. Advanced dbt necessary
Multiple questions about dbt, visualization tools, version control tools etc...
Give an example of working in a complex international matrix organisation.
Viewing 281 - 290 interview questions