Databricks Architect - ETL Modernization / SSIS Migration (Remote LATAM)

Atmosera

Remote regions

LATAM

Benefits

Similar Jobs

See all

Sr Data Architect

Zennify

Azure AWS Snowflake

Data Engineer (Tech-lead)

In All Media

LATAM

Python SQL Bash

Lead Data Architect

Henry Schein

US

SQL NoSQL Python

Senior Data Engineer

CodeRoad

Latin America

SQL Python Scala

Databricks Engineer

Bridgenext

Canada

PySpark Databricks

Assessment & Discovery:

  • Analyze the current SSIS packages, SQL Server Agent jobs, and cross-database synchronization processes.
  • Document existing data flows, scheduling and orchestration patterns, transformation logic, and dependencies between SQL Server and Oracle systems.
  • Identify bottlenecks, operational risks, opportunities to simplify pipelines, and define migration complexity and sequencing strategy.

Architecture & Migration Design:

  • Define the target-state architecture using Databricks and Delta Lake.
  • Design modern equivalents for SSIS ETL packages, SQL Agent job orchestration, and cross-database synchronization logic.
  • Define patterns for data ingestion from SQL Server and Oracle, incremental data synchronization, job orchestration, and error handling.

Implementation Support:

  • Guide or support the implementation of Databricks pipelines, jobs, and notebooks that replace existing SSIS workloads.
  • Assist engineering teams in rebuilding ETL logic in Databricks, implementing incremental ingestion patterns, validating data consistency between systems, and supporting testing and cutover planning.

Atmosera

Atmosera empowers businesses to redefine what's possible with modern technology and human expertise. They expertly deliver cutting-edge, integrated solutions that deliver business value as a Microsoft Partner with seven specializations, GitHub AI Partner of the Year, a member of the GitHub Advisory Board, and a member of the prestigious Microsoft Intelligent Security Association (MISA).

Apply for This Position