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 www.DeepL.com/Translator