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.
What we offer
- The chance to work with impact. Here, you’re empowered to bring your biggest thinking to help our company and clients improve everyday life.
- Ownership over your career. Stay at the top of your game through our award-winning learning and development ecosystem. And when your ambitions change or we offer new opportunities, we help you pivot by providing reskilling, on-the-job learning and guidance to find new roles that might be a better fit.
- The opportunity to thrive on a high caliber team with heart. We celebrate each other’s experiences and perspectives and promote a sense of belonging through our affinity groups and diversity and inclusion initiatives.
- A comprehensive total rewards package, including a competitive salary and a pension plan with matching contributions.
- Flexible health and financial benefits to support you and your eligible dependents—from day one.
- True work-life balance. Be at your best through paid time off, flexible work arrangements, volunteering opportunities, social events, and so much more.
About us
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, building the bridge between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, realize tangible returns and keep global enterprises ahead in a fast-changing world. See how at www.cognizant.com or @cognizant.
Other employment-related information
Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, provincial or local laws.
If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email [email protected] with your request and contact information.
Language requirements vary depending on roles, but we ask that all candidates have basic English proficiency for company-wide communications purposes. For roles based in Quebec, professional English proficiency is required, as you’ll deliver services to and collaborate with stakeholders outside the province who may not speak French.
