Senior Snowflake Technical Lead (Data Migration & Modernization)
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.
Skills
Sign in to read and join the discussion.