Job details

Complex product data manipulation (ETL) with Python, Excel or Google Dataprep


1 month ago

Good day

we are looking for a freelancer with experience in data warehousing and ETL for data preparation of our products. The freelancer should work together with us on this first project with a relatively simple data structure. In the coming months further connections of suppliers will be added. We are therefore interested in a freelancer with the will for a long term cooperation.

Output file is always a supplier export. The first step is to prepare the existing data in such a way that a master and single product structure is created. In a second step the deltas of different values (for example delivery times, option values, dimensions, media, new products and so on) are extracted for a matching table. In a third step, the matching tables are processed manually (not a freelancer's job!). In a fourth step, the now complete data is merged and prepared in such a way that an import via CSV/Excel file into the existing Magento store system is possible.

The existing two suppliers are currently being prepared via google Dataprep. We are open for new technologies and ways how this could be done.

We ask you to give us examples of similar projects and approaches.


Translated with (free version)
  • $1,500
  • Expert
    I am willing to pay higher rates for the most experienced freelancers Experience Level
  • Project Type: Ongoing project

Skills and Expertise

Data Processing Languages
Python Jobs Excel VBA Jobs

Activity on this job

  • 15 to 20
  • Last viewed by client: 1 month ago
  • Hires: 1
  • Interviewing: 2
  • Invites sent: 6
  • Unanswered invites: 2

About the client

4.97 of 62 reviews
  • Switzerland
    Gossau 11:17 am
  • 88 jobs posted
    85% hire rate, 1 open job
  • Member since Sep 2, 2014