ETL Consultant (Hybrid)

Cognizant; Halifax; Hybrid; CAD 90,000 - 140,000; Full time

Benefits offered by this job

Hybrid work model

Competitive compensation

Bonus eligibility

Job summary

Cognizant is seeking an experienced data engineering/architect leader in Canada to design and implement end-to-end data pipelines using Informatica IICS and Snowflake. You will define best practices, drive modernization, and mentor teams across cloud platforms.

The role emphasizes scalable ELT/ETL design, governance, and collaboration with vendors. A hybrid work setup and competitive compensation are offered.

Qualifications

• 10+ years in data engineering/architecture, with hands-on architect role (4–5 years).
• Strong Snowflake expertise: architecture, performance, cost governance.
• Proven experience with Informatica IICS (CDI/CAI/Mass Ingestion).
• Data modeling knowledge: dimensional modeling, Data Vault 2.0.
• Experience integrating data from varied sources (relational DBs, flat files, SAP BODS).
• Strong SQL and query optimization for cloud data warehouses.
• Cloud platforms knowledge (AWS/Azure/GCP) and their native services.
• CI/CD and version control for data pipelines.
• Excellent communication for presenting decisions to technical and executive audiences.

Responsibilities

• Architect, design, and oversee end-to-end data pipelines using Informatica IICS to Snowflake.
• Define Snowflake architecture best practices, modeling, and performance tuning.
• Lead scalable ELT/ETL frameworks with governance and metadata-driven development.
• Own roadmap for cloud data platform modernization and migrations to IICS/Snowflake.
• Mentor teams on IICS mapping design and Snowflake integration patterns.
• Conduct architecture/code reviews and troubleshoot data pipelines and queries.
• Evaluate new tools to improve scalability and reliability; maintain docs.
• Create and maintain architecture documentation and data flow diagrams.
• Partner with Snowflake and Informatica on platform upgrades and support.

Skills

Snowflake architecture

SQL proficiency

CI/CD

Cloud platforms

Communication

Cloud platforms

CI/CD

Architecture reviews

Mentoring

Communication

Tools

Informatica IICS

Snowflake

CI/CD tooling

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.

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