This project has the following objectives: Reprogramming, testing and implementing HAL ETL code, currently written in legacy SAS language, into SQL/ Python language, to prepare HAL for receiving ETL data from the new DSSURS environment hosted in AWS and for the future migration of HAL to the OHA ODE (Oregon Data Environment) cloud Azure environment (NOTE: The migration to the ODE cloud, expected to occur in the next 1-2 years, is out of scope for this project and will require working with OIS and other OHA teams). This work anticipates development and conversion of ETL pipelines, data tables and data processes and delivery of other HAL code updates in the current HAL on-premise environment, in which OHA currently ingests ETL data from the DSSURS data environment hosted in AWS cloud, but will also require continuity as OHA is preparing for the future migration of HAL to the OHA ODE (Oregon Data Environment) cloud Azure environment.