- 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.