non-technical: What do you do at your current work? What do you know about Fullscript? Give me an example of a time you had a disagreement with a colleague technical: SQL: double left join, having and group by functions, aggregate functions, coalesce nulls Python: create a simple function that returns a certain output based on an input, loop through a dictionary printing keys and values
Standard ones - how good are you in SQL, Python, give examples of projects
Tecnica y clasica de recursos humanos
Design an algorithm to compute the square-root of a number using only basic operations.
Technical expertise - Implementation and project experience
Tell me about your last project at work?
I was asked about what the purpose is of an analytics engineer and of a data org broadly as well as questions relating to complex business scenarios.
In the technical round, I was given a script to read for ten minutes, and then for the remaining time was asked to discuss how I would approach migrating this sql script into dbt/looker
Tell me about yourself, why you looking for a job,
What you would do in a work situation
Viewing 401 - 410 interview questions