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
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.
Would you be open to relocation?
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.
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
tell me about yourself and blah blah
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.
Share your experience with data engineering projects.
Viewing 241 - 250 interview questions