Automate SOAP Data Extraction to Oracle DB

I need an automated process to extract customer data from a SOAP service in XML format and save it into an Oracle database. The extraction process should be automatic and require data transformation before saving.

Requirements:
- Connect to SOAP service
- Extract XML customer data
- Perform necessary data transformation
- Insert data into Oracle DB
- Ensure process runs automatically, without manual intervention

Ideal Skills & Experience:
- Proficiency in handling SOAP and XML
- Experience with Oracle DB
- Strong data transformation skills
- Background in automation scripts or tools