Hi,
I am sathya currently working for Harman International and I have 3.5 yrs of real time Hadoop Experience which includes Hive,Impala,PIG,MR,SQOOP,FLUME and also i am Hortonworks Certified Hadoop Developer. I have done 3 major projects of Migrating the code from pl/sql,mainframes codes to Hive,Impala and I am very much aware of pros and cons of hive and hadoop very much in practical.
As your project requires code in hive,so I can do that and make you satisfy.
Thanks,
Sathya