1: How many iteration it would take to find the nth element in the N*N matrix. 2: Few SQL related questions [ Joins] 3: Data modelling Concepts
Analytics Engineer Interview Questions
1,254 analytics engineer interview questions shared by candidates
Have you ever deployed a DB on AWS
Tell me more about your background
SQL and Excel Qs - Basic
Round 1 – SQL (Shared Doc Format) Given schema: - fact_impressions(event_date, account, media_type, impressions, revenue) - dim_account_mappings(account, client, region, industry, sales_team) - dim_dates(event_date, fiscal_quarter, fiscal_year) Questions: 1. Number of clients supported by multiple sales teams 2. For each client, the percentage of revenue from display advertising 3. For each fiscal quarter, total revenue by industry and percent contribution per industry 4. For each client, the sales team that generated the most revenue Rounds 2–4 – Behavioral Focused on stakeholder management: - TMAY - Relevant experience - Handling conflicting priorities - Communicating with non-technical teams - What to do if a stakeholder disagrees with your solution
Python live coding, SQL, Trino SQL Query optimization. I was later informed by HM that I would only be using Scala, Python, and Spark SQL out of which I was never interviewed for Scala and Spark, nor informed before.
Why do you want to join?
Two coding interviews, and one systems design.
How would you optimize a data warehouse
Have a story ready for each one of the Veho values
Viewing 411 - 420 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