Tell me about the hardest data pipeline you have worked on.
Analytics Engineer Interview Questions
1,255 analytics engineer interview questions shared by candidates
How you worked with backend engineers before? What do you do when they don’t collaborate e.g. don’t want to fix issues that affect data downstream?
What makes a good data warehouse?
I can't remember exactly but they showed some actual scenarios at work and asked me to write sql queries to get the answers
For the first round SQL interview, a few things to focus on (other than syntax and functional code) include: * Performance tuning and reasons for choosing your approach over alternative methods * Simplicity and readability (i.e. try not to overcomplicate your code) For the final round technical interviews, my experience was all scenario based questions which may include (but not limited to): SQL, Python (OOP), System Design (including fault tolerance, redundancy and scalability), Data Modelling, Performance Tuning.
Write queries to answer each question. They shared table schemas and asked me to write queries to meet each scenario. The tables were related to marketing.
Work is work and I do it mainly in order to get paid and live. What is your purpose here and what are you trying to achieve?
Where do you see yourself after 5 years
What is your natural talent?
What are the current problems that the company is facing?
Viewing 541 - 550 interview questions