07/01/2026 updated
100 % available
Senior DWH & ETL Developer | Snowflake | Wherescape | IBM DataStage
Postřižín, USA
Only remote
Studies in Computer Science, Czech Technical University PragueSql Data WarehouseData WarehousingIBM WebSphere DataPower SOA AppliancesIBM InfoSphere DataStageData Pipeline
Snowflake Architecture & Performance Tuning
Expertise in Snowflake-based analytics platform design, including cost and performance tuning, optimization of complex SQL pipelines for high-volume data flows, and design and maintenance of analytical Data Marts and reporting structures.
Wherescape RED/BLUE Automation & Template Development
Deep knowledge of Wherescape RED and BLUE for metadata-driven automation, including development of advanced automation templates in PowerShell, Pebble, and JavaScript, extending Wherescape RED functionality for Snowflake-specific processing.
IBM DataStage ETL Development
Extensive experience developing and maintaining IBM DataStage parallel jobs and sequences for ETL processes, including data cleansing, loading, and transformation across multiple enterprise environments in finance, insurance, and banking.
Airflow Scheduling & Python DAG Generation
Participation in scheduler transitions from Wherescape Scheduler to Apache Airflow, including Python-based DAG generation for automated scheduling and dependency management.
Data Modeling & Metadata-Driven ETL Patterns
Strong background in data modeling from staging to core layers, dimensional modelling, and metadata-driven ETL patterns for enterprise data warehouse environments.
Teradata SQL/BTEQ Development
Proven experience with Teradata SQL and BTEQ scripting, including implementation of staging and core load processes, data warehouse extensions, and quality checks across multiple projects.
Version Control & CI/CD for DWH
Application of version control systems such as SVN and CVS in data warehouse contexts, including release hygiene and CI/CD practices around DWH development.
AI-Assisted Workflows & Prompt Engineering
Utilization of AI-assisted workflows including prompt engineering for code and SQL refactoring, documentation generation, and log triage to improve development efficiency.
Cross-Team Support & Incident Management
Provision of continuous support and feature development for teams of 200+ data engineers, including incident triage, root-cause analysis, and resolution of production issues.
Expertise in Snowflake-based analytics platform design, including cost and performance tuning, optimization of complex SQL pipelines for high-volume data flows, and design and maintenance of analytical Data Marts and reporting structures.
Wherescape RED/BLUE Automation & Template Development
Deep knowledge of Wherescape RED and BLUE for metadata-driven automation, including development of advanced automation templates in PowerShell, Pebble, and JavaScript, extending Wherescape RED functionality for Snowflake-specific processing.
IBM DataStage ETL Development
Extensive experience developing and maintaining IBM DataStage parallel jobs and sequences for ETL processes, including data cleansing, loading, and transformation across multiple enterprise environments in finance, insurance, and banking.
Airflow Scheduling & Python DAG Generation
Participation in scheduler transitions from Wherescape Scheduler to Apache Airflow, including Python-based DAG generation for automated scheduling and dependency management.
Data Modeling & Metadata-Driven ETL Patterns
Strong background in data modeling from staging to core layers, dimensional modelling, and metadata-driven ETL patterns for enterprise data warehouse environments.
Teradata SQL/BTEQ Development
Proven experience with Teradata SQL and BTEQ scripting, including implementation of staging and core load processes, data warehouse extensions, and quality checks across multiple projects.
Version Control & CI/CD for DWH
Application of version control systems such as SVN and CVS in data warehouse contexts, including release hygiene and CI/CD practices around DWH development.
AI-Assisted Workflows & Prompt Engineering
Utilization of AI-assisted workflows including prompt engineering for code and SQL refactoring, documentation generation, and log triage to improve development efficiency.
Cross-Team Support & Incident Management
Provision of continuous support and feature development for teams of 200+ data engineers, including incident triage, root-cause analysis, and resolution of production issues.
Languages
GermanGoodEnglishGood
Project history
Responsible for modernization and automation of the global Snowflake-based analytics platform. Tasks included redesign of metadata models in Wherescape BLUE, optimization of complex SQL pipelines, development of advanced automation templates in PowerShell, Pebble, and JavaScript, transition from Wherescape Scheduler to Apache Airflow, design and maintenance of analytical Data Marts, support for 200+ data engineers, and upgrade from Wherescape 8 to version 10.
Updated existing DataStage jobs to clean and load data into Oracle stage tables as part of a project to change the source structure for the CILE database.
Developed new DataStage jobs to clean and load text files into Oracle stage tables. Developed stored procedures to process and integrate raw data from stage into core tables.