When we are testing manually data is inserting for new employee from success factors to Data base.
When the process is schedule to run then data is not inserting to Data base.
Can you please attach a snapshot of the process report for this particular execution.
Also make sure, if the process is running successfully , then in the advanced options tab at the connection level you have not checked 'write sql to file'.
If this would be a case ,connector just writes an sql and drops query file to a directory but insert does not happens actually.
Besides the previous comments, make sure you have deployed the same version you used when using test mode.
Retrieving data ...