a basic SQL query scenario based . there are three tables related to each other with a anID they are loaded into target system . the future system auto-generates the id column . how will bring old value. in return I asked if I can used a custom field to being over old column interviewer said 'yes ' and interrupted me mid way saying oh ok you are almost there
Senior Analytics Interview Questions
885 senior analytics interview questions shared by candidates
what is star schema and how does it works? have you designed star schema from scratch
I got a assignment from them which I shared over email.
Explain how you would assess and build a risk program related to payments
Lets know about joins in sql.
How do we move from one dashboard to another dashboard in tableau?
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.
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.
None, I was ghosted by the recruiter. That reflects very poorly on her and on Integra Connect.
Viewing 251 - 260 interview questions