This isn’t possible to do using a Matillion transformation component. As my colleague mentioned, you’ll need to use the Orchestration SQL Script component in order to perform a delete. You can’t pass the keys to delete into an orchestration job in that way, so you’d need to replicate your filter in SQL in the orchestration component. Please see this document for the required syntax.
By the way, you may find that it’s quicker overall to create a second table without the records you intend to delete, and then use the second table. You can do this in a Transformation job, and this is mainly why we didn’t include a Delete transformation.