Dieses IT-Projekt ist Teil unserer Digitalisierung und Optimierung der IT-Landschaft unserer Kunden. Durch gezielte Maßnahmen fördern wir den technologischen Fortschritt, optimieren systemübergreifende Prozesse und schaffen eine nachhaltige Basis für zukünftige Entwicklungen. Unsere IT-Referenzprojekte dienen als Grundlage zur Orientierung. Sie unterstützen die Wiederverwendbarkeit erprobter Konzepte im Rahmen der Projektumsetzung.
Dies ist eines von 4929 IT-Projekten, die wir erfolgreich mit unseren Kunden abgeschlossen haben.Wobei dürfen wir Sie unterstützen?
Integration of event data from IoT data (stored in Snowflake)
Projektdauer: 5 Monate
Kurzbeschreibung
PTA is responsible for extending an existing .NET application to include the integration, processing, and display of IoT event data from a Snowflake data lake. To this end, an automated import and consolidation process is being developed that utilizes Azure Functions, Azure SQL Database, and Snowflake. As part of this process, merge logic will also be implemented to efficiently combine events that are conceptually related and load them into the target system.
Ergänzung
The processing and visualization of additional event data will be expanded. To this end, the business requirements will be analyzed and coordinated in collaboration with the business unit and the data providers. An automated import process will be implemented as an Azure Function that calls an endpoint of the application and thereby retrieves the event data stored in Snowflake. At the same time, consolidation and merge logic is being developed to correctly merge events delivered over several days. The consolidated data is persisted in both an Azure SQL Database and Snowflake. In addition, existing SQL and Snowflake queries are being optimized for performance, production database migrations are being analyzed, and errors are being resolved.
Fachbeschreibung
The technologies used include C#, .NET, Azure, Azure Functions, Azure SQL Database, and Snowflake. The functional and technical focus is on the integration and processing of event data, the development of automated import processes, the consolidation and merging of data from various sources, and the persistence and visualization of processed events. In addition, key responsibilities include the development and integration of REST endpoints, the optimization of SQL and Snowflake queries, the analysis of database migrations, and troubleshooting in a production environment.
IT-Projektdaten
- Branchen Energie
- Fachaufgaben energy supply
- DV-Aufgaben customised software further development
- Systemumgebungen Client/Server
- Vorgehensmodell Scrum
- Datenbanken Azure SQL DB, Snowflake
- Entwicklungs- und Testtool .NET Core, Azure Functions, JetBrains Rider
- Middleware und Frameworks Microsoft Azure
Projektzeitraum01.01.2026 - 01.06.2026
Kunden, die uns vertrauen
Haben wir Ihr Interesse geweckt?
