Candidatei-me por meio de uma faculdade ou universidade. O processo levou 2 semanas. Fiz uma entrevista na empresa Amazon (Chennai).
Entrevista
Is this a SQL developer role specifically? If so, these are pretty common topics that are typically asked about:
Difference between Primary Keys and Foreign Keys
The different join types. Specifically the difference between INNER JOINs (aka JOIN) and OUTER JOINs (i.e.LEFT OUTER JOIN aka LEFT JOIN or RIGHT OUTER JOIN aka RIGHT JOIN). Sometimes FULL OUTER JOINs are asked about too, but this is rare.
Difference between a Clustered Index and a Nonclustered Index
The purpose of a GROUP BY clause and when to use a HAVING clause vs a WHERE clause
Window Functions (classic ones are ROW_NUMBER() and RANK())
The purpose of a DISTINCT clause
The purpose of a TOP or LIMIT clause (depending on the database system, but they mean the same thing)
Less likely, but also possible that you can be asked about the UNION and UNION ALL clauses, their purposes, and differences between each other
Outras avaliações de entrevista de vagas de SWE Intern da empresa Amazon
Very good but hard interview overall. Pay was great and so was the work life balance. Fully remote and great mentorship. Benefits were also good with 401k match and pto
Fiz uma entrevista na empresa Amazon (Seattle, WA).
Entrevista
Three interview rounds are incredibly stressful and draining. They force you to repeat yourself, manage endless scheduling, and perform on demand. It is completely valid to feel exhausted by this.
Candidatei-me online. Fiz uma entrevista na empresa Amazon (Sydney).
Entrevista
the interviews were half technical half behavioural with two rounds. it involved standard behavioural questions using STAR (tell me about ...) and technical questions were leetcode style (algos and oop questions)
