Ben (R.) Spouse-Data Engineer/ ETL Developer
Check rate
Experience
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
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.
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
Education
Ardingly College
GSCE’s and A Levels completed · United Kingdom
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Ben based?
What languages does Ben speak?
How many years of experience does Ben have?
What roles would Ben be best suited for?
What is Ben's latest experience?
What companies has Ben worked for in recent years?
Which industries is Ben most experienced in?
Which business areas is Ben most experienced in?
Which industries has Ben worked in recently?
Which business areas has Ben worked in recently?
What is Ben's education?
What is the availability of Ben?
What is the rate of Ben?
How to hire Ben?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
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
Most recent projects
FRATCH works with many companies and recruitment agencies. Here you will find our recently posted projects and opportunities.
