can you list few ETL testing tools?

Question

We have a project where we have to do database testing. We have huge data and we are following ETL process. Everything is hosted on Azure. Can you help me with list of few tools which can help me do ETL testing?

Answer 1

Data Migrator (IBI)
Oracle Warehouse Builder (OWB)
IBM Infosphere Information Server.
PowerCenter Informatica.
Elixir Repertoire for Data ETL.
SAP Data Services.
SAS Data Management.

Answer 2

To find the ETL tool, which is compatible with source and target systems, is extremely important and one of the major exercise in ETL testing.

The potential of the ETL tool to extract data from the systems can significantly reduce the processing time. Further, there are many ETL tools which can provide performance enhancing technologies.

Here is the list of some popular ETL tools used by popular QA Services providers:

• Informatica − Power Center
• SAS − Data Integration Studio
• Oracle − Data Integrator ODI
• IBM − Cognos Data Manager
• IBM - Websphere
• Oracle Data Integrator ODI
• Microsoft – SSIS
• SAP BO Data Services (BODS)
• Clover ETL Open source