. Should have very good exp in writing complex queries in Hive, SQL
2. Very good in all joins available in hive. Should have performed multi-table join queries.
3. Experience in Partitioning and bucketing are base minimum
.4. Should have exp in Performance turning and query optimization in Hive.
5. Should be able to perform data analysis using all the Analytics function (like, Rank/Row_Num/Densr_rank/Lead/Lag/etc..) in Hive
.6. Exposure to Dimensional model and data warehousing is necessary.
7. NO Data ingestion and data cleansing exp is needed, but nice to have.
