I have a scenario to migrate SQL Server tables(30- 40 tables) to Oracle. I Cannot depend on SSIS as the no of tables to be migrated to Oracle will change regularly and I cannot always create or update a DFT when ever there is a change in schema.
Is there any other way where the movement of data can be handled dynamically and can work effectively ? Like using Python or any other Programming languages ?
Here is the approach I have decided to go considering the time constraint( using C# is taking more time).For 8 GB table it is taking 11 minutes to move the data SQL to Oracle.
Steps:

Dump the SQL tables data into flat files.(Used BIML for automating
the DFT creation) 
Transfer these flat files to the Destination server.
Using SQL*Loader to load data from flat files to Oracle.
Migrating multiple tables data from SQL Server to Oracle