Cognizant

IT Services and IT Consulting · Canada

Website

Open jobs in Canada

12 hours ago
Salesforce Solution Architect
Cognizant
Toronto, ON
Full-time
12 hours ago
Senior Test Analyst (Mainframe Testing)
Cognizant
Toronto, ON
Full-time
12 hours ago
Salesforce Business Analyst w/ FSC
Cognizant
Toronto, ON
Full-time
12 hours ago
Senior .NET Core Azure Developer (Hybrid)
Cognizant
Halifax, NS
Full-time
12 hours ago
Senior Penetration Tester & Red Team Engineer
Cognizant
Toronto, ON
Full-time
1 day ago
AI Automation Test Lead/Architect
Cognizant
Toronto, ON
Full-time
1 day ago
ETL Consultant (Hybrid)
Cognizant
Halifax, NS
Full-time
1 day ago
AI Engineer
Cognizant
Toronto, ON
Full-time
1 day ago
Consulting Manager - Capital Management
Cognizant
Toronto, ON
Full-time
2 days ago
Test Automation Engineer
Cognizant
Toronto, ON
Full-time
2 days ago
Senior Test Automation Engineer
Cognizant
Toronto, ON
Full-time
5 days ago
AI Test Automation Engineer
Cognizant
Toronto, ON
Full-time
5 days ago
Business Systems Analyst – Infrastructure Operations
Cognizant
Toronto, ON
Full-time
5 days ago
Senior Mainframe Engineer (COBOL, DB2, CICS)
Cognizant
Waterloo, ON
Full-time
6 days ago
Playwright Automation Test Engineer
Cognizant
Toronto, ON
Full-time
6 days ago
Big Data Developer
Cognizant
Toronto, ON
Full-time
7 days ago
AWS Architect
Cognizant
Halifax, NS
Full-time
7 days ago
.Net Architect
Cognizant
Halifax, NS
Full-time
7 days ago
Autonomous Vehicle Fleet Supervisor
Cognizant
Toronto, ON
Full-time
7 days ago
Salesforce Technical Lead
Cognizant
Toronto, ON
Full-time
7 days ago
Lead Mainframe Developer
Cognizant
Mississauga, ON
Full-time
7 days ago
Senior Java Full Stack Developer (Core Java, Spring Boot, Oracle) (Hybrid)
Cognizant
Calgary, AB
Full-time
8 days ago
Oracle Exadata DBA Architect (Oracle RAC, Data Guard, RMAN)
Cognizant
Mississauga, ON
Full-time
8 days ago
Senior Java Engineer
Cognizant
Toronto, ON
Full-time
9 days ago
Lead Security Operations Engineer - Netskope
Cognizant
Canada
Full-time

Back to results

1 day ago

Cognizant

ETL Consultant (Hybrid)

Halifax, NS, Canada

Full-time

Apply About employer

Applications open in a new tab.

At a glance

Automatically prepared from the listing. Check the original description for the full requirements.

Jump to the original description

Responsibilities

Architect and oversee the implementation of end-to-end data pipelines using Informatica IICS and Snowflake. Lead the technical roadmap for cloud data platform modernization and mentor development teams on integration patterns and performance tuning.

Requirements

Requires over 10 years of data engineering experience with deep expertise in Snowflake and Informatica IICS. Candidates should possess strong data modeling skills and experience with cloud platforms and CI/CD practices.

Experience

10+ years

Working hours

40 hours per week

Job type

Full-time

Work arrangement

Hybrid

Skills

Snowflake
Informatica IICS
Data Modeling
ETL/ELT Frameworks
SQL
Cloud Data Integration
Cloud Application Integration
Data Vault 2.0
Performance Tuning
CI/CD
AWS
Azure
GCP
SAP BODS
Architecture Design
Metadata-driven Development

Benefits

Discretionary annual performance-based bonus
Physical wellbeing programs
Mental wellbeing programs
Financial wellbeing programs

Minimum pay

90000

Maximum pay

140000

Pay currency

CAD

Pay period

YEAR

Visa sponsorship

Not detected in the job text

Keywords

Snowflake
Informatica IICS
CDI
CAI
Snowpipe
Streams & Tasks
Time Travel
Data Vault 2.0
Dimensional Modeling
SAP BODS
Informatica PowerCenter
SQL
AWS
Azure
GCP
CI/CD
SnowPro Core
SnowPro Advanced Architect
Agile
Data Governance
ELT
ETL
Cloud Data Warehouse
Performance Tuning
Data Pipelines
Metadata-driven Development
Virtual Warehouse
Clustering
Partitioning
API Management

Original job description

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

Apply by Oct 15, 2026

Apply About employer

Report this job