ETL Developer for Automation Task (SSIS and PowerShell Expert)
Budget: $10 – $30 USD
I need an ETL developer to streamline and automate an existing manual process. This includes:
- Transferring two encrypted *.csv.gpg files from a source server to a local machine.
- Decrypting these files into *.csv format.
- Running SQL on one file and a PowerShell command on the other file to create a staging table.
- Setting up a Microsoft SQL Server database into read-write mode from read-only.
- Reverting the database back to read-only upon task completion.
- Sending a report to the user upon task completion.
Ideal skills for this job include advanced SQL, PowerShell, and ETL development. Familiarity with read/write permissions on Microsoft SQL Server and experience with data transfer and encryption/decryption processes are also highly beneficial.
- Transferring two encrypted *.csv.gpg files from a source server to a local machine.
- Decrypting these files into *.csv format.
- Running SQL on one file and a PowerShell command on the other file to create a staging table.
- Setting up a Microsoft SQL Server database into read-write mode from read-only.
- Reverting the database back to read-only upon task completion.
- Sending a report to the user upon task completion.
Ideal skills for this job include advanced SQL, PowerShell, and ETL development. Familiarity with read/write permissions on Microsoft SQL Server and experience with data transfer and encryption/decryption processes are also highly beneficial.