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.
コグニザントのコミュニティ：
私たちは、互いを尊重し支え合う優秀な人材の集まりです。社員一人ひとりが成長し、力を発揮できるよう、エネルギッシュで協力的かつインクルーシブな職場環境を大切にしています。
- コグニザントは、世界中に30万人以上のアソシエイトを擁するグローバルコミュニティです。
- 私たちは、より良い方法を夢見るだけでなく、それを実現します。
- 人、クライアント、企業、地域社会、そして環境に対して、常に「正しいこと」を行うことで責任を果たします。
- あなたにとって最適なキャリアパスを築くことができる、革新的な環境を提供します。
私たちについて：
コグニザント（NASDAQ: CTSH）は、AI builderおよびテクノロジーサービスプロバイダとして、AI投資を企業価値へとつなげるフルスタックのAIソリューションを提供しています。業界、業務プロセス、エンジニアリングに関する深い専門性を強みに、各企業固有のコンテキストをテクノロジーシステムに組み込み、人の力を最大限に引き出すとともに、具体的な成果の創出と、急速に変化する世界におけるグローバル企業の競争力維持を支援します。詳しくは、当社ウェブサイト www.cognizant.com をご覧ください。
コグニザントは機会均等を重視する雇用主です。応募者および候補者は、人種、肌の色、性別、宗教、信条、性的指向、性自認、国籍、障がい、遺伝情報、妊娠、退役軍人の地位、または連邦、州、地方の法律で保護されているその他の特性に基づいて差別されることはありません。
免責事項：
応募者は、対面またはビデオ会議による面接への参加を求められる場合があります。また、各面接の際に、現住所または政府発行の身分証明書の提示が必要となる場合があります。