About the Position

We are seeking an experienced ETL Consultant (Hybrid) to join our team in Halifax, NS or Toronto, Canada. This role involves architecting, designing, and overseeing the implementation of end-to-end data pipelines using Informatica IICS and Snowflake.

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.

Requirements

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.

Nice to Have

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 through our various wellbeing programs.

What You Need 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 make 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 $90,000 – $140,000 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.

Things to Know Before You Apply

Work authorization: Cognizant will only consider applicants for this position who are legally authorized to work in Canada without requiring employer sponsorship, now or at any time in the future.
Accommodations: 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.
AI in hiring: We use artificial intelligence (AI) tools to help us screen and assess applications more efficiently. Our team performs additional human review and ultimately decides who moves forward in our hiring process.
Open position: Unless otherwise stated, this job posting is for an open position on our team.
Language proficiency: 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.
Inclusion: 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.

About Cognizant

Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, bridging the gap 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, drive tangible outcomes, and keep global enterprises ahead in a fast-changing world. See how at cognizant.ai or @cognizant.

Benefits That Help You Thrive and Grow

Our benefits program is built with you in mind-so you can enjoy a fulfilling, balanced, and healthy life.

Financial Wellbeing

We regularly review market data to ensure compensation reflects the value you bring. Your benefits extend beyond pay and may include financial education, a pension plan with matching contributions, etc.

Physical and Mental Health

We empower you to prioritize your wellbeing through paid time off, flexible working where possible, healthcare plans, counselling, our Mental Health Allyship program, and more.

Your Career, Your Way

With 350,000+ roles at Cognizant, you’ll have opportunities to explore new technologies, industries, and locations-and build the skills you need to grow your career.

Real-World Impact

Think about the biggest brands you rely on. Chances are, they rely on us to help strengthen their business. Here, you’ll turn bold ideas into solutions that improve lives everywhere.

Your Path to Cognizant

Here’s what you can expect from our hiring process. Please keep in mind that it may vary by role and location. Explore our FAQs to learn more.

Step 1: Apply to the Right Opportunity

Find an open role that matches your skills and career goals and show us why you’re the person for the job. Don’t see the right opportunity? Consider joining our Talent Community.

Step 2: Connect with Your Recruiter

If one of our recruiters sees a fit, they’ll set up a short intro call to learn more about you and how your experiences and skills match the role.

Step 3: Show Off Your Skills

If you and our team would like to continue the process, you’ll interview with our hiring team. Some roles may also require technical assessments and/or client interviews.

Step 4: Decision Time

Our team will then review each candidate’s potential to succeed in the role. This step may take some time because we want to find the right fit for both you and us-but you can count on us to keep you updated.

Cognizant is great for those wanting to make the world a better place, as we create solutions with top technology partners to address complex problems for our clients.

Brigitte Roy

Director of Strategy Alliances

I’m supported by motivational leaders who empower me to grow in my career through learning programs, industry conferences, and internal job moves. I’m proud of the career progression I’m making here.

Rahul Sathe

Principal Product Architect – Insurance

The moment I joined Cognizant, I felt like I belonged. I was heard and empowered to challenge ideas-and I still am to this day.

Dr. Amita Oppal Gill

Service Line Sales Manager

Cognizant has one of the best learning ecosystems you can ask for. From sponsored certifications to training platforms to mentorship, we have all that we need to grow.

Debashish Mishra

SAP MM Developer

Haven't Yet Found the Right Opportunity?

Get the latest updates on job opportunities, recruitment events, and company news-tailored just for you!

Be in the know

ETL Consultant (Hybrid)

Job description