Talent.com
Maarut Inc
Senior ETL ConsultantMaarut Inc • Toronto, ON, CA
Senior ETL Consultant

Senior ETL Consultant

Maarut Inc • Toronto, ON, CA
30+ days ago
Job type
  • Full-time
Job description

4 days ago Be among the first 25 applicants

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

Direct message the job poster from Maarut Inc

Responsibilities

  • Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc.
  • Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards.
  • Design logical and physical data models using Sybase Power Designer.
  • Implement data pipelines using Azure Data Factory (ADF), stored procedure, and Informatica PowerCenter performing extraction, transformation, and loading activities.
  • Implement solutions using Logic App and Function App.
  • Generate structured JSON file using ADF/ SQL.
  • Develop Azure CI/CD pipeline to automate ADF release.
  • Develop complex Oracle PL/SQL program to fulfill project requirements.
  • Implement complex data conversion, e.g., binary to character, EBCDIC to UTF.
  • Implement complex data transformation(s) for derived and calculated values.
  • Integrate data sets from diverse source systems.
  • Implement ADF for initial data load and incremental load.
  • Promote ADF and Informatica ETL/ELT through all Ministry environments including Development, Integration Testing, QA, UAT, Production.
  • Resolve and troubleshoot ADF pipeline, stored procedure, and Informatica workflow technical problems.
  • Monitor and analyze incident, provide timely resolution.
  • Collaborate with IT Professionals throughout the Software Development Life Cycle.
  • Document information from diverse business area stakeholders and subject matter experts.
  • Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow.
  • Monitor application functionality and performance on daily basis.
  • Provide effective knowledge transfer to Ministry staff at all stages of this assignment.

Requirements

ETL Development-Data Integration

  • Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.
  • Extensive experience in design, development, and implementation with Azure Data Factory, Databricks, including:
    • Self-Hosted Integration Runtime
    • Performance tuning on large data volumes
    • Complex data transformations
    • ADF Debugger to validate data transformation.
  • Experience with Informatica, including:
    • Workflow Manager
    • Repository Manager
    • Designer
    • Workflow Monitor
  • Experience with developing solutions using Logic App and Function App.
  • Experience in rapid application development (RAD) methodologies.
  • Experience in maintaining and improving existing ETL processes.
  • Experience in investigating data to identify potential issues within ETL pipelines.
  • Experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI.
  • Experience with CI/CD (DevOps) pipelines and concepts, including:
    • Branching, pull requests, build, release, multiple parallel development repositories merge.
  • Experience with Azure DevOps.

Oracle PL/SQL Development

  • Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs.

Database Technologies

  • Experience with Oracle, Microsoft SQL Server database and tools.
  • Experience with relational and hierarchical database technologies.
  • Extensive knowledge of Azure SQL DB and Synapse platforms, including:
    • Performance tuning on large data volume.

Must haves:

  • Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.

Seniority level

Mid-Senior level

Employment type

Contract

Job function

Information Technology

Industries

IT Services and IT Consulting

#J-18808-Ljbffr
Create a job alert for this search

Senior ETL Consultant • Toronto, ON, CA

Similar jobs

Senior ETL Developer - DataStage Focus

Apptoza Inc.Toronto, ON, CA
Full-time

We are on the lookout for a Senior ETL Developer with expertise in DataStage and Talend to lead our ETL initiatives.Enhance enterprise data integration and analytics through your skills.As a Senior... Show more

 • Promoted

Senior Data Solutions Lead - SQL, ETL & Azure

TD BankToronto, ON, CA
Full-time

A leading financial institution is seeking a Senior Data Management Lead in Toronto.This role requires providing technical leadership across diverse data analysis functions, including SQL, ETL, and... Show more

 • Promoted

Senior Consultant for EY Capital Markets

EYToronto, ON, CA
Full-time

Elevate your career as a Senior Consultant at EY, focusing on Capital Markets transformations like regulatory change and digital assets.Work with top financial institutions globally.In this role, y... Show more

 • Promoted

Senior Consultant - PMIS Implementation

Stantecmarkham, on, Canada
Full-time

Drive transformational projects as a Senior Consultant specializing in PMIS Implementation at Stantec.By configuring and rolling out tailored PMIS solutions, you’ll enhance client operations from c... Show more

 • Promoted

Director, Process Excellence and Enablement

Xplore Inc.markham, on, Canada
Full-time

Canada’s fibre, 5G and satellite broadband company for rural living.Xplore is committed to the relentless pursuit of an improved broadband experience for all Canadians.Xplore is building a world‑cl... Show more

 • Promoted

Senior Management Consultant

HDRRichmond Hill, York Region, CA
Full-time

HDR is looking for a Senior Management Consultant to join our Canadian Water Business Group.The selected candidate will manage all aspects of utility management projects, primarily in water and was... Show more

 • Promoted

Senior ETCS Signalling Engineer

AECOMmarkham, on, Canada
Full-time

ACOM is a global infrastructure consulting firm focused on improving infrastructure worldwide.This role is part of the Signals Canada team in Markham.Senior ETCS Engineer – Signals Canada.This newl... Show more

 • Promoted

Senior Data Engineer with Strong ETL Skills

HRbrain Inc.Toronto, ON, CA
Full-time

Become a pivotal Senior Data Engineer focusing on ETL and data transformations.Create and manage data workflows from inception to dashboard implementation using expert skills.This role is suited fo... Show more

 • Promoted

Strategic Consultant for SMBs in Toronto

Change ConnectMarkham, ON, CA
Full-time

Elevate small and medium-sized businesses (SMBs) as a Strategic Consultant in the Greater Toronto Area.This hybrid position blends remote work with vital client interactions.In this role, you will ... Show more

 • Promoted

Senior ETL Engineer (Hybrid) – Azure, Dynamics 365

Rubicon PathToronto, ON, CA
Full-time

A technology consulting firm in Toronto is seeking a Senior Software Developer (ETL) to work on integrating Dynamics 365 with various systems.The ideal candidate will have extensive experience in A... Show more

 • Promoted

Senior IT Consultant Infrastructure and ETL

Source CodeToronto, ON, CA
Full-time

Enhance organizational efficiency as a Senior IT Consultant specializing in infrastructure and ETL in downtown Toronto.This position requires onsite collaboration and technical expertise.We're look... Show more

 • Promoted

Senior Implementation Consultant for PMIS

Stantec Consulting International Ltd.markham, on, Canada
Full-time

Advance your career at Stantec as a Senior PMIS Implementation Consultant, specializing in the successful execution of complex projects.Focus on delivering PMIS solutions across diverse sectors.Thi... Show more

 • Promoted

ETL SDET with EDI experince.

Epsilon Solutions Ltd.Toronto, ON, CA
Full-time

Team Lead Recruitment @ Epsilon Solutions Ltd.EDI (Electronic Data Interchange) experience is a must.Must-Have Skills: ETL Testing, Python, PySpark, AWS S3, Redshift, Kafka, Informatica, Complex SQ... Show more

 • Promoted

Senior PMIS Implementation Consultant

Stantec Consulting International Ltd.Markham, ON, CA
Full-time +1

When you care deeply about the work you do, it’s rewarding to see it through from concept to completion.We partner with clients to provide both program management and construction management to str... Show more

 • Promoted

Senior BI & DW Consultant: Analytics, ETL & Architecture

ROSSToronto
Full-time

A leading analytics firm in Toronto is seeking an experienced programming and analysis consultant to understand client requirements and deliver technical solutions.The ideal candidate must have at ... Show more

 • Promoted

Consultant

huaweicanadaMarkham, ON, CA
Temporary

Huawei Canada has an immediate 12‑month contract opening for a Consultant.The Technology Planning and Cooperation Department promotes strategic innovation across all of Huawei Canada.Working with f... Show more

 • Promoted

Senior Engineer - ETL Data for Autonomous Vehicles

Waabitoronto, on, Canada
Full-time

Lead advancements in self-driving technology with Waabi as a Senior Engineer focused on ETL data pipelines.This key role develops critical data infrastructure for autonomous vehicle mapping solutio... Show more

 • Promoted

Lead Rail Systems Integration Expert

WSP in Canadamarkham, on, Canada
Full-time

Shape the future of transit systems as a Lead Rail Systems Integration Expert.Join a vital project to integrate urban rail systems with operational infrastructure.In this senior role, you will spea... Show more