Position Overview

Type: Contract

Skills: Strong focus on ETL, SQL, SSIS, Tidal, Airflow

JD: This position is for an Integration engineer with a background in SSIS, Python, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst expertise.

Role

Integration Engineer

Location

Ottawa / Toronto (Hybrid)

Major Responsibilities

• Provide Level 2/3 support of existing ETL processes.
• Monitor and troubleshoot Scheduled ETL jobs, identify and resolve issues or bottlenecks.
• Proficient in developing ETL processes in SSIS, Python and SQL (SQL Server / Oracle)
• Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process.
• Build and optimize data pipelines for efficient data ingestion, transformation and loading from various sourc...