Recommended expert
Ben (R.) Spouse
Data Engineer/ ETL Developer
Experience
Sep 2023 - Present
2 years 7 monthsLeipzig, Germany
Data Engineer/ ETL Developer
Deutsche Bahn
Position Summary
Data Engineer/ ETL Developer at Deutsche Bahn
Industries
Transportation
Business Areas
Business Intelligence
Information Technology
- 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 7 monthsBremerhaven, Germany
Data Engineer
Deutsche See
Position Summary
Data Engineer at Deutsche See
Industries
Food and Beverage
Business Areas
Business Intelligence
Information Technology
- 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
Position Summary
Data Engineer at Deutsche Bahn
Industries
Transportation
Business Areas
Business Intelligence
Information Technology
- 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
Position Summary
Talend Snowflake Developer at Douglas GmbH
Industries
Cosmetics
Retail
Business Areas
Business Intelligence
Information Technology
- 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
Position Summary
Talend ETL/Tableau Reporting Developer at Daimler TSS
Industries
Automotive
Business Areas
Business Intelligence
Information Technology
- 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
Position Summary
QA/ Data Modeling Consultant at Prospect 33
Industries
Information Technology
Professional Services
Business Areas
Business Intelligence
Information Technology
Quality Assurance
- 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
Position Summary
DevOps Talend ETL Developer at Helaba Invest
Industries
Banking and Finance
Business Areas
Business Intelligence
Information Technology
- 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
Position Summary
DevOps Consultant/Talend ETL Developer at Unitymedia
Industries
Telecommunication
Business Areas
Business Intelligence
Information Technology
- 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
Position Summary
ETL BI Operations DWH Consultant at Consors Finanz
Industries
Banking and Finance
Business Areas
Business Intelligence
Information Technology
Operations
- 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
Position Summary
Billing Application Operations DevOps at Telefonica O2
Industries
Telecommunication
Business Areas
Information Technology
Operations
- 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
Position Summary
Test Automation Agile at Vodafone
Industries
Telecommunication
Business Areas
Information Technology
Quality Assurance
- 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
Position Summary
Senior Test Analyst / Test Manager at Swisscom
Industries
Telecommunication
Business Areas
Information Technology
Quality Assurance
- 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
Position Summary
Senior Test / DWH Consultant at o2 Germany
Industries
Telecommunication
Business Areas
Information Technology
Quality Assurance
- 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
Position Summary
Senior Tester/Test Team Lead at Sony NetServices
Industries
Telecommunication
Business Areas
Information Technology
Quality Assurance
- 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
Position Summary
Kenan Billing Business Analyst at o2 Germany
Industries
Telecommunication
Business Areas
Information Technology
Product Development
Quality Assurance
- 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
Position Summary
Test Consultant at Pricewaterhouse & Coopers
Industries
Professional Services
Business Areas
Information Technology
Quality Assurance
- 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
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Telecommunication, Transportation, Food and Beverage, Cosmetics, Retail, and Banking and Finance.
Telecommunication
Transportation
Food and Beverage
Cosmetics
Retail
Banking and Finance
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Quality Assurance, Business Intelligence, Operations, and Product Development.
Information Technology
Quality Assurance
Business Intelligence
Operations
Product Development
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
Statistics
Experience
Total positions 16
Experience in Telecommunication 17.5 y
Avg length 1 y 8 m
Longest experience 3 y 11 m
Global Experience
Countries worked in 5 (Germany, Panama, Switzerland, Austria, Spain)
Primary country Germany
Expertise
Recent roles Data Engineer/ ETL Developer, Data Engineer, Talend Snowflake Developer
Main industries Telecommunication, Transportation, Food and Beverage
Main business areas Information Technology, Quality Assurance, Business Intelligence
Qualifications
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 2 years and 7 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 Food and Beverage. Ben also has some experience in Banking and Finance, Cosmetics, and Retail.
Which business areas is Ben most experienced in?
Ben is most experienced in business areas like Information Technology, Quality Assurance, 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, Food and Beverage, and Cosmetics.
Which business areas has Ben worked in recently?
Ben has recently worked in business areas like Business Intelligence and Information Technology.
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: 850-1010 €
Market avg: 850-1010 €
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