Ben Spouse - Data Engineer / ETL Developer

München, Germany

Experience

Sep 2023 - Present

1 year 6 months

Leipzig, Germany

Data Engineer/ ETL Developer

Deutsche Bahn

Development of DB Tarif Data with Talend ETL tool
SQL Development in PostgreSQL DB in connection with DB'S IPP DWH
Extraction /Transformation and loading of data with complex ETL jobs.
Migration from Talend 7.3 to Talend Enterprise Cloud edition 8.

Sep 2023 - Present

1 year 6 months

Bremerhaven, Germany

Data Engineer

Deutsche See

DWH development in Oracle with Oracle Data Integration ETL tool
Migration from Linux based Data integration to Fully Autonomous Oracle DB
Extraction of data from Ascii fixed delimited files into Raw Data
Development of flows and mapping of data into Staging environment

Apr 2023 - Jul 2023

4 months

Frankfurt, Germany

Data Engineer

Deutsche Bahn

DWH development in Oracle with Python and SAP BODS ETL tool
Data extraction from Azure Container with Python into Data frames for Staging
SAP BODS ETL tool development of data from Staging into Core and Mart

Aug 2021 - Mar 2023

1 year 8 months

Hagen, Germany

Talend Snowflake Developer

Douglas GmbH

DWH development in Snowflake using Talend ELT with Data vault 2.0.
Leveraged Talend connectors and applied complex business logic to extract data from upstream interfaces.
Performed Data Engineering tasks including complex views for Data Mart
Deduplication and historization, to ensure data integrity for master data.
SAP RFC Interface with Talend BAPI Connector and Data extraction/Mapping

Nov 2020 - Jul 2021

9 months

Stuttgart, Germany

Talend ETL/Tableau Reporting Developer

Daimler TSS

DWH development of data tables for migration
Talend ETL job development for Data Engineering
Rest API with Talend ESB for extraction of data from STARC
Tableau development for data visualization and reporting
Operation Azure Cloud Repository for Talend Project

Jun 2020 - Sep 2020

4 months

United States

QA/ Data Modeling Consultant

Prospect 33

Testing/Development Data Model with Python SKLearn libraries
Consultation and troubleshooting of day-to-day issues
Responsible for QA and testing of Frontend

Mar 2020 - May 2020

3 months

Frankfurt, Germany

DevOps Talend ETL Developer

Helaba Invest

Development of ETL Jobs with Asset management Data Engineering
Development of SQL for complex lookups needed for Oracle DWH
Proof of Concept for migration of complex ETL system to Talend
Talend ESB (JMS based architecture) for data mapping
Presentation of Talend ETL tool to Helaba development teams

May 2018 - Jan 2020

1 year 9 months

Cologne, Germany

DevOps Consultant/Talend ETL Developer

Unitymedia

File transfer job development for ETL Big Data tool Talend
Development of Talend Jobs for Data Engineering
Troubleshooting and bug fixing of Production Data transfer jobs
Automation of ETL processing with Airflow
Application management and optimization of existing application
DWH Job creation and Maintenance Talend, Oracle/DB2/PostgreSQL

Oct 2016 - Apr 2018

1 year 7 months

Munich, Germany

ETL BI Operations DWH consultant

Consors Finanz

BI Operations for Consors Finanz Talend ETL system
Responsible for fixing production incidents and support issues daily
Used Oracle 11g, SQL, Citrix, UNIX scripts, Talend, Job scheduler
Migration from legacy system to SAP ECC with Talend
Development and configuration file transfer tool SOS Job scheduler
Project work in Agile environment, Problem/incident management

Oct 2012 - Sep 2016

4 years

Munich, Germany

Billing application Operations DevOps

Telefonica O2

Billing Operations for o2s entire partner brands system
Responsible for fixing production incidents and support issues daily
Used Oracle 11g, PL-SQL (scripting), SQL, Citrix, UNIX scripts
Responsible for monitoring engines, fixing bugs, writing scripts
Project work in Agile environment, organized reports for Stabi meetings
Carried out web and content deployments using Jenkins on environments

Feb 2012 - Oct 2012

9 months

Düsseldorf, Germany

Test Automation Agile

Vodafone

Carried out Non-Functional tests on Vodafone's Egarage project
Java/Eclipse FitNesse automation suite test execution
Carried out test analysis/updates on FitNesse automation tests
Tested using Oracle tools, SQL Developer, SQL, UNIX scripts
Updated and executed Batch shell scripts on Linux backend servers
Ran system and integration tests with Vodafone shop web systems

Jan 2008 - Dec 2011

4 years

Bern, Switzerland

Senior Test Analyst /Test Manager

Swisscom

Component test analyst for Swisscom Docforms bill layout system
Responsible for full test lifecycle (until E2E) using HP Quality Center
Consulted in an Agile environment working closely with Developers
Tested using Oracle tools, Toad, PL-SQL, UNIX scripts and Pearl
Created and executed detailed Functional tests within system
Ran system and integration tests with upstream and downstream systems

May 2006 - Oct 2007

1 year 6 months

Munich, Germany

Senior Test /DWH Consultant

o2 Germany

Datawarehouse Test for o2's middleware Oracle database
Consulted with development for enhancements and design of application
Responsible for full test lifecycle (until E2E) using o2's Rational test tools
Component tested using Oracle tools, PL-SQL and UNIX
Created test schemas and scripts for simulating a live environment
Completed integrated tests with connecting o2 middleware applications

Mar 2004 - May 2006

2 years 3 months

Salzburg, Austria

Senior Tester/Test Team Lead

Sony NetServices

System Test specialist for Vodafone radio DJ project
Component tested multiple mobile devices and backend systems
Completed field tests and tested backend database system Linux/Oracle
Provided test data through Oracle database using Toad
Planned, wrote, and executed all tests using HP Quality Center
Senior tester for Sony's major release of Radio DJ for Vodafone

Mar 1998 - Jan 2002

3 years 11 months

Munich, Germany

Kenan Billing Business Analyst

o2 Germany

Analyzed existing billing system in respect to new product launches
Liaised with internal departments on product design
Represented VIAG Europe-wide in the "GSM roaming TAP3" project
Provided technical support for the system databuild team
Completed Component and System testing phases through to UI level

Dec 1997 - Mar 1998

4 months

Barcelona, Spain

Test Consultant

Pricewaterhouse & Coopers

System test specialist for the billing system's redesign for service launch
Provided consultancy for the EHPT and BMP network systems
Provided system test documentation and quality control

Summary

Experienced Data Engineer and ETL Developer with expertise in various ETL tools and database technologies. Skilled in developing and implementing data warehousing solutions, optimizing data processes, and working with complex business logic. Proficient in Talend, Snowflake, Oracle, PostgreSQL, and Python. Strong background in DevOps practices and agile methodologies.