Recommended expert
Ben (R.) Spouse
Data Engineer/ ETL Developer
Experience
Sep 2023 - Present
2 years 5 monthsLeipzig, 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 monthsBremerhaven, 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 monthsFrankfurt, 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 monthsHagen, 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 monthsStuttgart, 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 monthsPanamá, 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 monthsFrankfurt, 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 monthsCologne, 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 monthsMunich, 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 yearsMunich, 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 monthsDü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 yearsBern, 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 monthsMunich, 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 monthsSalzburg, 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 monthsMunich, 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 monthsBarcelona, 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
NativeGerman
AdvancedEducation
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 €
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.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Data Engineer/ ETL Developer
Nearby freelancers
Professionals working in or nearby Munich, Germany