Enables 3-keto sterol reductase activity; 5alpha-androstane-3beta,17beta-diol dehydrogenase activity; and estradiol 17-beta-dehydrogenase activity. Involved in animal organ development and cellular hormone metabolic process. Acts upstream of or within several processes, including cholesterol biosynthetic process; embryonic skeletal system development; and nervous system development. Located in endoplasmic reticulum membrane. Is expressed in several structures, including autopod; branchial arch; eye; nervous system; and spleen primordium. Orthologous to human HSD17B7 (hydroxysteroid 17-beta dehydrogenase 7). [provided by Alliance of Genome Resources, Apr 2022]