Ben (R.) Spouse
Data Engineer / ETL Developer
Erfahrungen
Sept. 2023 - Bis heute
1 Jahr 6 Monaten 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.
Sept. 2023 - Bis heute
1 Jahr 6 Monaten 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 - Juli 2023
4 Monaten 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 - März 2023
1 Jahr 8 Monaten 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 - Juli 2021
9 Monaten 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
Juni 2020 - Sept. 2020
4 Monaten 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
März 2020 - Mai 2020
3 Monaten 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
Mai 2018 - Jan. 2020
1 Jahr 9 Monaten 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
Okt. 2016 - Apr. 2018
1 Jahr 7 Monaten 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
Okt. 2012 - Sept. 2016
4 Jahren 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 - Okt. 2012
9 Monaten 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 - Dez. 2011
4 Jahren 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
Mai 2006 - Okt. 2007
1 Jahr 6 Monaten 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
März 2004 - Mai 2006
2 Jahren 3 Monaten 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
März 1998 - Jan. 2002
3 Jahren 11 Monaten 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
Dez. 1997 - März 1998
4 Monaten 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
Zusammenfassung
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.
Sprachen
Englisch
Muttersprache
Deutsch
Verhandlungssicher
Ausbildung
Okt. 1985 - Juni 1990