Assuming skillset is the name of the column containing the technologies and your table is called yourTable:
SELECT *
FROM yourTable
WHERE skillsetLIKE '%kafka%';
However it is not advised to store data in a non-normalized fashion like your skillset column.