Kern Energy interview question

How to design ETL pipeline and databases