Pentaho Data Integration capabilities facilitate the process of capturing, cleansing, and storing data using a uniform and consistent format that is accessible and relevant to solve many of the data integration challenges.
Testing ETL process can be accomplished using PDI embedded engine and Cucumber. Developed a java based tool which provide set of HTTP endpoints for automating ETL testing using Behaviour Driven Development framework Karate and Pentaho Data Integration. You can use it to execute PDI job/transformation or running Karate feature file to produce cucumber reports.
See https://github.com/aliakkas/karatepdi for more information.