Senior Snowflake Technical Lead (Data Migration & Modernization)
Quick overview
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
- EH

Interventional Procedures Tech - Cath Lab
Endeavor Health · Arlington Heights, IL · Hybrid 🇺🇸
Technology$37 - $58/hr - AP
Paid Panel Immediate Start. Full-Time / Part-Time. Help Desk Support WelcomeRecently posted
ApexGroup · Ace, TX · Hybrid · Posted 15 Nov 2026 🇺🇸
Help DeskExpressTechnologySalary not listed - AD

Software Development Engineer, Region Reliability Engineering - Amazon Development Center U.S., Inc.Recently posted
Amazon Development Center U.S., Inc. · Denver, CO · Hybrid · Posted 15 Nov 2026 🇺🇸
AWSTechnology$143.7k - $194.4k/yr - AW

Software Development Engineer, EC2 Nitro Networking - Amazon Web Services, Inc.Recently posted
Amazon Web Services, Inc. · San Diego, CA · Hybrid · Posted 15 Nov 2026 🇺🇸
AWSEmbedded SystemsEncryption+2Technology$143.7k - $194.4k/yr - AS

Software Development Engineer, Amazon QuickSuite - Amazon.com Services LLCRecently posted
Amazon.com Services LLC · Seattle, WA · Hybrid · Posted 15 Nov 2026 🇺🇸
DynamoDBAWSC#+6Technology$143.7k - $194.4k/yr - AS

Software Development Engineer II , Amazon Fulfillment Technologies - Inbound - Amazon.com Services LLCRecently posted
Amazon.com Services LLC · Bellevue, WA · Hybrid · Posted 15 Nov 2026 🇺🇸
SQLAWSETL+15Technology$143.7k - $194.4k/yr - AS

Software Development Engineer, Amazon Devices, DS2 (Device Software & Services) - Amazon.com Services LLCRecently posted
Amazon.com Services LLC · Denver, CO · Hybrid · Posted 15 Nov 2026 🇺🇸
ScrumAgileTechnology$143.7k - $194.4k/yr - VA

AI Software Engineer (TS/SCI) - VantorRecently posted
Vantor · Herndon, VA · On-site · Posted 15 Nov 2026 🇺🇸
MicroservicesGitC+++13Technology$140k - $200k/yr - AS

Software Development Engineer, Amazon Quick Suite - Amazon.com Services LLC
Amazon.com Services LLC · Seattle, WA · Hybrid · Posted 1 Nov 2026 🇺🇸
DynamoDBAWSC#+6Technology$143.7k - $194.4k/yr - VA

AI Software Engineer (TS/SCI with CI Poly) - VantorRecently posted
Vantor · Herndon, VA · On-site · Posted 15 Nov 2026 🇺🇸
MicroservicesGitC+++13Technology$140k - $200k/yr - AD

Software Development Engineer, ADC2S - Amazon Development Center U.S., Inc.Recently posted
Amazon Development Center U.S., Inc. · Herndon, VA · Hybrid · Posted 15 Nov 2026 🇺🇸
AWSLinuxTechnology$143.7k - $194.4k/yr - DA
Life Sciences (Experimental Biology) - AI TrainerRecently posted
DataAnnotation · Stillwater, Oklahoma · Remote · Posted 15 Nov 2026 🇺🇸
OnboardingMicrosoft ExcelGoogle Workspace+6Technology$40 - $125/hr