KMD, 2015

Pitch

As a freelance EDW Developer at KMD, I worked full-time on-site within the EASY-A team on the EASY-A project, where I delivered backend solutions for ETL, data source integration, and database optimization in a large system landscape, and where the focus was on keeping data flows stable and predictable so the system could support vocational school administration, in close collaboration with the team and with interfaces to the Agency for IT and Learning (STIL).

Key outcomes

Stabilized ETL and integrations surrounding EASY-A by systematically working with data processes and database optimization, making operations more predictable within a system landscape with many dependencies.
Improved performance on selected flows once stability was established, making runs and load handling more robust in daily operations.
Managed changes in file-based deliveries, typically format changes (and often missing content), by making ingestion and validation more robust so that input variations did not automatically lead to downstream failures.
Provided backend development and support in close collaboration with the EASY-A team and with interfaces to the Agency for IT and Learning (STIL), ensuring tasks and changes were clarified and handled without disrupting operations.

Work in detail

Other parameters: Scope: Full time, with a few planned absence days for on-site days at Brüel & Kjær; Employment type: Freelance via broker (Mind4IT, now TwoDay); Work style and location: 100% on-site in Ballerup (Ballerup Vest); Context: The EASY-A project, working with backend solutions for ETL, data source integration, and database optimization in a large system landscape.

EASY-A and the framework for the work

I worked full-time on-site in the EASY-A team at KMD on the EASY-A project, where the solution was part of a large system landscape and needed to function stably in daily operations, while continuous changes and new requirements emerged through the collaboration between the team and the Agency for IT and Learning (STIL).

ETL and data source integration

My work was centered on backend solutions for ETL and data source integration, where data had to be ingested and made usable within the system's data foundation so that functionality and administration could be supported in a uniform manner.

File-based deliveries and robustness

Integrations were primarily built on file-based deliveries, and a significant part of the task was to handle changing inputs—typically format variations and often missing content—by making ingestion and validation more robust, so that input changes no longer caused errors or instability further down the flow.

Stability before performance, with a focus on SQL and procedures

Database optimization initially focused on stability and subsequently on performance, with the primary focus on SQL and procedures to make data processes more predictable in operation and to ensure the most demanding parts could be executed more robustly.

KMD (2015)

Timeframe and context