Data Engineer / Technical Lead Snowflake Migration

Acunor Infotech
Philadelphia, United States of America
7 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Philadelphia, United States of America

Tech stack

Airflow
Continuous Integration
Directed Acyclic Graph (Directed Graphs)
Information Engineering
ETL
Python
Microsoft SQL Server
DataOps
SQL Stored Procedures
SQL Server Integration Services
Teradata
Enterprise Data Management
Netezza
Snowflake
GIT
PySpark
Data Pipelines
Databricks

Job description

We are seeking a Senior Data Engineer / Technical Lead with strong expertise in Snowflake, Teradata migration, Databricks, PySpark, and Airflow to support a large-scale telecom data modernization initiative. The role involves leading migration, validation, reconciliation, and production cutover activities across enterprise data platforms., * Lead migration and repointing of downstream scripts and pipelines to Snowflake

  • Convert Teradata SQL, BTEQ scripts, macros, and stored procedures into Snowflake SQL
  • Update and validate Airflow DAGs and workflows
  • Coordinate validation, reconciliation, and production cutover activities
  • Troubleshoot pipeline failures, performance issues, and data mismatches
  • Lead onshore/offshore engineering teams and review technical deliverables
  • Maintain migration documentation, issue logs, and deployment checklists
  • Act as the technical point of contact for client and delivery teams

Nice to Have

  • Telecom domain experience (CDR, subscriber data, revenue assurance, etc.)
  • Snowflake certifications (SnowPro Core / Advanced)
  • Experience with IICS, SSIS, Snowpark, or Dynamic Tables
  • Exposure to data observability/validation tools

Requirements

  • 8+ years of Data Engineering experience
  • 3+ years of strong hands-on experience with Snowflake
  • Proven experience in Teradata to Snowflake migration
  • Strong expertise in:
  • Teradata SQL / BTEQ
  • Snowflake SQL
  • PySpark
  • Python
  • Databricks
  • Apache Airflow
  • Experience with ETL / data pipeline modernization
  • Strong experience with SQL Server / Teradata / Netezza source systems
  • Hands-on experience with Git and CI/CD workflows
  • Ability to lead technical teams and manage migration delivery

Apply for this position