I am new to Dev Test. I am aware that it is mainly used for service visualization and web service automation. I just want to check if it is the right tool to automate the ETL business rules.
Depends. Is your ETL logic you are trying to test and how do you want to use the tool.
Scenario1: Batch process File from Input System -> ETL Logic -> Output file with transformed values to target system
Scenario2: Real time process Real time msg (webservice, soap, rest, http) -> ETL Logic -> Real time msg to target (webservice, soap, rest, http) with transformed values
Suitable for triggering and running the tests
Not suitable for validating the ETL rules
Scenario3: Real time or Batch MQ Msg from Input System ->MQ -> ETL Logic -> MQ ->Output msg with transformed values to target system
Suitable for validating the ETL rules
Retrieving data ...