What makes Cognizant a unique place to work? The combination of rapid growth and an international and innovative environment! This is creating a lot of opportunities for people like YOU — people with an entrepreneurial spirit who want to make a difference in this world. At Cognizant, together with your colleagues from all around the world, you will collaborate on creating solutions for the world's leading companies and help them become more flexible, more innovative and successful.
The role
Snowflake Developer is responsible for designing, building, and optimizing data pipelines using Snowflake and IDMC. Build and maintain ETL/ELT workflows and data pipelines using Snowflake and IDMC to process large datasets efficiently. Design data models, create and maintain views, stored procedures, and other database objects in Snowflake, optimize data storage, and ensure scalability in Snowflake. Implement data governance, access controls, and encryption to protect sensitive information.
Key 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 and ensure 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 using different file format, code pages, and any integration with Saas tools (e.g. dbt cloud, Fivetran, Databricks etc).
· 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.
Technical Skills
· Strong hands-on experience with Snowflake cloud data warehouse.
· Knowledge of Snowflake features: Time Travel, Cloning, Micro-partitions, Streams & Tasks.
· Hands on experience in Snowflake features like external stages, Snowpipe, storage integration, File Formats, RBAC etc
· Strong experience with SQL and various database technologies (Oracle, Teradata SQL Server, PostgreSQL, etc.).
· Knowledge of DevOps and CI/CD practices for data pipelines and workflows.
· Experience in data engineering or database development, particularly with data migrations.
· Experience in different batch processing and data loading/transformation strategies.
· Proficiency in scripting for automating regular or repeating task (python, shell scripting etc).
· Understanding of Teradata architecture, SQL, and utilities (BTEQ, FastLoad, MultiLoad, TPT).
· Experience in analysing and converting Teradata-specific functions to Snowflake equivalents.
· Strong problem-solving and analytical skills.
· Snowflake SnowPro Certification is a plus
· Experience in banking and financial services will be preferred.
关于高知特 (Cognizant)
高知特(Cognizant)（纳斯达克代码：CTSH）作为一家AI Builder和相关技术服务提供商，致力于通过打造全栈AI解决方案，帮助企业将人工智能投资转化为实际价值。公司凭借深厚的行业经验、流程优化和工程技术专长，将企业独特的业务场景融入科技系统，赋能组织释放人才潜能，推动切实成果，并帮助全球企业在瞬息万变的环境中保持领先。如需了解更多详情，敬请访问 cognizant.ai 或关注@cognizant。
补充雇佣信息
薪酬信息截至本职位发布之日为准。Cognizant 保留在适用法律允许的范围内随时修改该信息的权利。
申请人可能需要通过现场面试或视频会议的方式参加面试。此外，候选人在每次面试时可能需要出示其当前所在州或政府签发的有效身份证件。
Cognizant 是一家提供平等就业机会的雇主。在招聘过程中，您的申请和候选资格不会因种族、肤色、性别、宗教、信仰、性取向、性别认同、国籍、残疾、遗传信息、怀孕、退伍军人身份或任何其他受联邦、州或地方法律保护的特征而受到影响。
