You are tasked with developing a batch processing solution for a large e-commerce company that needs to process millions of transactions daily. The solution should be able to handle upserts, revert data to a previous state, and configure exception handling. Additionally, the company wants to integrate Jupyter or Python notebooks into the data pipeline for data exploration and analysis. How would you approach this task?