Comparative Analysis of ETL Tools in Big Data Analytics

  • Asma Qaiser Department of Computer Science, Iqra University, Karachi 76400, Pakistan
  • Muhamamd Umer Farooq 2Department of Computer Science nd Information Technology, NED University of Engineering & Technology
  • Syed Muhammad Nabeel Mustafa NED University of Engineering and Technology
  • Nazia Abrar College of Computing & Information Sciences, Karachi Institute of Economics & Technology, Karachi 76400, Pakistan
Keywords: Big Data Analytics, Big Data, ETL, Comparative Analysis


Massive amounts of data are being generated these days all around the world. The majority of social networking platforms, ecommerce sites, the public and private sectors, healthcare institutions, cloud networks, and various servers are all generating immense amount of data. Collected data from various sites could be in a structured or unstructured format. Extract Transform Load (ETL) is a crucial component of the growing demand for quicker business decisions aimed at many contemporary applications. Due to the volume and speed of data, real-time ETL is built on the foundation of multi-source, unstructured data stream extraction and transformation employing disc data in dispersed environments. The entire procedure is pipelined while processing so that the final resultant data can provide some essential and useful conclusions to work on. Some analytical findings are once again helpful in making decisions. However, the produced results may differ in some numbers, graphs, and figures in many circumstances. This occurs as a result of the usage of some unrealistic tools for big data processing. This paper proposed several methods and appropriate ETL (extract, transform, and load) tools for the big data processing, which may result in appropriate analytics and conclusions from the data.

How to Cite
A. Qaiser, M. U. Farooq, S. M. Nabeel Mustafa, and N. Abrar, “Comparative Analysis of ETL Tools in Big Data Analytics”, PakJET, vol. 6, no. 1, pp. 7-12, Jan. 2023.