Integration Engineer

Overview

On Site
Full Time
Contract - W2
Contract - Independent

Skills

SQL
Python
SSIS
Integration
Data
Warehousing

Job Details

The Role:

Our Client is seeking a Integration Engineer to join our team in Mississauga, ON (Need Onsite day 1, hybrid 3 days from office).

Job Description:

We are seeking 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.

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 sources while ensuring data quality and integrity.
  • Working with structured, semi structured and unstructured data.
  • Implement best practices for data management, security, and governance.
  • Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.

Requirements:

  • 5+ years SSIS development experience
  • 5+ years Python coding experience.
  • 5+ years SQL Server based development of large datasets

Preferred, but not required:

  • Experience in Financial Services industry
  • Experience with Enterprise Schedulers / Orchestration platforms such as Tidal, Airflow.
  • Experience in any cloud data warehouse like Snowflake.
  • Experience in Data warehousing - OLTP, Dimensions, Facts, and Data modeling.
  • Experience with Cloud based data architectures, messaging, and analytics.
  • Experience with developing and deploying ETL pipelines using Databricks Pyspark.
  • Minimally a BA/BS degree within an engineering and/or computer science discipline
  • Master's degree preferred.

Please ensure that you use the below template forma when submitting profiles. Only the following details along with the resume should be shared:

Do not submit any personal documents along with the profile.

Submission Template

Full Name

Contact Number

Email Address

Current Location

Work Authorization

Linked in
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.