Recommended expert

Ben (R.) Spouse

Data Engineer/ ETL Developer

Ben Spouse
Munich, Germany

Experience

Sep 2023 - Present
2 years 5 months
Leipzig, Germany

Data Engineer/ ETL Developer

Deutsche Bahn

  • Developed data extraction from PostgreSQL with Talend ETL tool
  • Developed SQL/PL SQL scripts and views as required for ETL process
  • Used the GIT repository together with the existing CI/CD process for testing and production deployment
  • Created and updated multiple complex ETL jobs for mapping tarif data into SQLite files for the Input Pool
  • Extracted and transformed source data via an H2 DB into SQLite for MT and ticket machines
  • Collaborated closely with requirements engineers and data managers in an Agile environment
Sep 2023 - Present
2 years 5 months
Bremerhaven, Germany

Data Engineer

Deutsche See

  • Developed data extraction from flat ASCII files into raw data tables in Oracle 12c using ODI
  • Developed splitting and mapping of data in ODI ETL tool for staging layer in DWH
  • Developed complex DWH mappings for order data processing
  • Used Linux scripts to manipulate files and retrieve them from an SFTP server
  • Migrated from Linux-based data integration to fully autonomous Oracle DB
Apr 2023 - Jul 2023
4 months
Frankfurt, Germany

Data Engineer

Deutsche Bahn

  • Developed a new Smart HR solution by extracting data in blob form from an Azure Container using Python
  • Transformed the extracted data into data frames for further processing
  • Imported the transformed data into the Oracle staging layer
  • Utilized SAP BODS ETL tool for additional data transformation and integration
  • Performed DWH development in Oracle with Python and SAP BODS ETL tool
Aug 2021 - Mar 2023
1 year 8 months
Hagen, Germany

Talend Snowflake Developer

Douglas GmbH

  • Developed and implemented Talend jobs using Snowflake components for efficient ELT data processing
  • Transferred large volumes of data from the staging area to the Data Lake and core DWH layers of Snowflake
  • Performed data engineering tasks including deduplication and historization to ensure data integrity using Data Vault 2.0
  • Leveraged Talend connectors and applied complex business logic to extract data from upstream interfaces
  • Configured Azure Data Factory for Snowflake integration
  • Integrated SAP RFC interface with Talend BAPI connector for data extraction and mapping
Nov 2020 - Jul 2021
9 months
Stuttgart, Germany

Talend ETL/Tableau Reporting Developer

Daimler TSS

  • Developed ETL jobs for DWH with Talend ESB for migration from HP ALM to STARC
  • Created ETL tables and used Rest API components in Talend to extract JSON data from STARC
  • Developed jobs for transforming and parsing data into PostgreSQL DB
  • Developed Talend ETL jobs for data engineering and DWH migration tables
  • Developed Tableau reports and data visualizations on data in PostgreSQL and other Daimler data sources
  • Managed Azure Cloud repository for Talend projects
  • Participated in weekly change meetings with business stakeholders and managed tasks via Jira
Jun 2020 - Sep 2020
4 months
Panamá, Panama

QA/ Data Modeling Consultant

Prospect 33

  • Tested and developed data models using Python scikit-learn libraries for COVID-19 predictive modeling tool
  • Provided consultation and troubleshooting for day-to-day issues
  • Designed test cases and performed QA and frontend testing for a Python Dash web application
  • Logged and managed issues in GitLab and supported weekly release QA processes
  • Reviewed automation options with AWS Lambda and Katalon Studio and created pytest Python unit test tools
  • Participated in daily dev team meetings via Zoom and Slack
Mar 2020 - May 2020
3 months
Frankfurt, Germany

DevOps Talend ETL Developer

Helaba Invest

  • Developed ETL jobs for asset management data engineering in Talend
  • Developed SQL for complex lookups needed for Oracle DWH
  • Led a 7-week proof of concept for migration of a complex ETL system to Talend
  • Used Talend ESB with JMS-based architecture for data mapping
  • Presented Talend ETL tool capabilities to Helaba development teams
  • Implemented Java scripting and performance optimization of Talend components
May 2018 - Jan 2020
1 year 9 months
Cologne, Germany

DevOps Consultant/Talend ETL Developer

Unitymedia

  • Developed Talend and Java-based ETL jobs for PostgreSQL, Oracle and DB2 databases
  • Automated ETL processing with Airflow and managed file transfers via FTP from Linux and Windows shares
  • Developed REST services and SOAP calls for Vodafone’s Data Lake interface
  • Performed troubleshooting and bug fixing of production data transfer jobs
  • Managed and optimized existing applications and DWH jobs in Talend, Oracle, DB2 and PostgreSQL
Oct 2016 - Apr 2018
1 year 7 months
Munich, Germany

ETL BI Operations DWH Consultant

Consors Finanz

  • Performed BI operations and production incident fixes for Talend ETL system
  • Developed and configured SOS Job Scheduler for file transfer tool
  • Supported migration from legacy system to SAP ECC using Talend
  • Documented Big Data load processes into the DWH system
  • Provided 3rd level support and wrote workarounds for production issues
  • Split responsibilities between file transfer operations and job scheduler enhancements with Java-based parameter configuration
  • Managed monthly compliance data deliveries and problem management
Oct 2012 - Sep 2016
4 years
Munich, Germany

Billing Application Operations DevOps

Telefonica O2

  • Performed billing operations support for all partner brands on OSS/BSS system
  • Fixed production incidents, wrote scripts and monitored engines using Oracle 11g, PL/SQL, SQL, Citrix and UNIX scripts
  • Deployed web and content updates via Jenkins
  • Organized reports for stability meetings in an Agile environment
  • Led Kanban meetings, mentored team members and served as point of contact for interface teams
Feb 2012 - Oct 2012
9 months
Düsseldorf, Germany

Test Automation Agile

Vodafone

  • Executed non-functional tests on Vodafone’s Egarage project using FitNesse automation suite in Java/Eclipse
  • Performed test analysis and updates on FitNesse tests
  • Tested with Oracle tools, SQL Developer, SQL and UNIX scripts
  • Updated and executed batch shell scripts on Linux backend servers
  • Conducted system and integration tests with Vodafone shop web systems
Jan 2008 - Dec 2011
4 years
Bern, Switzerland

Senior Test Analyst / Test Manager

Swisscom

  • Managed full test lifecycle (component to E2E) using HP Quality Center for Docforms bill layout system
  • Analyzed change requests and created use cases, test cases and test plans
  • Executed functional, system and integration tests with upstream and downstream systems
  • Tested using Oracle tools, Toad, PL/SQL, UNIX scripts and Perl
  • Ran regression automation Perl scripts and managed Java/Linux/Oracle DB environments
  • Mentored junior team members
May 2006 - Oct 2007
1 year 6 months
Munich, Germany

Senior Test / DWH Consultant

o2 Germany

  • Performed data warehouse testing for middleware Oracle database using PL/SQL and UNIX scripts
  • Consulted with development for application enhancements and design
  • Executed full test lifecycle using Rational test tools
  • Created test schemas and scripts for simulating live environments
  • Conducted integrated tests with connecting middleware applications
Mar 2004 - May 2006
2 years 3 months
Salzburg, Austria

Senior Tester/Test Team Lead

Sony NetServices

  • Specialized in system testing for Vodafone Radio DJ project
  • Performed component testing on multiple mobile devices and backend systems
  • Completed field tests and tested backend Linux/Oracle database systems
  • Planned, wrote and executed all tests using HP Quality Center
  • Provided test data via Oracle using Toad
Mar 1998 - Jan 2002
3 years 11 months
Munich, Germany

Kenan Billing Business Analyst

o2 Germany

  • Analyzed existing billing system for new product launches
  • Liaised with internal departments on product design
  • Represented VIAG in the GSM roaming TAP3 project across Europe
  • Provided technical support to 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

  • Performed system testing for billing system redesign for service launch
  • Provided consultancy for EHPT and BMP network systems
  • Created system test documentation and quality control processes

Skills

  • Talend/talend Esb Etl Tool
  • Extract, Transform, Load (Etl) Development
  • Azure Cloud
  • Snowflake
  • Data Engineering
  • Oracle 12c
  • Oracle Data Integrator Etl Tool
  • Sql/pl-sql
  • Postgresql
  • Python
  • Postman
  • Tableau
  • Java
  • Dwh Data Warehouse
  • Devops Process
  • Git
  • Toad 9.01 For Oracle
  • Remedy
  • Kenan Billing System
  • Rator Billing System
  • Job Scheduler Sos Tool
  • Airflow
  • Azure Data Factory
  • Db2
  • Gitlab
  • Telecoms Oss/bss
  • Jenkins
  • Fitnesse
  • Hp Quick Test Pro
  • Hp-ux, Sco, Aix Unix
  • Grep Linux Shell Vi Editor
  • Sap Bods Etl Tool
  • Soapui

Languages

English
Native
German
Advanced

Education

Sep 1985 - Jun 1990

Ardingly College

GSCE’s and A Levels completed · United Kingdom

Profile

Created
Last Update
Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Ben based?

Ben is based in Munich, Germany and prefers 100% remote projects.

What languages does Ben speak?

Ben speaks the following languages: English (Native), German (Advanced).

How many years of experience does Ben have?

Ben has at least 25 years of experience. During this time, Ben has worked in at least 15 different roles and for 14 different companies. The average length of individual experience is 1 year and 6 months. Note that Ben may not have shared all experience and actually has more experience.

What roles would Ben be best suited for?

Based on recent experience, Ben would be well-suited for roles such as: Data Engineer/ ETL Developer, Data Engineer, Talend Snowflake Developer.

What is Ben's latest experience?

Ben's most recent position is Data Engineer/ ETL Developer at Deutsche Bahn.

What companies has Ben worked for in recent years?

In recent years, Ben has worked for Deutsche Bahn, Deutsche See, Douglas GmbH, and Daimler TSS.

Which industries is Ben most experienced in?

Ben is most experienced in industries like Telecommunication, Transportation and Logistics, and Food and Beverage. Ben also has some experience in Banking and Finance, Beauty and Cosmetics, and Retail.

Which business areas is Ben most experienced in?

Ben is most experienced in business areas like Information Technology (IT), Quality Assurance (QA), and Business Intelligence. Ben also has some experience in Operations and Product Development.

Which industries has Ben worked in recently?

Ben has recently worked in industries like Transportation and Logistics, Food and Beverage, and Beauty and Cosmetics.

Which business areas has Ben worked in recently?

Ben has recently worked in business areas like Business Intelligence and Information Technology (IT).

What is Ben's education?

Ben attended Ardingly College.

What is the availability of Ben?

Ben is immediately available full-time for suitable projects.

What is the rate of Ben?

Ben's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Ben?

To hire Ben, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1200
900
600
300
Market avg: 930-1090 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.