ETL​/Data Engineer – Legacy -Premises to Azure Migration

Swiss Himmel GmbH Vacant since : 08.10.2026 Number of jobs : 1 4051 Basel (BS) 100% Immediately Permanent

ETL / Data Engineer – Legacy On-Premises to Azure Migration

Location:

Basel, Switzerland Company:
Swiss Himmel GmbH

Employment Type:

Full-time

Experience:

12+ years

Domain:
Data Engineering / Data Warehousing / Cloud Migration About Swiss Himmel GmbHSwiss Himmel GmbH is a Basel-based technology and consulting firm partnering with leading enterprises to modernize complex technology and data platforms. We combine strong engineering expertise with practical delivery to support data transformation, cloud migration, enterprise applications, and digital initiatives across regulated industries.

About the Role Swiss Himmel GmbH is looking for an experienced ETL / Data Engineer to support the modernization of a legacy on-premises data platform as it gradually transitions to Azure.

The role will initially focus on maintaining and enhancing the existing Informatica Power Center, PostgreSQL, Unix, and Autosys environment, while progressively contributing to the migration of workloads to Azure Databricks, PySpark, and Microsoft Fabric Data Factory.

The migration will follow a phased approach, with legacy and cloud platforms operating in parallel. The successful candidate will help maintain the stability of the existing platform while supporting data migration, validation, reconciliation, and cloud adoption activities.

Project Overview Current Environment

• Legacy on-premises data warehouse based on Informatica Power Center and PostgreSQL.
• Unix shell scripting for automation and processing.
• Autosys for batch scheduling and job management.
• Power BI and Tableau for reporting.
• Git Lab CI/CD for deployment and version control.
• Target Environment
• Azure-based data platform.
• Azure Databricks and PySpark for cloud data processing.
• Microsoft Fabric Data Factory for data integration.
• Azure Dev Ops for development and deployment activities.
• Migration Approach
• Phased migration from on-premises to Azure.
• Legacy and cloud workloads running in parallel during transition.
• Data validation and reconciliation through parallel processing.
• Controlled production releases through Service Now Change Management.

• Key Responsibilities ETL & Data Engineering
• Develop, maintain, and troubleshoot Informatica Power Center mappings, workflows, and sessions.
• Develop and optimize complex SQL, functions, and stored procedures in PostgreSQL.
• Build and maintain Unix shell scripts for file processing, job automation, and monitoring.
• Schedule, monitor, and manage batch jobs using Autosys, including JIL, dependencies, and failure handling.
• Support data quality, validation, and reconciliation activities across source and target environments.
• Azure Migration
• Support the migration of existing ETL workloads from on-premises platforms to Azure.
• Develop and maintain PySpark workloads in Azure Databricks.
• Support data integration development using Microsoft Fabric Data Factory.
• Validate migrated workloads through parallel runs and data reconciliation.
• Contribute to the gradual modernization of the existing data platform.
• CI/CD & Deployment
• Set up and maintain Git Lab CI/CD pipelines for code versioning and deployment.
• Support Azure Dev Ops-based development and deployment activities.
• Ensure controlled and documented deployments across development, testing, and production environments.
• Reporting & Data Support
• Support reporting teams with data validation and troubleshooting.
• Assist with Power BI and/or Tableau reporting requirements.
• Ensure data consistency and accuracy for downstream reports and business users.
• Production Support & Change Management
• Support production environments and troubleshoot data and ETL-related issues.
• Perfo…