Airbyte by itself is an EL-only tool for the most part. However, we offer basic normalization for most sources and offer deduplication for sources that support integrations with dbt. Learn more about deduplication here.
We have a direct integration with dbt which allows you to use your own custom transformations in Airbyte. You can find a tutorial on that here.