Senior Data Engineer

Job Title: Senior Data Engineer

Location:
Markham, ON, Canada (Hybrid – 3 Days Onsite: Mon/Tue/Wed)

Employment Type:
Contract

Experience:
10+ Years

Job Summary

We are seeking a highly experienced
Senior Data Engineer
to design, build, and optimize scalable data pipelines and data architectures. The ideal candidate will have strong expertise in
Informatica PowerCenter, Snowflake
, and hands-on experience with
AWS services
. This role requires deep technical skills, strong analytical thinking, and the ability to collaborate with cross-functional teams to deliver high-quality data solutions.

Key Responsibilities

- Design, develop, and maintain
robust ETL pipelines
using Informatica PowerCenter.
- Build and optimize
data models and data warehouses
in Snowflake.
- Develop and manage
scalable data pipelines
using AWS services such as S3 and Lambda.
- Perform
data transformation, cleansing, and validation
to ensure data quality and integrity.
- Optimize query performance and implement best practices for
data storage and retrieval
.
- Collaborate with business stakeholders, data analysts, and architects to understand requirements and deliver solutions.
- Implement and maintain
data integration and data quality frameworks
.
- Support
CI/CD pipelines
and DevOps practices for data engineering workflows.
- Monitor and troubleshoot data pipelines and production issues.
- Document data processes, workflows, and technical designs.

Required Skills & Experience

- 10+ years of experience in
Data Engineering / ETL Development
.
- Strong hands-on experience with
Informatica PowerCenter
.
- Proven expertise in
Snowflake
(data modeling, performance tuning, query optimization).
- Hands-on experience with
AWS services
, including:
- S3
(data storage and management)
- Lambda
(serverless processing)
- Strong proficiency in
SQL
and scripting languages (
Python preferred
).
- Solid understanding of
data modeling, data integration, and data quality concepts
.
- Experience working in
Agile/Scrum environments
.
- Strong problem-solving and analytical skills.

Preferred / Nice-to-Have Skills

- Experience with additional AWS services such as:
- AWS Glue
- Amazon Redshift
- CloudWatch
- Knowledge of
CI/CD pipelines
and DevOps practices in data engineering.
- Experience with
large-scale data processing and cloud migration projects
.