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

ETL / Data Engineer – Legacy On-Premises to Azure MigrationSwiss Himmel GmbH Vacant since : Number of jobs : 1 4051 Basel (BS) 100% Immediately PermanentETL / Data Engineer – Legacy On-Premises to Azure MigrationLocation: Basel, SwitzerlandCompany: Swiss Himmel GmbHEmployment Type: Full-timeExperience: 12+ yearsDomain: Data Engineering / Data Warehousing / Cloud MigrationAbout 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 RoleSwiss 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 PowerCenter, 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 OverviewCurrent EnvironmentLegacy on-premises data warehouse based on Informatica PowerCenter and PostgreSQL.Unix shell scripting for automation and processing.Autosys for batch scheduling and job management.Power BI and Tableau for reporting.GitLab CI/CD for deployment and version control.Target EnvironmentAzure-based data platform.Azure Databricks and PySpark for cloud data processing.Microsoft Fabric Data Factory for data integration.Azure DevOps for development and deployment activities.Migration ApproachPhased 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 ServiceNow Change Management.Key ResponsibilitiesETL & Data EngineeringDevelop, maintain, and troubleshoot Informatica PowerCenter 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 MigrationSupport 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 Website & DeploymentSet up and maintain GitLab CI/CD pipelines for code versioning and deployment.Support Azure DevOps-based development and deployment activities.Ensure controlled and documented deployments across development, testing, and production environments.Reporting & Data SupportSupport 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 ManagementSupport production environments and troubleshoot data and ETL-related issues.Perform root cause analysis and implement corrective actions.Create, track, and implement Change Requests in ServiceNow.Participate in CAB approvals, implementation activities, and post-implementation reviews.Support production cutovers and migration activities.Maintain stability of the legacy platform throughout the migration.Required Qualifications & Experience12+ years of experience in ETL development, data engineering, or data warehousing.Strong hands-on experience with Informatica PowerCenter.Strong knowledge of PostgreSQL, including SQL development and performance tuning.Strong experience with Unix/Linux and shell scripting.Hands-on experience with Autosys job scheduling.Experience with GitLab CI/CD and deployment processes.Experience with Power BI and/or Tableau.Working knowledge of PySpark and Azure Databricks.Working knowledge of Microsoft Fabric Data Factory.Working knowledge of Azure DevOps.Hands-on experience with ServiceNow Change Management, including CR creation, CAB approval, implementation, and post-implementation review.Experience supporting production environments and performing root cause analysis.Strong analytical and troubleshooting skills.Good to HavePrevious experience with on-premises to cloud data migration.Understanding of ITIL Incident, Problem, and Change Management.Microsoft Azure or Fabric certifications such as DP-700, DP-600, or AZ-900.Experience working in Agile environments.Experience supporting large enterprise data warehouse platforms.Why Join Swiss Himmel GmbH?Work on a large-scale on-premises to Azure data modernization program.Gain hands-on exposure to Azure Databricks, PySpark, and Microsoft Fabric.Work with enterprise data platforms and complex migration environments.Collaborate with experienced data engineering, infrastructure, and business teams.Opportunity to contribute to both legacy platform stability and cloud transformation.Professional and collaborative working environment in Basel.Long-term career growth opportunities within Swiss Himmel GmbH.Competitive Swiss compensation and benefits.Work location 4051 Basel (BS)Workload 100%Employment start ImmediatelyEmployment duration PermanentQualification skilledWork experience More than 3 yearsEducation Bachelor’s degree from a university of applied sciences or equivalentEnglish Orally : Very good knowledge Written : Very good knowledgeGerman Orally : Good knowledge Written : Basic knowledgeBy email #J-18808-Ljbffr