How would you automate the extraction of data from an internal API, transform it, and load it into a centralized database for AXA XL Insurance?