Switch Career to Legacy On-Prem to Databricks

Sadam Hussain

profile
Switch Career to Legacy On-Prem to Databricks
profile
$30$36
60 mins

Description:

Migrating from legacy on-prem ETL systems to a modern cloud Lakehouse is one of the most in-demand skills in data engineering right now — and one of the most misunderstood. I've done this hands-on: migrating SSIS packages for ASDA/Walmart to Databricks on Azure, and rebuilding Oracle ODI pipelines into PySpark on cloud. In this session I'll walk you through the exact approach, pitfalls to avoid, and how to think about the transition architecturally.

What we'll cover:

  1. Mapping legacy concepts to Databricks equivalents (SSIS jobs → ADF + Databricks notebooks, stored procs → PySpark, on-prem DB → Delta Lake)
  2. Medallion architecture design for migrated workloads
  3. Incremental vs full load strategies on Delta Lake
  4. Unity Catalog setup and data governance post-migration
  5. Common mistakes and how to avoid them
  6. Building a migration roadmap you can actually execute

Best for: Data engineers or teams currently working on SSIS, ODI, Informatica, or on-prem SQL Server/Oracle who want a clear, practical path to modernizing their stack on Databricks.