Leverage Python to build robust data processing scripts, handle file formats, and interact with APIs.
Develop a Python script that extracts data from a public REST API, transforms the JSON response, and loads it into a SQLite database.