I’ve worked with Apache NiFi for similar use cases, and it can be quite effective, depending on your ETL requirements.

What works well with NiFi:

• It easily connects to HDFS and Oracle.

• Visual interface makes it easy to design and manage data flows.

• Good for tasks like filtering, routing, and basic transformations.

• Built-in scheduling and monitoring features are helpful.

Limitations to keep in mind:

• Not ideal for complex transformations—you may need to use external tools like Spark.

• Lacks advanced data quality, metadata, and governance features found in tools like Pentaho or DataStage.

• Enterprise support and version control are more limited unless you're using NiFi within a commercial platform like Cloudera.

For data quality, governance, version control, and enterprise support, I would suggest using Data Flow Manager. With this, you can deploy NiFi data flows using its graphical user interface, version control your NiFi data flows, and get support all the time from experts.