data engineer -- 2
€8-30 EUR
Pagado a la entrega
Data:
Two Raw Data tables are attached in separate sheets: orders and merchants.
Tasks:
Import raw data tables in the Snowflake environment (you can request trial from Snowflake);
Create an ETL pipeline to transform raw, unstructured Data into multiple relational tables. One should comment their thought process while preparing the pipeline;
Add additional cleaning for Data, where they see it is required;
Once all data is transformed, one should create a summary table(s), in a way that BI Analyst could use it to build report that answers following questions:
How many orders per day are created?
per each shop
per each print provider
per each sku
How many order items per day are created?
How many order items on average there are within one order?
Run the pipeline and save a newly created tables;
Export tables in a valid .csv format, compress them;
One should draw high level data model of created tables showing relations between them;
Expected outputs:
Pipeline code with comments
Preferably in Private git repository (e.g. GitHub)
Preferably written in Python
Compressed .csv file with created tables
Data model drawing
Nº del proyecto: #37427961
Sobre el proyecto
15 freelancers están ofertando un promedio de €20 por este trabajo
Hello sir, I am an expert in Python and Snowflake. I can handle this project as required. Please contact me for more details. Best regards!
Hi there, hope you are doing well. I am experienced in Python programming for PC, Mobile and Website development. I read the description of your project. I can help you do this with Python. I can build this project fro Más
Hello Dima R.. I have read all requirements for your project "data engineer -- 2" carefully and understood what you want. As a senior full stack developer, I am very strong with Python and Snowflake, and I have done ma Más
Hi there! My name is Zhenis and I am a professional Python developer with 5+ years of experience in the field. I understand that you are looking for someone to help you with your data project and I feel confident that Más
I understand that you are looking for a data engineer to help you import your raw data tables into the Snowflake environment and create an ETL pipeline to transform them. With my expertise in Python and data visualizat Más
Hello, there. I have read carefully your details "data engineer -- 2" and can implement your project quickly. I absolutely love this job description. The first reason I love this job is because I can tell there is a lo Más
Hi I have experience working with Snowflake for the ETL task would accomplish your task .Hoping to start working soon with u
Hi, With 10 years of experience in data engineering and expertise in Python and Snowflake, I am poised to deliver a high-quality solution which feet your needs. Let's discuss
Hi there, I am student in Python programming for PC, Mobile and Website development. I read the description of your project. I can help you do this with Python. I can build this project from scratch through design, int Más
