Less than 1 week –
Less than 10 hrs/week –
We are looking for expert advise for a building a large data warehouse that will start at 3TB and should scale up to 10TB in the future (in a couple of years).
Reliability and security are of at most importance as the use case is for storing financial transaction data.
We need help on
a) Choosing the database technology - Postgres, Oracle, Columnar stores (prefer cost effective solutions)
b) ETL design strategy - there are around 2 OLTP DBs and around ...