For the load process, bump it up to a premium service tier so you have more memory and faster processing, then bump it back down when the load is done.

I agree with @FridayNightGiant, break up the transactions. For large loads that's the way to do it anyway.

Also, get rid of the indexes for now and replace them after the load. That'll speed up the transactions.