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

Senior ETL Consultant

Maarut Inc • Toronto, Ontario, 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, Ontario, CA

Similar jobs

Senior BI & DW Consultant: Analytics, ETL & Architecture

ROSSToronto, ON, CA
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

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 Overhead Transmission Lines Engineer

CIMA+markham, york region, Canada
Full-time +1

Compensation: CAD 134,080 - CAD 184,000 - yearly.Welcome to a place where people are at the heart of everything we do.Welcome to people with an inspiring vision and who seek stimulating challenges.... 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 Consultant

VirtusaToronto, ON, CA
Full-time

Job Description - Senior Consultant (CREQ257953).Senior Consultant - ( CREQ257953 ).Kinetica, Python, sql, Rest API, Design, develop, and maintain highly efficient and scalable data models within t... 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

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 ETL Consultant

Maarut IncToronto, ON, CA
Full-time

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.Participate in the review of project, work request and m... 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

Consultant/Senior Consultant

EnterpriseToronto, ON, CA
Full-time

Enterprise Canada is looking for a Consultant or Senior Consultant to join our Ontario Government Relations team in.This is an opportunity to work on high-profile public affairs files and governmen... 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

 • Promoted

Datastage ETL Expert - Toronto, Hybrid

United States Digital Space LLCToronto, ON, CA
Full-time

Unlock new opportunities as a Datastage ETL Expert in Toronto.Enjoy a hybrid work model while utilizing your extensive ETL knowledge and SQL expertise to optimize our data processes.We are currentl... Show more