Ben (R.) Spouse
Data Engineer / ETL Developer
Experience
Sep 2023 - Present
1 year 10 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 10 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.
Languages
English
Native
German
Advanced
Education
Oct 1985 - Jun 1990
Ardingly College
Haywards Heath, United Kingdom
Certifications & licenses
Oracle 12c
Similar Freelancers
Discover other experts with similar qualifications and experience