Applying the following patch to the version of sssd currently available in CentOS/RHEL 7.6 resolved this intermittent lookup issue for us:
https://patch-diff.githubusercontent.com/raw/SSSD/sssd/pull/811.patch
May be useful info for others given 7.7 release (and CentOS update) could be some time away sti..
Carwyn