SQL Questions which will require knowledge on RANK(), SUM() OVER(). I suggest HackerRank SQL for handling the SQL questions. Knowledge of LEAD(), LAG(), and knowledge of HiveQL will be great, though HiveQL is not a mandatory skill but it definitely adds weight to your candidature. In case of HiveQL focus on Partitioning and Bucketing concepts and get an idea on how Map-Reduce thing takes place in an distributed environment. Basic Tableau Stuffs. Some of Python DataFrame operations like creating a DF from dictionary or list of tuple.