I was interviewed for Data Engineer at Amazon last week . The is an initial stage where they review your profile and call/mail you for a multiple time slots to have the first HR round which will be mostly a casual discussion round around your work experience and the post you have applied. They will also ask some leadership principles based queries that are often asked indirectly via questions. Once you clear the first round-results are usually communicated over a mail within 2 working days , you will again be asked to give 5 available slots which can be used for the second technical interview with the hiring manager. Once you get the second round call , you will be required to complete an online numerical assignment as well SHL , this should be completed before the exam. Technical Round with the Hiring manager- this round is purely techical in nature and you will be required to write several SQL queries which starts with basics and keeps getting tough as you go on. You will also be asked to explan everything you write on the code screen. If you do not have specific experience , one they seek in a candidate , its better not to apply for the process as they are particular about basic skills for data engineer role.