logo
logo
Sign in

Roles and responsibilities of etl developer

avatar
Entony Green
Roles and responsibilities of etl developer

Many people don't know or misunderstand the meaning of ETL developer. In this post I will try to explain. 

E for Extract

All business data is stored in one place — the Data Source Layer. At the same time, all this data is divided between numerous software and structured in various formats. 

T for Transform

Once data collection starts, all data needs to be stored in the place called Staging Area.

L for Loading

It’s a final frontier of all ETL processes. All the data collected and transformed previously is loaded into the Warehouse Layer. 

Among other ETL developer responsibilities are the following:

  • ETL process management
  • Data modeling
  • Warehouse architecture modeling
  • Data pipeline creation
  • ETL tools development
  • Testing (QA, ETL)



collect
0
avatar
Entony Green
guide
Zupyak is the world’s largest content marketing community, with over 400 000 members and 3 million articles. Explore and get your content discovered.
Read more