The issue is that you have not provided a name for the zip-files it will create.
find /home/user/rep/tests/data/archive/* -maxdepth 0 -type d -exec zip -r "{}" "{}" \;
This will create separate zipped directories for each of the subfolders tmp tmp_dkjg and tmp_dsf