After the OA and phone screening, there are 4 rounds in total.

Two technical rounds are followed by a hiring manager round and a bar raiser round.

General focus areas include SQL, Python scripting, and technical deep dives based on project experience.

• All three rounds might include SQL.
• One or two rounds might include Python, depending on the team and the role's demand for scripting.

SQL questions often revolve around using CTEs, Window functions, and Joins. Knowledge of ETL frameworks or Big Data tools like Spark, Glue, Airflow, Kinesis, or datastores like Redshift is covered, along with AWS services.

The Bar Raiser round focuses mainly on Amazon's Leadership Principles.

SQL Given a sales table (product, year, capital, units, cpu), calculate profit per product per year. Find the highest profit gained per product each year.

Python Find the first recurring character.