Key Responsibilities
- Architect, design, and oversee implementation of end-to-end data pipelines using Informatica IICS (Cloud Data Integration, Application Integration, and API Management) to ingest data from diverse source systems into Snowflake.
- Define and enforce Snowflake architecture best practices, including data modeling (star/snowflake schemas, Data Vault), virtual warehouse sizing/cost optimization, clustering, partitioning, and performance tuning.
- Lead the design of scalable ELT/ETL frameworks, ensuring reusability, metadata-driven development, and adherence to data governance standards.
- Own the technical roadmap for cloud data platform modernization, including migration strategies from legacy ETL tools (Informatica PowerCenter, SAP BODS, etc.) to IICS and Snowflake.
- Guide and mentor development teams on IICS mapping design, taskflows, connectors, and Snowflake integration patterns.
- Conduct architecture reviews, code reviews, and performance audits; troubleshoot complex data pipeline and query performance issues.
- Evaluate and recommend new tools, frameworks, and best practices to enhance platform scalability and reliability.
- Create and maintain architecture documentation, data flow diagrams, and technical design specifications.
- Partner with vendors (Snowflake, Informatica) on platform upgrades, licensing, and support escalations.
Required Skills & Experience
- 10+ years of overall experience in data engineering/architecture, with at least 4–5 years in a hands-on architect role.
- Strong, demonstrable expertise in Snowflake: architecture, performance tuning, warehouse management, Snowpipe, Streams & Tasks, Time Travel, and cost governance.
- Proven experience with Informatica IICS (Cloud Data Integration / CDI, Cloud Application Integration / CAI, Mass Ingestion).
- Solid understanding of data modeling techniques (dimensional modeling, Data Vault 2.0, normalized/denormalized schemas).
- Experience integrating data from varied sources: relational databases, flat files, SAP BODS applications.
- Strong SQL skills and experience with query optimization on cloud data warehouses.
- Working knowledge of cloud platforms (AWS, Azure, or GCP) and their native services.
- Experience with CI/CD and version control practices for data pipelines.
- Excellent communication skills with the ability to present architecture decisions to both technical and executive audiences.
Preferred Qualifications
- Snowflake certification (SnowPro Core / SnowPro Advanced Architect).
- Informatica certification (IICS or PowerCenter).
- Experience leading migrations from on-prem ETL/EDW platforms to cloud-native architectures.
- Exposure to SAP BODS
- Background in agile delivery environments and cross-functional team leadership.
Work model
We believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role’s business requirements, this is a hybrid position requiring X days a week in a client or Cognizant office in city, province. Regardless of your working arrangement, we are here to support a healthy work-life balance though our various wellbeing programs.
What you need to have to be considered
- List the most important qualifications in descending order
- Top 5 most important contributions in descending order
- Only go beyond 5 if absolutely necessary
- Be concise but informative
- Related duties should be combined
These will help you stand out
- List the most important nice-to-haves in descending order
- Top 5 most important contributions in descending order
- Only go beyond 5 if absolutely necessary
- Be concise but informative
We're excited to meet people who share our mission and can m
an impact in a variety of ways. Don't hesitate to apply, even if you only meet the minimum requirements listed. Think about your transferable experiences and unique skills that make you stand out as someone who can bring new and exciting things to this role.
Total compensation
We regularly assess market data to ensure we offer a competitive compensation package for our associates. The base salary for this position ranges between $90000– $140000 per year. Where the successful candidate may fall within the range depends on relevant education, work and/or management experience and other business-related and job-necessary qualifications. This position is also eligible for Cognizant’s discretionary annual performance-based bonus, as well as benefits that support your physical, mental and financial wellbeing
À savoir avant de postuler
- Autorisation de travail: Cognizant ne prendra en considération que les candidats à ce poste qui sont légalement autorisés à travailler au Canada sans avoir besoin d'un parrainage de l'employeur, aujourd'hui ou à l'avenir.
- Mesures d’adaptation: Si vous avez un handicap qui nécessite des mesures d’adaptation raisonnable pour effectuer une recherche d’emploi ou poser une candidature, veuillez envoyer un courriel à [email protected] avec votre demande et vos coordonnées.
- L’IA dans notre processus de recrutement: Nous utilisons des outils d'intelligence artificielle (IA) pour trier et évaluer les candidatures efficacement. Notre équipe examine ensuite les candidatures et décide qui passe à l’étape suivante.
- Poste à pourvoir: Sauf indication contraire, ce poste est actuellement vacant et nous cherchons à le pourvoir.
- Exigences linguistiques: Nous demandons à tous les candidats de posséder une connaissance de base de l’anglais afin de faciliter les communications internes. Pour les postes au Québec, la capacité à communiquer efficacement en anglais est requise car vous fournirez des services à et collaborerez avec des parties prenantes anglophones situées hors de la province.
- Inclusion: Cognizant est un employeur souscrivant au principe de l’égalité d’accès à l’emploi. Votre candidature et votre dossier ne seront pas examinés en fonction de la race, de la couleur, du sexe, de la religion, des croyances, de l'orientation sexuelle, de l'identité de genre, de l'origine nationale, du handicap, des renseignements génétiques, de la grossesse, du statut d'ancien combattant ou de toute autre caractéristique protégée par les lois fédérales, provinciales ou locales.
À propos de Cognizant
Cognizant (NASDAQ: CTSH) est un AI Builder et une entreprise de services numériques (ESN) élaborant des solutions complètes d’IA maximisant les investissements pour des résultats concrets. Sa profonde expertise des métiers, des processus et des technologies lui permet d’intégrer dans les systèmes technologiques le contexte unique de chaque organisation de l’ingénierie à la production à l’échelle. Son objectif: améliorer l’efficacité des équipes, créer de la valeur et permettre aux grandes entreprises de rester performantes dans un monde qui évolue rapidement. Pour en savoir plus: cognizant.ai ou @cognizant.
