Snowflake Developer
Role details
Job location
Tech stack
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