ETL Developer Job at Signature IT World Inc, Canada

dTA2MXBuZkpoV204cksrR1ZJeklGT0ZCeXc9PQ==
  • Signature IT World Inc
  • Canada

Job Description

Job Description

Job Description :

Role: ETL Developer

Location: Kantana, Ottawa

Job Type – Contract

Key Job Functions:

  • 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.

Required Skills:

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

Additional Skills:

  • 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.

Job Tags

Contract work,

Similar Jobs

Lowes

Retail Sales - Part Time Job at Lowes

 ...Job Description Your Impact at Lowe's As a Customer Service Associate, you combine top-notch customer service skills with genuine...  ...challenges. How We Support You Whether you need a part-time position or a place to plant yourself and grow, Lowe's is ready... 

Brilliance.com

Order fulfillment Associate Job at Brilliance.com

 ...JOIN OUR GROWING TEAM AND HELP US DELIVER EXCELLENCE! The E-Commerce Order Fulfillment Associate is responsible for accurately and carefully processing orders, ensuring flawless packaging, and timely shipment to customers. This role requires meticulous attention... 

Open Systems Technologies

ETL Developer (VP) Ab Initio Job at Open Systems Technologies

 ...Key Responsibilities: The candidate will be responsible for building and managing senior and junior ETL developers. Work directly with global application development teams, Operations teams/partners to successfully integrate. Will work with team and manage deliverables... 

Inizio Engage

Pharmaceutical Field Sales Representative Job at Inizio Engage

 ...Inizio Engage is building a nationwide team of field based Pharmaceutical Sales Representatives. This is an excellent entry-level role in the...  ...~ Bachelors Degree ~ Minimum 2 years of relevant experience such as: ~ Pharmaceutical Sales Experience ~... 

Sunshine State Health Plan

Case Manager Job at Sunshine State Health Plan

 ...You could be the one who changes everything for our 28 million members. Centene is transforming the health of our communities, one person at a time. As a diversified, national organization, youll have access to competitive benefits including a fresh perspective on workplace...