1) Data warehousing basics
2) Python coding - intermediate level
3) 2 SQL questions - group by, RANK() types
4) Resume drill down
5) Tell me about a time you helped a teammate?
6) Hardest data pipeline you have worked on?
7) Difference between STAR, SNOWFLAKE and GALAXY schema
8) SCD and types
9) A recent ETL process you have worked on and challenges you faced in it

Question

1) Data warehousing basics
2) Python coding - intermediate level
3) 2 SQL questions - group by, RANK() types
4) Resume drill down
5) Tell me about a time you helped a teammate?
6) Hardest data pipeline you have worked on?
7) Difference between STAR, SNOWFLAKE and GALAXY schema
8) SCD and types
9) A recent ETL process you have worked on and challenges you faced in it

Anonimo · Accepted Answer

Get SQL & Python questions right
Revise data warehousing concepts well, there are chances they might go deep into it as you keep answering

Amazon

Domanda di colloquio di Amazon

Risposta di colloquio

Aziende seguite

Ricerche di lavoro