3 days ago
Stockholm, SwedenMid Level
Responsibilities
- Translate business requirements into technical data engineering solutions.
- Design, develop, and implement ETL/ELT pipelines to migrate data from Teradata to Snowflake.
- Optimize migration processes for data integrity, accuracy, performance, scalability, and cost efficiency.
- Create and manage Snowflake tables, views, schemas, stages, procedures, file formats, and other database objects.
- Implement Snowflake partitioning, clustering, Snowpipe, Streams, Tasks, Time Travel, external stages, storage integrations, access controls, and role-based permissions.
- Develop data models, schemas, stored procedures, and Snowflake SQL for migrated data.
- Automate ingestion and migration tasks using Snowflake connectors, Python, and shell scripting.
- Rewrite Teradata SQL scripts, macros, stored procedures, and utilities for Snowflake compatibility.
- Monitor and tune Snowflake warehouses, queries, resource utilization, and overall platform performance.
- Conduct post-migration data reconciliation between Teradata and Snowflake.
- Collaborate with data architects, analysts, and business stakeholders and document migration processes and best practices.
Requirements
- Strong hands-on experience with Snowflake cloud data warehousing and Snowflake features including Time Travel, Cloning, micro-partitions, Streams, Tasks, Snowpipe, external stages, storage integrations, file formats, and RBAC.
- Strong SQL experience with database technologies including Oracle, Teradata, SQL Server, and PostgreSQL.
- Experience with data engineering or database development, data migrations, batch processing, and data loading or transformation strategies.
- Proficiency with Python or shell scripting for automation.
- Understanding of Teradata architecture, SQL, and utilities including BTEQ, FastLoad, MultiLoad, and TPT.
- Knowledge of DevOps and CI/CD practices for data pipelines and workflows.
- Experience analyzing and converting Teradata-specific functions to Snowflake equivalents.
- Strong problem-solving and analytical skills.
- Snowflake SnowPro Certification is preferred.
- Experience in banking and financial services is preferred.
Benefits
- Collaborative, inclusive, and energetic international workplace.
- Opportunities to work with colleagues and clients globally and build a career path within a large professional services company.
- Equal opportunity employment protections are provided.
Tech Stack
Categories
Data Engineering
About Cognizant
Cognizant is a public IT services and consulting firm that designs, builds, and runs enterprise technology, including digital engineering, cloud modernization, data/AI, and managed services. It sells consulting, systems integration, and outsourcing on multi-year engagements to large enterprises in healthcare, banking, retail, communications, and manufacturing. Founded in 1994 and headquartered in Teaneck, New Jersey, Cognizant is NASDAQ-listed (CTSH) and a Fortune 500 company.