Airbyte is focused on the EL of ELT. If you need a really featureful tool for the transformations then, we suggest trying out dbt.

https://docs.airbyte.com/understanding-airbyte/basic-normalization (looking into custom dbt transformations now)

Also you can apply custom transformations in the landed data using dbt