what would you do if marketing head asks how should i spend my 1 million marketing budget.
Senior Intelligence Analyst Interview Questions
244 senior intelligence analyst interview questions shared by candidates
Described your day and how you work through
Writing a series of increasingly complex SQL queries. Some basic probability (combinations, permutations, etc) and algorithm questions (e.g. combine three possible operations to accomplish a task).
I had 4 rounds with ops where they asked questions based on Amazon leadership principles
How do you deal with a difference of opinion of senior leadership?
Questions during interview: 1- Say you do on-line ads for two different companies, EasyJet and Mercedes. How would you present your results to the board and prove them you did not waste any money? 2- Another question that involves some economic thinking about why profits go down etc. in the on-line ad business. I recommend you review concepts such as Click-Through Rate, Conversion Rate and the auction mechanisms in on-line marketing etc. 3- After Facebook users pass away, their profile pages remain. So today we have some dead users and some users that are still alive. Will the number of dead people ever equal that of the ones that are alive? When will that happen? How would you calculate it?
General Q&A about experience and goals
Q1. Difference between SQL, MySQL and Redshift in terms of computation and performance as i had worked on these 3 Q2. What is hierarchy of SQL script execution and how can it be optimised Q3. Which visualization tool is best among tools i worked upon - Tableau, Power BI , DOMO and Google Data Studio and what are advantages of Power BI w.r.t Tableau and DOMO in terms of computation and other Q4. Some Question related to time series forecasting and best method to be used for this Q5. How to analyse and evaluate customer behaviours (Case study)
I was asked how I would validate models. My comfort level with SQL. If I had ever read a financial statement. And if I had ever programmed with nested loops.
What tools do you use in your daily work at the moment?
Viewing 191 - 200 interview questions