Data Modeling:

Asked to design a data model for employee transfers within Amazon.

• An employee would apply for a transfer from one team to another
• The HR would review and approve / deny the transfer
• Design a data model that would help in reporting on the count of employees accepted/ denied for transfers.

SQL:

Easy Medium SQL questions involving CASE WHEN, JOINS, subquery

Python:

Given a CSV file, remove the duplicates from that file and output a new file containing the duplicate values.

LPs:
Tell me about a challenging project you worked on and what did you learn from it.