Migration Specialist

About the role

We are seeking an experienced Ab Initio Migration Specialist for a long-term contract engagement based onsite in Phoenix, AZ. This is a critical SME role focused on the migration of Ab Initio graphs and plans to Azure Databricks ETL jobs, spanning assessment, conversion, validation, and cutover phases.

Responsibilities

• Analyze and interpret existing Ab Initio graphs, plans, and components to document business and transformation logic.
• Translate complex Ab Initio functions (transform, rollup, join, partition/departition, lookup, normalize/denormalize, etc.) into Databricks ETL designs.
• Partner with business teams to capture requirements and translate them into actionable specifications for offshore development teams.
• Provide technical guidance, knowledge transfer, and data debugging support to offshore engineers.
• Troubleshoot and resolve source-side Ab Initio ETL execution issues to keep migration and validation on track.
• Define reusable conversion patterns, templates, and best practices to accelerate delivery.
• Support SIT/UAT cycles, validate data parity, and assist with performance tuning on Databricks.
• Maintain flexible working hours to ensure effective overlap with offshore teams across time zones.

Requirements

• Strong hands-on expertise with Ab Initio (GDE, Co>Operating System, EME, Conduct>It plans, Continuous Flows).
• Deep understanding of Ab Initio graph design, components, and DML/transform functions.
• Working knowledge of Azure Databricks, Apache Spark, PySpark, and SQL.
• Proven experience in legacy ETL modernization or migration programs.
• Strong data analysis, validation, and debugging skills with the ability to trace logic across complex pipelines.
• Excellent communication skills to work across business stakeholders and distributed offshore teams.

Qualifications

• Must be authorized to work in the US — USC or GC holders only (no sponsorship available).

Preferred Qualifications

• 5–10 years of overall experience in data engineering or ETL development.
• Experience migrating Ab Initio (or comparable legacy ETL such as Informatica/Teradata) to Databricks or other cloud lakehouse platforms.
• Familiarity with Azure data services (ADLS, ADF, Azure SQL) and CI/CD for data pipelines.
• Domain exposure to healthcare, banking, or other regulated, data-intensive industries.
• Experience leading or mentoring offshore delivery teams.
• Able to work flexible hours to maintain effective overlap with offshore time zones.

Skills

Strong hands-on expertise with Ab Initio (GDE, Co>Operating System, EME, Conduct>It plans, Continuous Flows).

Deep understanding of Ab Initio graph design, components, and DML/transform functions.

Working knowledge of Azure Databricks, Apache Spark, PySpark, and SQL.

Proven experience in legacy ETL modernization or migration programs.

Strong data analysis, validation, and debugging skills with the ability to trace logic across complex pipelines.

Excellent communication skills to work across business stakeholders and distributed offshore teams.

Benefits

N/A

Pay

N/A

Schedule

N/A