Skip to main content
Tallo logoTallo logo

Find Jobs

Find Jobs Near You – Available Work in Your Location

Rainbow bridge illustration

Find your next move.

Your current job is just the starting point. See where workers like you actually went next.

Powered by real career transition data in the U.S. labor market over the past 20 years. How it works

Requires a free account

Skip to job details

Back to Results

Apply for this opportunity

To apply for this job, you'll continue to an external website or email application.

Purple Drive Technologies LLC

Senior Snowflake Technical Lead (Data Migration & Modernization)

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.
Review key factors to help you decide if the role fits your goals.
Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
74
out of 100
Average of individual scores