RPA to Automate ETL Processes in Data Warehousing

Tapan Kumar Rath, Sibaram Prasad Panda

Abstract: Robotic Process Automation (RPA) is an automation technique that utilizes scripts and robots to execute repetitive tasks in a business process. RPA can free up humans to perform more logical tasks that require reasoning, judgment, and emotions, while robots are programmed to do mundane and monotonous recording and processing tasks. RPA can perform these processes with a high level of accuracy and less time. RPA is implemented for automating the repetitive tasks performed in enterprise applications. RPA can be applied in areas such as finance, management, cybersecurity, healthcare, travel, and logistics. RPA finds its applications in sectors such as record keeping, compliance, cyber security, technical support, and more services. RPA provides faster and more reliable processing of the Automation at a reduced cost. Most of the developed companies have started investing in RPA. There is also a huge market potential in RPA.

Keywords: Robotic Process Automation (RPA), Extract-transform-load (ETL), OLAP cubes, OLTP schemas, cyber security, Mapping Data Flows, CRM