Go to Website
  • en
  • de

Josef S.

Devop

Munich, Germany

Experience

Jan 2020 - Jul 2024
4 years 7 months

Devop

Softwarehaus

  • Implementation, maintenance and operation of an ERP system and a document exchange platform for a corrugated board manufacturer.
  • Used systems and technologies: Unix (Debian 6.x), C, SVN, Windows, C#, MS SQL Server, SCRUM.
Jan 2019 - Sep 2020
1 year 9 months

Consultant

Softwarehaus

  • Implementation and maintenance of ETL processes for an enterprise-wide data warehouse at an automaker's bank.
  • Used systems and technologies: Informatica Powercenter 10, Oracle 12c, SQL, PL/SQL, C, Perl, SVN, UNIX, Windows.
Jan 2018 - Sep 2019
1 year 9 months

Consultant

Softwarehaus

  • Implementation and maintenance of ETL processes for a data warehouse within a human resources project for an automaker.
  • Used systems and technologies: Informatica Powercenter 10, Oracle 12c, SQL, PL/SQL, UNIX, Windows, JIRA, SCRUM.
Jan 2017 - Mar 2018
1 year 3 months

Consultant

Softwarehaus

  • Implementation and maintenance of ETL processes for a vehicle leasing data warehouse at an automaker's bank.
  • Used systems and technologies: Informatica Powercenter 10, Perl, Oracle 12c, SQL, PL/SQL, UNIX, Windows.
Jan 2017 - Apr 2017
4 months

Consultant

Softwarehaus

  • Testing in a Hadoop cluster and deploying application packages in a Hadoop environment for an automaker.
  • Used systems and technologies: Hortonworks Hadoop cluster, Linux Bash shell, HDFS, Oozie, Hive, Pig, GIT, Postgres.
Jan 2016 - Jun 2016
6 months

Consultant

Softwarehaus

  • Tests within a Hadoop cluster and deployment of application packages within a Hadoop cluster as part of a Hadoop project for an automotive manufacturer.
  • Systems and technologies used: Hortonworks Hadoop cluster, Linux Bash shell, HDFS, Oozie, Hive, Pig, GIT, Postgres.
Jan 2016 - Mar 2016
3 months

Consultant

Softwarehaus

  • Implementation and maintenance of ETL processes in the environment of a data warehouse as part of a human resources project for an automotive manufacturer.
  • Systems and technologies used: Informatica Powercenter 9.51, Oracle 11g, SQL, PL/SQL, SVN, UNIX, Windows.
Jan 2015 - Mar 2016
1 year 3 months

Consultant

Softwarehaus

  • Implementation of ETL processes for an interface in the environment of a financial data warehouse for a financial institution.
  • Systems and technologies used: Informatica Powercenter 9.51, Oracle 11g, SQL, PL/SQL, UNIX, Windows.
Jan 2014 - Oct 2015
1 year 10 months

Consultant

Softwarehaus

  • Implementation of ETL processes in the environment of a data warehouse as part of a human resources project for an automotive manufacturer.
  • Systems and technologies used: Informatica Powercenter 9.51, Oracle 11g, SQL, PL/SQL, UNIX, Windows.
Jan 2012 - Feb 2014
2 years 2 months

Consultant

Telecommunications company

  • Implementation of ETL processes in the environment of a data warehouse for a telecommunications company.
  • Systems and technologies used: Informatica Powercenter 9.5, Oracle 11g, SQL, PL/SQL, UNIX, Windows, SVN, Excel.
Jan 2012 - Mar 2012
3 months

Consultant

Software House

  • Implementation of ETL processes in the area of marketing processes in the automotive sector.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Informatica Powercenter 9.1, Perl, SVN.
Jan 2012 - Mar 2012
3 months

Consultant

Software House

  • Implementation of ETL processes in the area of marketing processes in the automotive sector.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Informatica Powercenter 8.6, Perl, SVN.
Jan 2012 - Jan 2012
1 month

Consultant

Software House

  • Migration of ETL processes from Informatica Powercenter 8.6 to Informatica Powercenter 9.1.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, Informatica Powercenter 9.1.
Jan 2011 - Jun 2011
6 months

Consultant

Software House

  • Design and implementation of ETL processes in the context of quality management processes within the automotive sector.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Informatica Powercenter 8.6, Perl, SVN.
Jan 2011 - Apr 2011
4 months

Consultant

Software House

  • Implementation and configuration of a browser-based application for inventory of telecommunication components. The application modules are built using an SQL-centered framework. Interfaces from Excel to Oracle are provided with Perl and PL/SQL. Tests with SQL and Perl.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Perl, Excel, TWiki, SVN.
Jan 2011 - Feb 2011
2 months

Consultant

Softwarehaus

  • Implementation of ETL processes in the context of marketing processes within the automotive sector.
  • Used systems and technologies: UNIX, Windows, Oracle, SQL, PL/SQL, Informatica PowerCenter 8.6, Perl, SVN.
Jan 2010 - Aug 2010
8 months

Consultant

Softwarehaus

  • Implementation and configuration of browser-based applications to support rollout projects in the telecommunications sector. Using an SQL-centered framework, the application modules were built. Based on SQL, interfaces and reports were provided in Excel and XML. Testing with SQL and Perl.
  • Used systems and technologies: UNIX, Windows, Oracle, SQL, PL/SQL, Perl, JavaScript, HTML, TWiki, SVN, XML, XSLT.
Jan 2010 - Mar 2010
3 months

Consultant

Softwarehaus

  • Implementation and configuration of a browser-based application for inventorying telecommunications components. Using an SQL-centered framework, the application modules were built. The interfaces from Excel to Oracle were provided with Perl and PL/SQL. Testing was done with SQL and Perl.
  • Used systems and technologies: UNIX, Windows, Oracle, SQL, PL/SQL, Perl, Excel, TWiki, SVN.
Jan 2010 - Jan 2010
1 month

Consultant

Softwarehaus

  • Maintenance of a tool for controlling telephone systems. Bug fixes, data cleanup, and tool enhancements using SQL and PL/SQL.
  • Used systems and technologies: UNIX, Oracle, SQL, PL/SQL, SQL*Plus, TWiki, SVN.
Jan 2009 - Jun 2009
6 months

Consultant

Softwarehaus

  • Implementation and configuration of a browser-based order management tool in the telecommunications sector. Using an SQL-centered framework, the tool modules were built. Based on SQL, interfaces and reports were provided in Excel. Testing with SQL and Perl.
  • Used systems and technologies: UNIX, Windows, Oracle, SQL, PL/SQL, Perl, JavaScript, HTML, Excel.
Jan 2009 - Jun 2009
6 months

Consultant

Software company

  • Implementation and configuration of a browser-based tool to support rollout projects in the telecommunications sector. Using an SQL-centric framework, the tool's modules were built. Interfaces and reports in Excel were provided based on SQL. Testing with SQL and Perl.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Perl, JavaScript, HTML, Excel.
Jan 2008 - Apr 2008
4 months

Consultant

Data center

  • Implementation of data reconciliation between banks' complete data sets and an operator database. The data reconciliation was implemented as a UNIX application in C/C++ with ESQL access to DB2.
  • Systems and technologies used: C/C++, UNIX, DB2 V9.
Jan 2008 - Feb 2008
2 months

Consultant

Software company

  • Implementation and configuration of a browser-based tool to support rollout projects in the telecommunications sector. Using an SQL-centric framework, the tool's modules were built. Interfaces and Excel reports were provided based on SQL statements. Testing with SQL and Perl.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Perl.
Jan 2007 - Sep 2007
9 months

Consultant

Data center

  • Implementation of data provisioning from bank message files into an operator database under legal requirements. For runtime optimization, data provisioning was implemented in C/C++ as UNIX applications with ESQL access to DB2. Testing with SQL.
  • Systems and technologies used: C++, ESQL, DB2 V9, UNIX.
Jan 2007 - Feb 2007
2 months

Consultant

Bank

  • Implementation of a migration for credit card data provisioning. The migration was implemented using Informatica workflows. Testing with SQL on Oracle.
  • Systems and technologies used: Informatica PowerCenter, Oracle 10g, SQL Navigator, UNIX.
Jan 2007 - Jan 2007
1 month

Consultant

Bank

  • Testing data feeds from subsidiaries into a centralized, company-wide database. Testing the Informatica workflows with SQL statements on Oracle.
  • Systems and technologies used: Informatica Powercenter, Oracle 9i, SQL Navigator, UNIX.
Jan 2006 - Mar 2006
3 months

Consultant

Bank

  • Implementing data feeds from subsidiaries into a centralized, company-wide database. The data feeds are built as Informatica workflows that rely heavily on SQL. Testing with SQL.
  • Systems and technologies used: Informatica Powercenter, Oracle 9i, SQL Navigator, UNIX.
Jan 2006 - Feb 2006
2 months

Consultant

Industrial company

  • Implementing Windows services for receiving and sending data.
  • Systems and technologies used: C#, Windows 2003 Server.
Jan 2006 - Feb 2006
2 months

Consultant

Industrial company

  • Connecting various communication partners and types; monitoring the connections.
  • Systems and technologies used: Gedas RvsXp, IIS, MS SQL Server, MS BizTalk Server, Windows 2003 Server.
Jan 2006 - Jan 2006
1 month

Consultant

Industrial company

  • Designing and implementing document reception via web servers.
  • Systems and technologies used: C#, IIS, Windows 2003 Server.
Jan 2006 - Jan 2006
1 month

Consultant

Industrial company

  • Design and implementation of data exchange for freight invoices in the Edifact format.
  • Systems and technologies used: EDIdEv, C#, MS SQL Server, Windows 2003 Server.
Jan 2006 - Jan 2006
1 month

Consultant

Industrial company

  • Design and implementation of data exchange in the VDA format (release scheduling).
  • Systems and technologies used: C#, MS BizTalk Server 2004, MS SQL Server, Windows 2003 Server.
Jan 2006 - Jan 2006
1 month

Consultant

Data center

  • Implementation of data provisioning from bank message files into an operator database under legal requirements. For runtime optimization, the data provisioning is implemented in C/C++ with ESQL access to DB2 as UNIX applications. Tests with SQL.
  • Systems and technologies used: C++, ESQL, DB2 V9, UNIX.
Jan 2005 - Jan 2006
1 year 1 month

Consultant

Industrial company

  • Design of the interface for credit note exchange in the VDA format.
  • Systems and technologies used: C#, MS BizTalk Server 2004, MS SQL Server.
Jan 2005 - May 2005
5 months

Consultant

Industrial company

  • Design and implementation of data exchange between different partners (supplier – customer) in VDA format (delivery notes, delivery calls).
  • Systems and technologies used: C#, MS BizTalk Server 2004, MS SQL Server, Windows 2003 Server.
Jan 2005 - Mar 2005
3 months

Consultant

Bank

  • Implementation of data provisioning (master data) to the CRM system from ODS.
  • Systems and technologies used: SQL, PL/SQL, ORACLE, Informatica, Windows XP, UNIX, Shell, FTP, SFTP, SSH.
Jan 2005 - Mar 2005
3 months

Consultant

Bank

  • Extension of data provisioning implementation for external payments from ODS.
  • Systems and technologies used: SQL, PL/SQL, ORACLE, Informatica, Windows XP, UNIX, Shell, FTP, SFTP, SSH.
Jan 2004 - May 2004
5 months

Consultant

Bank

  • Implementation of data provisioning to the credit card system from ODS.
  • Systems and technologies used: SQL, PL/SQL, ORACLE, Informatica, Windows XP, UNIX, Shell, ConnectDirect, SSH.
Jan 2004 - Mar 2004
3 months

Consultant

Bank

  • Implementation of data provisioning to the CRM system from ODS.
  • Systems and technologies used: SQL, PL/SQL, ORACLE, Informatica, Windows XP.
Jan 2004 - Mar 2004
3 months

Consultant

Bank

  • Implementation of data provisioning for external payments from ODS.
  • Systems and technologies used: SQL, PL/SQL, ORACLE, Informatica, Windows XP.
Jan 2004 - Jan 2004
1 month

Consultant

Bank

  • Maintenance of legacy systems.
  • Systems and technologies used: Visual Basic, SQL, Windows NT.
Jan 2003 - Jun 2003
6 months

Consultant

Bank

  • Implementation of data supply to the ODS from the leasing system.
  • Systems and technologies used: SQL, PL/SQL, ORACLE, Informatica, Windows NT, UNIX, Shell, FTP, ErWin.
Jan 2003 - Mar 2003
3 months

Consultant

Bank

  • Implementation of account data exchange between the ODS and the staging area DWH.
  • Systems and technologies used: SQL, PL/SQL, ORACLE, Informatica, Windows NT, UNIX.
Jan 2003 - Mar 2003
3 months

Consultant

Bank

  • Testing and implementation of master data and account data between the legacy system and the ODS.
  • Systems and technologies used: SQL, PL/SQL, ORACLE, Informatica, Windows NT, UNIX, ErWin.
Jan 2002 - Aug 2002
8 months

Consultant

Software house

  • Maintenance and further development of a CRM system, including technical project management.
  • Systems and technologies used: SQL, UDB V6, C++ (MSVC), Windows NT, OS/2.
Jan 2002 - Feb 2002
2 months

Consultant

Bank

  • Testing and implementing master data exchange between legacy system and ODS (Object Data Store).
  • Used systems and technologies: SQL, PL/SQL, ORACLE, Informatica, Windows NT, UNIX.
Jan 2002 - Feb 2002
2 months

Consultant

Software House

  • Maintenance and further development of a CRM system.
  • Used systems and technologies: SQL, UDB V5.2, C++ (MSVC), Windows NT, OS/2.
Jan 2001 - May 2001
5 months

Consultant

Software House

  • Designing and implementing helper classes (DB access, GUI) within the servlet environment.
  • Used systems and technologies: JDK 1.2, JRun, JDBC, SQL, Swing, Windows NT.
Jan 2001 - Apr 2001
4 months

Consultant

Software House

  • Designing and implementing a customer contact service considering the existing data models.
  • Used systems and technologies: UML, Java, SQL, ErWin.
Jan 2001 - Mar 2001
3 months

Consultant

Software House

  • Optimizing a selection tool.
  • Used systems and technologies: SQL, UDB V5.2, C++ (MSVC), Windows NT, OS/2.
Jan 2000 - Mar 2000
3 months

Consulting

Software House

  • Specification and implementation of an interface DLL between a loan processing application and a customer advisory system.
  • Systems and technologies used: OOA, C, ODBC, UDB-CLI, Windows NT, OS/2.
Jan 2000 - Mar 2000
3 months

Consulting

Software House

  • Integrating a data warehouse tool with a customer advisory system.
  • Systems and technologies used: SQL, COGNOS, Windows NT.
Jan 2000 - Mar 2000
3 months

Consulting

Software House

  • Extending a customer advisory system (specification, implementation).
  • Systems and technologies used: C++, SQL, UDB, Windows NT, OS/2.
Jan 2000 - Feb 2000
2 months

Consulting

Software House

  • Optimizing a system for managing marketing campaigns.
  • Systems and technologies used: SQL, UDB V5.2, C++ (MSVC), Windows NT, OS/2, RTS-GUI.
Jan 2000 - Jan 2000
1 month

Consulting

Software House

  • Specification of a 'delete advisor' functionality.
  • Systems and technologies used: OOA, OOD.
Jan 1999 - May 1999
5 months

Consultant

Softwarehaus

  • Expand a customer advisory system.
  • Systems and technologies used: C++, SQL, RTS-GUI, ORACLE, Windows NT, Windows 3.11, OS/2.
Jan 1999 - Mar 1999
3 months

Consultant

Softwarehaus

  • Developed a system for managing marketing campaigns (data modeling, specification, implementation, coaching).
  • Systems and technologies used: C++, SQL, UDB, Windows NT, OS/2.
Jan 1999 - Mar 1999
3 months

Consultant

Softwarehaus

  • Customized and extended a tool for generating selections.
  • Systems and technologies used: SQL, C++, UDB, Windows NT, OS/2.
Jan 1999 - Jan 1999
1 month

Consultant

Softwarehaus

  • Developed the report for a credit advisory service.
  • Systems and technologies used: C++, RTS-GUI, Windows NT.
Jan 1998 - Mar 1998
3 months

Consultant

Softwarehaus

  • Developed a system to record contacts within a customer advisory system (data modeling, specification, implementation).
  • Systems and technologies used: C++, SQL, RTS-GUI, ORACLE, Windows NT, Windows 3.11, OS/2.
Jan 1998 - Feb 1998
2 months

Consultant

Software company

  • Developed a system to plan and execute marketing campaigns.
  • Used systems and technologies: C++, SQL, RTS-GUI, ORACLE, Windows NT, WIN 3.11, OS/2.
Jan 1998 - Feb 1998
2 months

Consultant

Software company

  • Optimized a client-server application in a 64-bit environment (concept, specification, implementation, testing).
  • Used systems and technologies: C++, SQL, RTS-GUI, ORACLE, Windows NT, WIN 3.11, OS/2.
Jan 1998 - Feb 1998
2 months

Consultant

Software company

  • Implemented the euro conversion of a customer advisory system.
  • Used systems and technologies: C++, SQL, RTS-GUI, ORACLE, Windows NT, WIN 3.11, OS/2.
Jan 1997 - Dec 1998
2 years

Consultant

Software company

  • Created authorization profiles for users of a customer advisory system.
  • Used systems and technologies: C++, SQL, RTS-GUI, ORACLE, Windows NT, WIN 3.11, OS/2.
Jan 1997 - Nov 1997
11 months

Database developer

Hardware and software manufacturer

  • Designed the multithreading capability of a relational database system.
  • Used systems and technologies: C, Assembly, Windows NT, BS2000.
Jan 1996 - Dec 1996
1 year

Database development

Hardware and software manufacturer

  • Design and implementation of replication within a relational database system.
  • Systems and technologies used: C, Unix, Windows NT, BS2000.
Jan 1995 - Dec 1995
1 year

Database development

Hardware and software manufacturer

  • Design and implementation of ALTER TABLE functions within a relational database system.
  • Systems and technologies used: C, Unix, Windows NT, BS2000.
Jan 1994 - Dec 1994
1 year

Database development

Hardware and software manufacturer

  • Maintenance of CREATE INDEX functions within a relational database system.
  • Systems and technologies used: C, Unix, Windows NT, BS2000.
Jan 1993 - Dec 1993
1 year

Database development

Hardware and software manufacturer

  • Design and implementation of transaction functionality for DDL statements within a relational database system.
  • Systems and technologies used: C, Unix, Windows NT, BS2000.
Jan 1992 - Dec 1992
1 year

Database development

Hardware and software manufacturer

  • Design and implementation of database buffering for DDL statements within a relational database system.
  • Systems and technologies used: C, Unix, BS2000.
Jan 1991 - Jun 1991
6 months

Database development

Hardware and software manufacturer

  • Maintenance of the authorization functions within a relational database system.
  • Systems and technologies used: Assembler, UNIX, BS2000.
Jan 1990 - Dec 1991
2 years

Database development

Hardware and software manufacturer

  • Design and implementation of a task framework for service tasks within a relational database system.
  • Systems and technologies used: C, Unix, BS2000.

Summary

  • Main focus: development/consulting in DWH/BI and database

  • Retrieval languages: SQL, PL/SQL

  • Tools: Informatica Powercenter

  • Operating systems: Windows, UNIX/Linux

  • Databases: Oracle, MS SQL Server, Postgres

  • Project management: project planning, effort estimation, product maintenance and support, SCRUM

  • Programming languages: C, Perl, Unix shell

  • Design: database design, data modeling

  • Design: UML, GoF, system analysis, OO design

  • Programming languages: C++, Java, JavaScript, C#, Oozie, Pig, Python

  • Tools: HDFS, GIT, JIRA, SVN, Visual .NET, Office packages, Confluence

  • GUI: HTML

  • Operating systems: BS2000, MVS

  • Databases: DB2/UDB, Hive, Informix, SESAM, SQL Anywhere

Languages

German
Native
English
Advanced

Education

Oct 1986 - Jun 1990
Lorem ipsum dolor sit amet

Diploma in Computer Science (FH) · Computer Science · Germany

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

Similar Freelancers

Discover other experts with similar qualifications and experience

Ildar A.

Senior Data Engineer

View Profile
Florian B.

Jitsi - Video conferencing system with AI-powered simultaneous translation (Prototype)

View Profile
Peter A.

IT Consultant

View Profile
Stefan B.

Senior Full Stack Developer / Co-Founder / CTO / Head of Development

View Profile
Ben S.

Data Engineer

View Profile
Andre F.

Data transformation and homogenization between multiple backend systems

View Profile
Fabian K.

Technical Architect

View Profile
Stephan S.

Senior Data/ML Consultant & Technical Lead

View Profile
Jens H.

Test Manager in Safety-Critical Infrastructure

View Profile
Benedikt B.

Implementation of a Time Tracking Software

View Profile
Karl E.

Hiring Requirement

View Profile
Guido S.

Migration of Angular Applications from KeyCloak to Entra ID

View Profile
Matthias M.

Architecture Review, Documentation and Change Management Process

View Profile
Cornelius H.

Solution architect

View Profile
Martin M.

Freelance Data Architect

View Profile
fratch Part of Bitkom logo
linkedIncrunchbaseyoutube
  • English
  • Deutsch

2025 © FRATCH.IO GmbH. All rights reserved.