ETL Troubleshooting & Fixing for Data Load
Budget: $250 – $750 USD
I am experiencing issues with my ETL process. The main focus is on the loading data phase, as this is where the problems seem to arise. The ETL code, which is written in C#, pulls data from ServiceNow and attempts to load it into SQL Server database tables. Additionally, the developer used PowerShell for web scraping from SharePoint and Azure, with the data also intended for SQL database.
The loading process is failing, and while there are some error messages, they are often unclear. Despite my attempts at troubleshooting, I have been unable to resolve the issue. I need someone with strong skills in C#, SQL Server, and PowerShell, along with experience in ETL processes, to help diagnose and fix these problems. Understanding and interpreting error messages and making the necessary corrections to the code and process is crucial.
Key skills and experience required:
- Proficient in C# and SQL Server
- Experienced in ETL processes
- Familiar with PowerShell for web scraping
- Strong problem-solving skills
- Ability to interpret unclear error messages
- Previous experience with ServiceNow and Azure is a plus.
The loading process is failing, and while there are some error messages, they are often unclear. Despite my attempts at troubleshooting, I have been unable to resolve the issue. I need someone with strong skills in C#, SQL Server, and PowerShell, along with experience in ETL processes, to help diagnose and fix these problems. Understanding and interpreting error messages and making the necessary corrections to the code and process is crucial.
Key skills and experience required:
- Proficient in C# and SQL Server
- Experienced in ETL processes
- Familiar with PowerShell for web scraping
- Strong problem-solving skills
- Ability to interpret unclear error messages
- Previous experience with ServiceNow and Azure is a plus.