Initially, I applied for the Cloud Data Engineer position. They asked if ETL Consultant would be a good fit for me, and I agreed.

HR interview: Asked general HR questions and AWS Cloud questions (from a sheet she had).

Technical interview: SQL Windowing function query. Complex AWS questions on VPC, Route 53, A name, and C name. He was basically testing my approach to solutions.

Behavioral interview: "Tell me about yourself" and "any complex data project you worked on."

I was offered the position, and the name was Solutions Analyst. Seriously? When I applied for one position, got called for another, and was given a third position. Also, Analyst? You take interviews on cloud and data architectures, then you should at least give some senior position and not an entry-level analyst position.

I also suggest you try applying and asking HR about what role you will be placed in.

Low salary compared to other Data Engineer positions.

SQL windowing query involving date functions.

AWS Solution Architect questions on VPC.