There used to be a massive difference. Mostly because debian had apt-get and Redhat had just rpm. That's why we still have sites like rpmfind. Nowadays there is not that big of a difference from end user point of view.
As a dev I still love dpkg-buildpackage way more than rpmbuild.
As a dev I still love dpkg-buildpackage way more than rpmbuild.