Teradata-to-Snowflake Migration Architect

Cognizant Technology Solutions Sweden AB; Stockholms kommun; On-site; SEK 750,000 - 1,000,000; Full time

Job summary

Cognizant Technology Solutions Sweden AB is seeking a Snowflake Developer to design, build, and optimize data pipelines using Snowflake and IDMC, delivering scalable ETL/ELT workflows for large datasets.

You will implement data governance, access controls, and encryption, rewrite Teradata SQL to Snowflake, automate migrations, and collaborate with data architects and stakeholders to translate business requirements into technical solutions.

Qualifications

• Design and implement Snowflake data pipelines and data models.
• Migrate data from Teradata to Snowflake with ETL/ELT processes.
• Ensure data governance, access controls, and encryption.

Responsibilities

• Analyse business requirements and translate them into technical solutions.
• Design, develop, and implement ETL/ELT pipelines to migrate data from Teradata to Snowflake.
• Optimize migration processes ensuring data integrity, accuracy, and performance.
• Create and manage Snowflake objects (tables, views, schemas, stages, procedures).
• Implement partitioning, clustering, and performance tuning strategies.
• Implement and manage Snowflake features such as Snowpipe, Streams, Tasks, and Time Travel.
• Develop and maintain data models, schemas, and stored procedures in Snowflake SQL.
• Monitor and tune Snowflake performance, including warehouse sizing and query optimization, ensuring efficient resource utilization and cost optimization.
• Manage external stages, storage integrations, data security, access controls, and role‑based permissions in Snowflake.
• Automate data ingestion from various sources using Snowflake connectors and external stages with different file formats, code pages, and integrations with SaaS tools (e.g., dbt cloud, Fivetran, Databricks).
• Rewrite and optimize Teradata SQL scripts, macros, and stored procedures for Snowflake compatibility.
• Develop reusable scripts for automation of migration tasks (Python, Shell, etc.).
• Conduct data reconciliation between Teradata and Snowflake post‑migration.
• Work closely with data architects, analysts, and business stakeholders to understand requirements.
• Document migration processes, best practices, and technical solutions.

Skills

Snowflake

SQL

ETL/ELT

Python

Data modeling

Tools

dbt Cloud

Fivetran

Teradata

Airflow

Snowflake

Job description

Cognizant Technology Solutions Sweden AB is seeking a Snowflake Developer to design, build, and optimize data pipelines using Snowflake and IDMC, delivering scalable ETL/ELT workflows for large datasets.

You will implement data governance, access controls, and encryption, rewrite Teradata SQL to Snowflake, automate migrations, and collaborate with data architects and stakeholders to translate business requirements into technical solutions.