I was losing my mind over this so I made a simple change in my staging table (EDMPROD.MQT_STB_FACTS).
Instead of typing the columns as characters and then casting them as bigint, I dropped and recreated my table with the datatypes set to BIGINT(8).
I removed the castings from my SQL statement and the error went away.
Go figure..........