ETL Developer (SSIS) - TI241125

emergiTEL Inc.; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A technology consulting firm in Toronto is seeking an experienced ETL Developer to design and implement ETL processes using SSIS. The role requires a strong background in data integration and SQL, along with excellent problem-solving and communication skills. A Bachelor's degree in a relevant field is necessary. This position offers competitive compensation and opportunities for professional growth.

Responsibilities

• Design and implement ETL processes using SSIS.
• Ensure the accuracy and reliability of data pipelines.
• Collaborate with analysts and developers to meet data needs.

Skills

ETL development

SQL Server Integration Services (SSIS)

Complex SQL queries

Data warehousing concepts

Analytical skills

Communication skills

Performance tuning

Collaboration skills

Data quality practices

Education

Bachelor's degree in Computer Science, Information Technology, Data Science or related field

Job description

Job Description:

As an ETL Developer specializing in SSIS (SQL Server Integration Services), you will be responsible for designing, developing, and implementing effective ETL (Extract, Transform, Load) processes to consolidate and integrate data from various sources into our data warehouse.

Your expertise in SSIS will be critical in ensuring the accuracy, reliability, and performance of our data pipelines.

You will work closely with data analysts, business intelligence developers, and other stakeholders to understand data requirements and deliver high-quality data solutions.

Required Skills:

• 4+ years of experience in ETL development and data integration.
• Strong expertise in SQL Server Integration Services (SSIS).
• Proficient in writing complex SQL queries and stored procedures.
• Experience with data warehousing concepts and database design.
• Strong analytical and problem‑solving skills.
• Excellent communication and collaboration skills.
• Experience with performance tuning and optimization of ETL processes.
• Familiarity with other ETL tools (e.g., Informatica, Talend) is a plus.
• Knowledge of data quality and data governance practices.
• Ability to work with diverse stakeholders to gather requirements and translate them into technical specifications.
• Experience with version control and deployment process for SSIS packages.
• Understanding of cloud platforms and services (e.g., AWS, Azure) is an advantage.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, Data Science or a related field.