09/17/2026 updated
100 % available
Senior Data Warehouse & Data Integration Architect
Warschau, Poland
Germany +2
Technische Universität Rzeszów, Universität Warschauinfo: Germany, Austria, Switzerland
About me
Business Intelligence Entwickler & Data Engineer mit Fokus auf Data Warehousing, ETL und Cloud-Migrationen. Expertise in Informatica, Talend, Oracle, SQL Server, Python, Databricks, ADF, PySpark, Snowflake, DBT und Synapse. Erfahrung mit Azure, AWS sowie CI/CD-gestützten Modernisierungsprojekten.
dbtAzure SynapseDB2 SQLLinuxPython (Programming Language)Shell ScriptSQL DatabasesSQL Server Analysis ServicesTalendNetezzaOracle 10g/11gSnowflakePytestPySparkDatabricks
Data Warehousing
Over 14 years of experience in Data Warehousing covering development, data modeling, metadata management, designing, analyzing, and leadership of small development teams across multiple industries.
Informatica PowerCenter & Data Integration
More than 10 years of hands-on experience with Informatica PowerCenter, Power Exchange, IDQ Scorecards, Informatica Data Services, Informatica Java API SDK, Informatica Visio Architect, and Informatica command line programs for migration automation, including installation, configuration, repository migrations, and administration.
Oracle & PL/SQL Development
Over 14 years of experience in Oracle development including PL/SQL programming, SQL query optimization, Oracle Sales Analyzer setup, OLAP DML programming, Oracle BI Beans, Oracle Warehouse Builder, OBIEE, Oracle Discoverer, and Oracle database administration.
Azure Cloud Development
More than 3 years of experience in Azure cloud development including Azure Data Factory (ADF), Synapse, and App Logic.
Unix Shell & Python
Over 2 years of experience working with Unix Shell scripting and Python for automation and data processing tasks.
Qlik View & QlikSense
Experience with Qlik View and QlikSense including installation, configuration, and object extension using JavaScript and DS3.
ELT/ETL Processes & Modern Data Platforms
Practical experience with ELT processes including conversion from PWC into DBT, replication engines from DB2 into Snowflake, and use of tools such as Git, Airflow, SQL, Python, and UC4.
Data Quality & Testing
Extensive experience in data quality testing, DQ rules implementation, unit tests, performance tests, and bug fixing in ETL code across multiple projects.
Team Leadership & Architecture
Proven experience as Team Leader and Data Integration Architect, including team building, trainings, mapping template design, low-level design preparation, and leadership of distributed development teams.
Over 14 years of experience in Data Warehousing covering development, data modeling, metadata management, designing, analyzing, and leadership of small development teams across multiple industries.
Informatica PowerCenter & Data Integration
More than 10 years of hands-on experience with Informatica PowerCenter, Power Exchange, IDQ Scorecards, Informatica Data Services, Informatica Java API SDK, Informatica Visio Architect, and Informatica command line programs for migration automation, including installation, configuration, repository migrations, and administration.
Oracle & PL/SQL Development
Over 14 years of experience in Oracle development including PL/SQL programming, SQL query optimization, Oracle Sales Analyzer setup, OLAP DML programming, Oracle BI Beans, Oracle Warehouse Builder, OBIEE, Oracle Discoverer, and Oracle database administration.
Azure Cloud Development
More than 3 years of experience in Azure cloud development including Azure Data Factory (ADF), Synapse, and App Logic.
Unix Shell & Python
Over 2 years of experience working with Unix Shell scripting and Python for automation and data processing tasks.
Qlik View & QlikSense
Experience with Qlik View and QlikSense including installation, configuration, and object extension using JavaScript and DS3.
ELT/ETL Processes & Modern Data Platforms
Practical experience with ELT processes including conversion from PWC into DBT, replication engines from DB2 into Snowflake, and use of tools such as Git, Airflow, SQL, Python, and UC4.
Data Quality & Testing
Extensive experience in data quality testing, DQ rules implementation, unit tests, performance tests, and bug fixing in ETL code across multiple projects.
Team Leadership & Architecture
Proven experience as Team Leader and Data Integration Architect, including team building, trainings, mapping template design, low-level design preparation, and leadership of distributed development teams.
Experience
Professional experience10+ years
Freelancer since2011
Languages
GermanBasic knowledgeEnglishFluent
Project history
Replication engine from DB2 into Snowflake, ELT processes conversion from PWC into DBT, use of Git, Airflow, SQL, Python, UC4, and production maintenance for both PWC and DBT.
Preparing mapping templates for various DWH layers, team building and trainings for new members, mapping generation automation for inbound layer, PL/SQL development, Oracle 12c SQL optimization, Unix scripting (AIX), Informatica 10.2HF2 installation and configuration on Linux RedHat, Informatica repository migrations, administration and troubleshooting, and Informatica deployment automation.
Audit and project plan preparation for migration of LMS application to new Credit Suisse architecture, low level design preparation for developers (Oracle part), leadership of distributed development team (Wroclaw/Zurich), performance tests with Informatica PowerCenter/Oracle/MSSQL, Informatica upgrade from 8.6 to 9.1 including code review, migration and burning tests, and data virtualization POC using Informatica Developer.