Senior ETL ConsultantMaarut Inc • Toronto, ON, CA

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 Consultant • Toronto, ON, CA

Similar jobs

Senior ETL & Data Warehouse Consultant

Virtusa • Toronto C6A, ON, Canada

Full-time

A leading technology consulting firm is seeking a Senior Consultant specializing in ETL development.The role involves designing and supporting applications in Line of Business strategies, with a fo...Show more

Last updated: 9 days ago • Promoted

Senior Consultant, Business Optimization

Toronto Hydro Corporation • Toronto C6A, ON, Canada

Remote

Full-time

Target Variable Performance Pay : 10%.The salary range shown above reflects the expected compensation for this position.The final salary offered will be determined based on a holistic assessment of ...Show more

Last updated: 8 days ago • Promoted

ERP Program Data Migration Lead x2 (ID : 52809)

Vaco by Highspring • Stouffville, ON, CA

Full-time

Our client is a leading Canadian energy organization with a strong presence across Ontario.They operate critical infrastructure that supports millions of customers and drives economic growth.Our cl...Show more

Last updated: 11 days ago • Promoted

Senior ETL Engineer

Women Thrive Magazine • Toronto C6A, ON, Canada

Full-time

Senior ETL EngineerScotiabankTorontoRequisition ID : 238183 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Team • • • We are the CRM, Sales...Show more

Last updated: 5 days ago • Promoted

Senior ETL Engineer

Thebusinessyear • Toronto C6A, ON, Canada

Full-time

Last updated: 10 days ago • Promoted

Senior Consultant

Isaac Operations • Toronto, ON, Canada

Full-time

While technically we’re an operational consultancy, we don’t like to call ourselves consultants.We’re a collection of engineers, innovators and creators who work with companies across industries to...Show more

Last updated: 30+ days ago • Promoted

Senior Solutions Consultant

ExaCare AI • Toronto, ON, Canada

Full-time

We are a trailblazing health tech company on a mission to revolutionize the nursing home & post acute space.Our innovative AI software is transforming the admissions process and care delivery in th...Show more

Last updated: 24 days ago • Promoted

Senior Manager, Digital Asset Business - Risk Consulting

KPMG in the Cayman Islands • Greater Toronto Area, Canada

Full-time

Please note : this is an on-site role and can be based in The Cayman Islands, Bermuda, The Bahamas or the Crown Dependencies and relocation is required. At KPMG our goal is to be the Clear Choice for...Show more

Last updated: 3 days ago • Promoted

Senior Workday Integrations Lead

Kognitiv Inc. • Toronto C6A, ON, Canada

Full-time

A leading technology firm in Toronto is seeking a Workday Integrations Principal Consultant to provide expert guidance on high-impact projects and lead complex integrations.The ideal candidate will...Show more

Last updated: 10 days ago • Promoted

NEW - PRINCIPAL CONSULTANT / IBM Planning Analytics / TM1 Practice Leader

Private Company • Toronto C6A, ON, Canada

Full-time

NEW - PRINCIPAL CONSULTANT / IBM Planning Analytics / TM1 Practice Leader.To be eligible to apply for this role, you must have SOLID TM1 Consulting experience at a senior level.My client has identi...Show more

Last updated: 30+ days ago • Promoted

Sr. Solutions Director - Toronto, Ontario

Optiv Security • Toronto C6A, ON, Canada

Full-time

Solutions Director - Toronto, Ontario page is loaded## Sr.Solutions Director - Toronto, Ontariolocations : Toronto, Ontariotime type : Full timeposted on : Posted Yesterdayjob requisition id : ...Show more

Last updated: 17 days ago • Promoted

Senior ETL Engineer : Talend & Salesforce Integrations

Swagher • Toronto, Canada

Full-time

A leading bank in the Americas seeks a Senior ETL Engineer in Toronto, responsible for designing and developing ETL solutions for complex initiatives. The ideal candidate has 10+ years of experience...Show more

Last updated: 7 days ago • Promoted

Senior Consultant

Medium • Toronto, ON, Canada

Full-time

Electric Mind, formerly Intelliware, is a business and technology consulting leader in providing innovative, practical solutions driven by engineering excellence. Join our adept team of Business and...Show more

Last updated: 30+ days ago • Promoted

Senior Consultant, Business Controls - Simplii Financial

Simplii Financial • Toronto C6A, ON, Canada

Full-time

Be among the first 25 applicants.We’re building a relationship‑oriented bank for the modern world.We need talented, passionate professionals who are dedicated to doing what’s right for our clients....Show more

Last updated: 19 days ago • Promoted

Senior Consultant, FSI (Toronto)

Deloitte Canada • Toronto, ON, Canada

Full-time

At Deloitte, our Purpose is to make an impact that matters.We exist to inspire and help our people, organizations, communities, and countries to thrive by building a better future.Our work underpin...Show more

Last updated: 30+ days ago • Promoted

Senior Solutions Consultant

Achievers • Toronto C6A, ON, Canada

Full-time +1

Achievers offers more than just a thank you program.Our employee recognition and rewards software inspires employees to recognize everyone, every day, everywhere. With nearly 4 million global users,...Show more

Last updated: 8 days ago • Promoted

Senior Analyst, Corporate Strategy

T & T Supermarket • Markham, ON, Canada

Full-time

Since then, it has expanded rapidly and is now Canada’s largest Asian supermarket chain with 36 stores across the country : 14 in BC, 7 in Alberta, 13 in Ontario, and 2 in Quebec.The Company’s conti...Show more

Last updated: 24 days ago • Promoted

Senior Solutions Consultant

Achievers Corp. • Toronto, ON, Canada

Full-time

Achievers offers more than just a thank you program.Our employee recognition and rewards software inspires employees to recognize everyone, every day, everywhere. Join our team of A-players who brin...Show more

Last updated: 30+ days ago • Promoted