I think you're using wrong approach to use JSON_EXISTS
, please try the below one:
select
data
from test
where JSON_EXISTS(
data::jsonb, -- convert your data to jsonb first
'$.criteria.employee_id.in' -- corrected path of your expression
);