Data Engineer for the Global Services division, primarily for warehouse services products. The Data Engineer was expected to work with a team of a few engineers to migrate from legacy software (Microsoft MySQL) to AWS. There were no DevOps or backend engineers, so Data Engineers were expected to create the entire pipeline, from creating an EC2 VM all the way to storing data in Redshift for BI teams. No Agile methodologies were in place; tasks came in ad-hoc.

I had my first interview directly with a Data Engineer (DE) working on the team.

He began by asking questions about my background, followed by some scripted questions such as, "How many years have you worked with SQL?"

Next, he posed some basic data modeling questions, like "What is a primary key, and how does it differ from a unique key?"

Following that, we moved to a quick LeetCode-style live coding session.

I was asked one SQL medium-level question and one Python easy-level question.

The SQL medium question required two subqueries and a window function. The Python question involved reversing a string.

Finally, he left me with approximately 15 minutes to ask my own questions.