Insert / Select / Update records in database using File with 5-6 million records(10 MB)

Content

We have scenario as per below :

1) Customer will provide the datafile on SFTP server.

2) OIC should read the file from SFTP server and insert all the records in database.

     Is there a way to invoke the SQL loader on DBCS from ICS one ics move the file to DBCS server ? Otherwise if ICS each record in DBCS then it will be performance issue.  I have read we can insert mutliple record in single insert statement but need to know if will help for such a large volume.

3) OIC should read the file from database and create new file with new format by applying transformation rules.