Azure Databricks Migration Engineer (ETL to ELT)

Robotic Technologies Automation; Wilmington (DE); Sur place; USD 120 000 - 160 000; Plein temps

Résumé du poste

Robotic Technologies Automation in Wilmington, Delaware, is seeking a senior data engineering lead to drive the end-to-end migration from Informatica to Azure Databricks. You will design target state architecture, define migration strategy, and ensure a smooth transition from batch ETL on Oracle to modern ELT pipelines.

You will translate complex mappings to PySpark, lead technical decisions, collaborate with security and operations, establish success criteria, and mentor teams to achieve

Responsabilités

• Lead end-to-end migration of data pipelines, workflows, and integration patterns from Informatica to Azure Databricks.
• Assess current Informatica assets and define target architecture, migration strategy, and phased execution plans.
• Modernize ETL patterns into scalable ELT using Azure Databricks best practices.
• Translate Informatica PowerCenter mappings into PySpark pipelines in Databricks.
• Evaluate Oracle stored procedures and migrate/refactor logic in Databricks with PySpark or Spark SQL.
• Provide technical leadership on design, standards, testing, deployment, and production readiness.
• Collaborate with business, product, architecture, security, and operations to align migration with enterprise priorities.
• Establish migration success criteria for data quality, reconciliation, performance, resilience, and observability.
• Identify risks and dependencies early; drive mitigation plans.
• Guide cutover, stabilization, and post-migration optimization for platform adoption.
• Mentor engineers on Databricks design patterns and modern data engineering practices.

Description du poste

Robotic Technologies Automation in Wilmington, Delaware, is seeking a senior data engineering lead to drive the end-to-end migration from Informatica to Azure Databricks. You will design target state architecture, define migration strategy, and ensure a smooth transition from batch ETL on Oracle to modern ELT pipelines.

You will translate complex mappings to PySpark, lead technical decisions, collaborate with security and operations, establish success criteria, and mentor teams to achieve