Case study and interview from India from people who have never directly worked with clients here. They have no idea about the case study but want to show off there knowledge. For a engagement or delivery manager in US you expect them to do core data science questions.
Generally the take home assignment was about data modelling and dbt. They asked to create a data model based on entities important to the company, but the problem is that the process was only fictional without any real dataset given to me.
At 2nd stage: 1. Difference between left and full join - example to explain 2. Window functions 3. Sum over vs sum - example to explain why and what we would get from given query 4.Rate your SQL skills -0-10 Complete 0 questions about BI skills or knowledge, so basically SQL more important than BI. As long as SQL is right you do not need any BI skills :)
Explain how you would assess and build a risk program related to payments
Would you be open to relocation?
Can you explain star schema
How have you rolled out strategic reports and analytics that would be presented to a diverse set of stakeholders? How did you consider all the stakeholders’ perspectives?
Technical questions about tableau sql
One of the key questions involved data modeling. I was given a set of database tables and asked to design a data model that would enable the business to answer specific analytical and reporting questions. The task required identifying relationships between the tables, defining appropriate entities and dimensions, and structuring the data in a way that supported efficient querying and business insights.
Insert standard behavioral question here.
Viewing 251 - 260 interview questions