Creating the Datapipelines to extract 500 tables at once and apply transformations and load into Analytical DB

Hi i have some scenario based question in hadoop
In relational database (OLTP) which has 600 tables i want to fetch only 500 tables of data on daily-basis and while before loading into any analytical database on all 500 tables we want some transformations on each of the table like filtering, applying join using reference table
Can anyone please respond, how we can achive/creating data pipelines to load into analytical database using hadoop with low latency in like 5 - 10 mins?

appreciate your response!