04.1_ETL_Customers

The company has two branches: one in the United States and another one in Europe. New US customer data comes from a web service. New Europe customer data comes from Amazon S3.

We access, validate, prepare, and blend the data, anonymize it, and insert it to the database table "customers".

Here, we additionally export the final status of the workflow. In the case some processes fail, we notify responsible people via an automated email.