1. Why did you leave mechanical engineering midway?
Analytics Engineer Interview Questions
1,254 analytics engineer interview questions shared by candidates
How will you model the data in DBT? What is wrong in given schema, how would you design if you have to design OLAP schema
Describe the time complexity of the code written in Python.
General SQL questions. Python OOO
Walk me through your resume
Case study has been provided
SQL: UNNEST (BigQuery) Engineering experience: airflow, dbt, data governmence
What are your salary expectations?
After the phone screenings and the technical interview, the questions seemed to be mostly cultural. The technical questions were pretty standard.
1. Coding assesment Solved a leetcode type problem with a streaming median. 2. Domain Interview Quiz about memory management, garbage collection, time to delete items from an array and TCP vs UDP. 3. System design interview Design a playlist photo upload service. This was harder than the others. 4. Dataset analysis Live coding some SQL and thinking about how to optimize for parallelization of queries using BigQuery.
Viewing 1041 - 1050 interview questions
See Interview Questions for Similar Jobs
Senior Data Analytics EngineerData Analytics EngineerBao Advanced Analytics Senior ConsultantData And AnalyticsData Scientist IiiPredictive AnalyticsAnalyticsPredictive AnalystUpstreamDirector Data ScienceBusiness Integration Analyst SystemsGoogle AnalyticsSoftware Engineer DataSenior Operations Research AnalystPredictive ModelerSoftware Research EngineerDirector Predictive Analytic SalesData Scientist, Product