Senior Informatica ETL & Data Warehouse Engineer

Cognizant; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading technology company in Toronto is seeking a highly skilled Sr. Developer with over 8 years of experience in data integration and ETL processes. The ideal candidate will excel in using tools like Informatica Powercenter, PL/SQL, and AWS. This role emphasizes enhancing data warehousing solutions and building scalable data pipelines in Databricks, supporting crucial business objectives. Strong data analysis skills and excellent communication are essential. The position operates in a hybrid model.

Qualifications

• 8+ years of experience in data integration and ETL processes.
• Proficient in developing and supporting Informatica mappings in production.
• Strong skills in AWS resource provisioning.
• Experience building scalable data pipelines in Databricks.

Responsibilities

• Develop and support Informatica mappings and workflows.
• Proficient in Teradata FastLoad and MultiLoad techniques.
• Build scalable data pipelines in Databricks.
• Implement Kafka streaming data consumption using Confluent tools.

Skills

Data integration

ETL processes

Informatica Powercenter

PL/SQL

AWS resources

Data pipelines in Databricks

Kafka streaming

Python scripting

Data warehousing concepts

Data Quality tools

Communication skills

Tools

Informatica

AWS

Teradata

Databricks

GitHub

Kubernetes

Job description

A leading technology company in Toronto is seeking a highly skilled Sr. Developer with over 8 years of experience in data integration and ETL processes. The ideal candidate will excel in using tools like Informatica Powercenter, PL/SQL, and AWS. This role emphasizes enhancing data warehousing solutions and building scalable data pipelines in Databricks, supporting crucial business objectives. Strong data analysis skills and excellent communication are essential. The position operates in a hybrid model.