Back to Jobs
Recently postedTechnology

Senior Snowflake Technical Lead (Data Migration & Modernization)

Purple Drive Technologies LLCJersey City, NJ🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationJersey City, NJ, United States
OraclePL/SQLSQLApache SparkETLSnowflakeApacheDatabricksReconciliationAzure

Job description

Job Description - Senior Snowflake Technical Lead (Data Migration & Modernization)


Role: Senior Snowflake Technical Lead
Primary Skills: Snowflake, Informatica IICS, Databricks, PySpark
Domain: Enterprise Data Warehouse Modernization & Migration

Role Overview

We are seeking a strong, hands-on Senior Snowflake Technical Lead to lead complex enterprise data warehouse modernization and migration initiatives. The ideal candidate should have extensive experience with Snowflake, Informatica IICS, Databricks, Azure Synapse, and Oracle/Exadata environments.

The candidate will lead end-to-end technical delivery, including migration architecture, solution design, database object migration, historical and incremental data migration, ETL/ELT modernization, data reconciliation, parallel-run validation, and production cutover.

This role requires strong technical ownership, architecture-level decision-making, hands-on problem-solving, and the ability to coordinate with customer architects, application SMEs, platform teams, and offshore engineering teams.

Key Responsibilities

  • Lead end-to-end enterprise data warehouse modernization and migration from platforms such as Azure Synapse and Oracle/Exadata to Snowflake.

  • Design and implement scalable migration strategies for database objects, schemas, historical data, incremental loads, and ETL/ELT workloads.

  • Provide hands-on technical leadership across Snowflake, Informatica IICS/IDMC, Databricks, PySpark, and Azure data services.

  • Lead migration and conversion of SQL/PL-SQL scripts, stored procedures, database objects, and Informatica workloads to the target Snowflake platform.

  • Define reusable migration patterns, technical standards, development guidelines, and engineering best practices.

  • Conduct architecture reviews, technical design reviews, code reviews, and performance assessments.

  • Troubleshoot complex data migration, integration, reconciliation, and performance-related issues.

  • Drive System Integration Testing (SIT), source-to-target data validation, data reconciliation, and parallel-run execution.

  • Lead production cutover planning, migration readiness assessments, deployment coordination, and post-migration stabilization.

  • Coordinate with customer architecture, infrastructure, security, application, and platform teams.

  • Provide technical direction, guidance, and mentorship to distributed and offshore engineering teams.

  • Ensure technical governance, documentation, quality standards, and production readiness throughout the migration lifecycle.


Required Technical Skills

  • 8-10 years of experience in Data Engineering, Data Warehousing, and enterprise data modernization.

  • Strong hands-on experience with Snowflake, including data warehouse development, architecture, SQL, performance optimization, and migration.

  • Strong experience with Informatica IICS (Intelligent Cloud Services) and enterprise ETL/ELT workloads.

  • Hands-on experience with Databricks, Apache Spark, PySpark, and Azure data engineering.

  • Proven experience in complex enterprise data warehouse migration, preferably from Oracle/Exadata or Azure Synapse to Snowflake.

  • Strong SQL and PL/SQL development, conversion, optimization, and database object migration experience.

  • Experience with data modelling, schema migration, historical data migration, incremental loading, and CDC.

  • Strong understanding of data reconciliation, source-to-target validation, data quality, and parallel-run testing.

  • Experience with performance tuning, troubleshooting, and production cutover activities.

  • Proven ability to lead technical teams, make architecture-level decisions, and drive end-to-end technical delivery.


Preferred Skills

  • Informatica IICS / IDMC migration and modernization experience.

  • Oracle Database, Exadata, PL/SQL, and Azure Synapse Analytics.

  • Experience migrating large-scale enterprise data warehouses to Snowflake.

  • Strong knowledge of enterprise data reconciliation, performance optimization, and migration validation frameworks.

  • Experience working with customer-facing architecture teams and offshore delivery teams.


Leadership & Communication Skills

  • Strong technical leadership and solution-design capabilities.

  • Ability to independently drive complex technical decisions and resolve critical issues.

  • Excellent stakeholder communication and customer-facing coordination.

  • Experience conducting design/code reviews and mentoring engineering teams.

  • Strong ownership of delivery milestones, technical quality, and production readiness.


Similar jobs