what is star schema and how does it works? have you designed star schema from scratch
Senior Analytics Interview Questions
887 senior analytics interview questions shared by candidates
I got a assignment from them which I shared over email.
Explain how you would assess and build a risk program related to payments
Can you explain star schema
They asked about the different types of dbt materializations, gave me some SQL exercises, and asked how to optimize certain queries.
PWC recruiter walked me through the interview process and the position itself. 2 directors asked questions on quantitative finance (stochastic, my project, coding), and some business-related questions (give an example you noticed an opportunity to improve the business, model risk governance, etc). Both interviewers are nice.
Lets know about joins in sql.
How do we move from one dashboard to another dashboard in tableau?
tell me about yourself and blah blah
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.
Viewing 251 - 260 interview questions