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.