Join 500+ Software Testing professionals. Solve problem and get your problem solved. Register Now!

ETL Testing Tools

Open 2 Answers 72 Views
0 2

I would like to know Top 15 ETL Testing Tools (NOT ETL Tools). I have found few like:

1) Informatica Data Validation

2) QuerySurge from RTTS

3) iCEDQ

4) Datagaps ETL Validator

5) QualiDI

6) Talend Open Studio for Data Integration

7) Codoid's ETL Testing Services

8) Data Centric Testing

 Can anyone list few other ETL Testing Tools?

2 Answers

ETL is a concept through which applications are built, like OOPS concepts.

ETL stands for Extract Transform and Load.

Say, you have a marketing team that fetches data from different sources like Facebook, Twitter, Google AdWords, etc.

Your marketing team creates the consolidated report of how much amount is spent in total and the ROI.

Now, your marketing team is doing everything manually. Like they log in to each portal, download the data and consolidate in an Excel file. Apply some business logic and send it to the CEO.

Doing this every week or month will be the tedious task.

Now, your IT team uses a tool you have mentioned above or develops their own that takes data from each portal mentioned above like Facebook, Twitter, and Google AdWords. That is Extract.

Now you apply business logic on top of it, that is transform.

You load this data through BI tools. i.e. Load.

So, as a tester, you should make sure that the tool or software you are using is good enough to move data from one place to another.

You should be checking Performance of DB when lots of data is loaded.

Make sure that all data are transformed properly and all business logic is in place.

So, you can use the same tool from above list to build your test suite.
answered by (872 points)
commented by (748 points)
Well explained , I  don't know  what is ETL but after reading this i taken some rough idea.Thanks for sharing
commented by (872 points)
I am glad that it helped

ETL is the combination of Extraction, Transformation, and Loading and it is basically used to transfer data from one database to another for performing various operations over the data.

Below is the list of ETL Testing Tools preferred by software testing company:

  • Informatica Data ValidationQuerySurge
  • Datagaps ETL Validator
  • Codoid’s ETL Testing Services
  • QualiDI
  • Talend Open Studio for Data Integration
  • Data Centric Testing
  • SSISTester
  • GTL QAceGen
  • Zuzena Automated Testing Service
  • DbFit
  • AnyDbTest
  • 99 Percentage ETL Testing
  • TestBench
answered by (408 points)

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.