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.

SAP FICO SME

Key skills

About this role