@RuslKor Do you have access to NIFi?
What you describe is a perfect Use Case for NiFi and something I have a lot of recent experience (kafka to hive). I have also recently worked with NiFi 1.10 and the new Parquet Readers, which can very easily convert parquet to csv & avro for external tables. Going deeper Nifi can also convert to ORC and insert into Hive native tables.
Perhaps if you comment more on the tools you want to use, myself or other contributors can provide more specific examples or details.