I am reading from Kafka in text format (as JSON format not supported) and trying to convert the JSON string into an actual JSON for flattening and pivoting. My sample data looks like below.

{"text":"\d0000\d0000\d0000\d00007{\"Employee\":{\"Address\":[{\"Addressid\":\"3897ef\"}],\"Role\":{\"Designation\":{\"name\":\"Manager\"}}}

I want to convert as follows

{
    "Employee": {
        "Address": A
            {
                "Addressid": "3897ef"
            }
        ],
        "Role": {
            "Designation": {
                "name": "Manager"
            }
        },
}

How can I covert this into a list map JSON hierarchy as above?