I don't doubt a particular test statistic aiming to accomplish what your asking for exists, but I will offer some alternatives that you may be interested in that offer different answers (but probably still interesting) given the nature of the question.
Like Rolando already stated, the extent to which the partial correlation is moderated depends on the correlation between the three variables. Below I have inserted a picture of the situation in the form of a path diagram (and you can just pretend the box with X is demographic dissimilarity, Z is career development, and Y is satisfaction). The test for whether the direct correlation between X and Y is different than the partial correlation of X and Y controlling for Z amounts to stating whether the blue line and the red line in the below picture are non-zero. So simply examining both of those correlations will be informative. If the product of those correlations is near zero, then the direct correlation between X and Y will be largely unchanged when partialling out the variance of Z.

Another test you may be interested in would be a likelihood ratio test. In this example you have a case of nested models, and hence you can test the model with only the direct correlation between X and Y and the model that includes both X and Z. This can be more easily extended to multiple Z's as well. But this is not the same as testing whether the effect of X is moderated by Z(s), but whether the model including X and Z is a better fit to the data than the model only including X.
Some might interpret this question as asking about moderating and mediating effects. By the names of the variables though I wouldn't immediately suggest these are what you are after. Kline (2010) has a few references regarding these, so those might be a good forray to search. Although to conduct those tests it appears you need to make much stronger assumptions about causality (Frazier, Barron, & Tix 2004 PDF).