Job Title: Oracle ODI with ETL
Location: Remote
Duration: 6-12 Months
Only USC, GC or GC EAD
Requirements:
The Developer will be responsible for the following:
. Maintenance, optimization and governed enhancements to the local data environment, on several SQL servers
. Resolving abends and job failures of SSIS packages local SQL servers
. Developing and changing existing ETL, in stored procedures, FTP and SSIS packages
. Validation and monitoring of ETL feeds
. Responding to update issues from vendors into the data environment
Projects:
Stack used:
. DW - Oracle 19C
. ODI - Oracle Data Integrator
. SSIS to push data into Oracle DW
. Oracle Spatial and Graph MUST HAVE
Project - ED PI Data Quality Improvement:
. This team is expected to help build Data Quality detection algorithms
. Original they used SQL Server environment but is now all in Oracle.
Regards,
Manoj Kumar