Data engineer can mean many different things, is it SQL and Data Warehouse? ML, analytics, Big data? Big data, NoSql, dev ops, cloud services? ETL, data munging, apis for data feeds? Data reporting, visualization? Received a coding test first, with SQL queries and expected answers, and one general question about how to perform a merge with very large data. This was a take home test sent by email as the first step in the process. I did the obvious thing, put the data in a database, googled around and ran queries until I got correct results. Non trivial subqueries required. Leave yourself plenty of time for this. Waited extra week afterwards to find time when Amazaon interviewer was available. Also interviewer in Seattle, if in New York, you are 3 hours later. Actual interview, screen share, uses Amazon Chime, but not video though it has video capability, or my interviewer elected not to use, don't know policy . Typical beginning of interview, interview intro, your intro, what you do now. Coding uses livecode, simple text editor, unable to run or see static analysis. Write some sql, write schema for data warehouse, python coding, see below for details. Ended with interviewer session of "Do you have questions for me?"

Very difficult process it took me a round 1 month to get back what’s the review for the interview so I think overall it’s bad experience and difficult interview process while it has lot of questions I wa able to answer