Azure Databricks Engineer

Valiant Technologies LLC; Wilmington (DE); On-site; USD 140,000 - 190,000; Full time

Job summary

Valiant Technologies LLC seeks an experienced data engineering leader to drive the migration of complex data pipelines from Informatica PowerCenter to Azure Databricks. You will define the target architecture, craft phased execution plans, and establish success metrics to ensure data quality and performance.

You will guide solution design, engineering standards, and testing strategies, while mentoring teams in Databricks patterns and modern ELT approaches to achieve scalable and observable data

Qualifications

• Experience leading end-to-end data migration projects from legacy ETL to modern platforms.
• Strong knowledge of Azure Databricks best practices, Delta Lake, and data quality.
• Experience assessing, designing, and executing migration strategies with phased delivery.

Responsibilities

• Lead end-to-end migration of data pipelines, workflows, and integration patterns from Informatica to Azure Databricks.
• Define target state architecture and migration plans with phased execution and milestones.
• Provide technical leadership across design, standards, testing, deployment, and production readiness.
• Collaborate with business, architecture, security, and operations to align outcomes with enterprise priorities.
• Establish migration success criteria for data quality, performance, resilience, and observability.
• Mentor engineers on Databricks design patterns and modern data engineering practices.

Skills

Informatica

Azure Databricks

PySpark

Data migration

ETL/ELT

Data pipelines

Architecture

Tools

Informatica PowerCenter

Azure Databricks

Delta Live Tables

Unity Catalog

ADLS Gen2

Oracle

Job description

• Lead the end to end migration of data pipelines, workflows, and integration patterns from Informatica to Azure Databricks.
• Assess current state Informatica assets and define target state architecture, migration strategy, and phased execution plans. The current environment is based on Informatica PowerCenter 10.4.1 running batch ETL workloads, with Oracle as both the source and target database. The target state platform is Azure Databricks (Runtime 14.4 LTS) with Unity Catalog, Delta Live Tables (DLT), and ADLS Gen2.
• Drive modernization of ETL patterns into scalable ELT and data engineering approaches aligned with Azure Databricks best practices.
• Analyze and interpret complex Informatica PowerCenter mappings, including transformations, lookups, joins, filters, routers, and expression logic, and build equivalent PySpark based pipelines in Azure Databricks.
• Assess Oracle database level stored procedures, functions, and packages that are invoked by or tightly coupled with Informatica workflows, and determine whether to migrate, refactor, or recreate that logic within Databricks using PySpark, Python, or Spark SQL.
• Provide technical leadership across solution design, engineering standards, code quality, testing strategy, deployment, and production readiness.
• Partner with business, product, architecture, infrastructure, security, and operations stakeholders to align migration outcomes with enterprise priorities.
• E stablish migration success criteria covering data quality, reconciliation, performance, resilience, observability, and business continuity.
• Identify delivery risks, dependencies, and technical constraints early, and drive mitigation plans through execution.
• Guide cutover, stabilization, and post migration optimization to ensure sustainable platform adoption and operational excellence.
• Mentor engineers and technical teams on Databricks design patterns, reusable frameworks, and modern data engineering practices

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.