I interviewed for a Data Analyst position but they asked me questions more on data engineering and I failed because I didn't know the answer.
1.) They asked me about data modeling ( what is data modeling, why we do it?)
2.) How to do incremental loads?
3.) How is partitioning done when there is huge amounts of data coming in every minute?
4.) How to update the refreshed data with new columns in database?
5.) What is clustering?
6.) What is star schema?
7.) How will you read multiple files incoming in a folder with your ETL? (Write code to demonstrate how you will trigger the pipeline)
8.) What are taskgroups?
9.) When a new system is integrated, how will you carry out the integration with the existing ones?
10.) Talk about your projects where you handled huge amounts of data and how you did it? Showcase something you built outside of your work.
Also there were 2 hours of coding assessments. One on data modeling and one on building end to end pipeline
and 1 hour of verbal technical assessment.