Oracle-SQL Server ETL Integration
Budget: £250 – £750 GBP
I need to wire an Oracle 19c database into an ETL workflow that pulls data from existing relational sources—mainly Microsoft SQL Server and another Oracle instance—and stages it for downstream reporting.
The job covers:
• designing or refining the extraction logic from both SQL Server and Oracle
• transforming the datasets so they match the target Oracle schema (PK/FK integrity, datatypes, time-zone handling, etc.)
• loading the cleansed data into Oracle with repeatable, schedulable jobs
I’m open to whichever toolchain you feel is fastest and most reliable—Oracle Data Integrator, SQL Server SSIS, Python with cx_Oracle and pyodbc, or a comparable approach—as long as the final workflow can be automated, logged, and easily handed over.
Done means: the full ETL runs end-to-end without manual tweaks, error handling is in place, and I have clear deployment notes plus the source scripts or package definitions.
The job covers:
• designing or refining the extraction logic from both SQL Server and Oracle
• transforming the datasets so they match the target Oracle schema (PK/FK integrity, datatypes, time-zone handling, etc.)
• loading the cleansed data into Oracle with repeatable, schedulable jobs
I’m open to whichever toolchain you feel is fastest and most reliable—Oracle Data Integrator, SQL Server SSIS, Python with cx_Oracle and pyodbc, or a comparable approach—as long as the final workflow can be automated, logged, and easily handed over.
Done means: the full ETL runs end-to-end without manual tweaks, error handling is in place, and I have clear deployment notes plus the source scripts or package definitions.
Related categories:
Data Processing
SQL
Oracle
Database Administration
Database Development
Data Integration
ETL
Data Management