Snowflake Developer

Cognizant
Municipality of Madrid, Spain
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Municipality of Madrid, Spain

Tech stack

Amazon Web Services (AWS)
Azure
Cloud Computing
Continuous Integration
ETL
Data Warehousing
DevOps
Python
Performance Tuning
Query Optimization
Role-Based Access Control
Standard Sql
Shell Script
Simple Data Format
Data Streaming
Teradata
Scripting (Bash/Python/Go/Ruby)
Informatica Powercenter
Snowflake
Data Pipelines

Requirements

Design Snowflake data models and objects; architect and build ETL/ELT pipelines using IDMC (preferred). · Optimise performance and cost: warehouse sizing, clustering/partitioning and query tuning. · Implement Snowflake capabilities including Snowpipe, Streams/Tasks and Time Travel. · Manage secure access: RBAC, encryption, storage integrations and external stages. · Rewrite and optimise Teradata SQL; convert Teradata-specific functions to Snowflake equivalents. · Automate operational tasks using Python and/or Shell scripting. · Perform source-to-target data reconciliation and validate transformation logic. · Document solutions, data flows and design decisions; communicate progress to stakeholders. REQUIRED SKILLS & EXPERIENCE · Strong Snowflake architecture expertise and hands-on SQL skills (performance tuning and optimisation). · Proven Teradata SQL knowledge including utilities, functions and migration/conversion experience. · Solid background in data warehousing and ETL/ELT design; hands-on IDMC experience preferred. · Deep knowledge of Snowflake features: Snowpipe, Streams/Tasks, Time Travel/Cloning, micro-partitions, stages, file formats and RBAC. · Cloud platform experience: Azure, AWS or GCP. · Scripting proficiency in Python and/or Shell for automation and pipeline support. · CI/CD and DevOps practices applied to data pipelines. Nice to have: · BFSI domain experience. · Informatica PowerCenter background. · SnowPro certification. Cognizant is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.Inscribirse en esta oferta

Apply for this position