ETL Developer

Encore Technical Solutions Inc.; Markham; Hybrid; CAD 80,000 - 105,000; Full time

Job summary

A leading IT services company is seeking a Junior to Intermediate ETL Developer for a 6-month contract in Markham. You will design and maintain ETL processes, working with T-SQL and MS SQL Server. Ideal candidates have 2+ years of ETL experience and strong problem-solving skills, ensuring data quality and consistency.

Qualifications

• 2+ years of experience in ETL development.
• Proficiency in T-SQL and MS SQL Server.
• Strong understanding of RDBMS concepts and data modeling.

Responsibilities

• Design, develop, and maintain ETL workflows and data pipelines.
• Write complex T-SQL queries and stored procedures for data transformation.
• Collaborate with business analysts to understand data requirements.

Skills

Problem-solving

Communication

Data Quality

Tools

T-SQL

MS SQL Server

SSIS

Job description

Get AI-powered advice on this job and more exclusive features.

Job Title: Junior to Intermediate ETL Developer

Location: Markham, Ontario (Hybrid – 4 days/week in office)

Contract Duration: 6 Months (July 2025 start date)

Job Description:

We are seeking a motivated Junior to Intermediate ETL Developer to join our client's team on a 6-month contract. The ideal candidate will have strong experience with T-SQL and Microsoft SQL Server, along with a solid understanding of relational database concepts. You will be responsible for developing, maintaining, and optimizing ETL processes to support data integration and reporting needs.

Key Responsibilities:

• Design, develop, and maintain ETL workflows and data pipelines.
• Write complex T-SQL queries, stored procedures, and scripts for data transformation and extraction.
• Work with large datasets and ensure data quality, consistency, and integrity.
• Collaborate with business analysts and data architects to understand data requirements.
• Troubleshoot and resolve data issues and performance bottlenecks.

Qualifications:

• 2+ years of experience in ETL development.
• Proficiency in T-SQL and MS SQL Server.
• Strong understanding of RDBMS concepts and data modeling.
• Experience with SSIS or similar ETL tools is a plus.
• Excellent problem-solving and communication skills.

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Encore Technical Solutions Inc. by 2x

Get notified about new ETL Developer jobs in Markham, Ontario, Canada.

Markham, Ontario, Canada CA$80.00-CA$105.00 1 day ago

ETL Developer with Informatica PowerCenter and Informatica Big Data

Toronto, Ontario, Canada CA$120,000.00-CA$190,000.00 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.