Software Developer - ETL - Senior Job at Zortech Solutions, Ontario, CA

ZGZYbHlJWmRCT0Z6VStKU3lHTURKK1ZqNVE9PQ==
  • Zortech Solutions
  • Ontario, CA

Job Description

Role: Software Developer - ETL - Senior

Location: Toronto, ON (Hybrid- 3 days in office)

Duration: Long Term Contract

CRJMC Required

Must haves:

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

Skills

Experience and Skill Set Requirements

Evaluation Table

ETL Development-Data Integration 40%

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

o Self-Hosted Integration Runtime

o Data movement, ETL pipelines

o Performance tuning on large data volumes

o Complex data transformations

o ADF Debugger to validate data transformation.

o Azure Roles

  • Experience with Informatica, including:

o Workflow Manager

o Repository Manager

o Designer

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

Azure Technologies 40%

  • Experience with CI/CD (DevOps) pipelines and concepts, including:

o Azure Resource Management

o GitHub Repo

o Source code version control

o Branching, pull requests, build, release, multiple parallel development repositories merge.

  • Experience with Azure DevOps, including:

o Azure Boards

o Azure Test Plans

o Azure Pipelines

o Azure Repos

o Azure Artefacts

Oracle PL/SQL Development 10%

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

Database Technologies 10%

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

o Performance tuning on large data volume.

"L!-CEIPAL"

Job Tags

Contract work,

Similar Jobs

Arise CareStaff

RN - Registered Nurse - Labor and Delivery - Travel - Napa, CA Job at Arise CareStaff

 ...hiring Intensive Care Unit (ICU) Registered Nurse (RN) to work for our client hospital in...  ...Duration: 13 weeks Employment Type: Travel Computer Charting: Epic...  ...AWHONN Advanced, NRP Minimum of 2 years Labor and DeliveryRegistered Nurse (RN) experience within... 

Lafrance Hospitality

Overnight Hotel Night Auditor - Fairfield Inn, Plymouth, NH Job at Lafrance Hospitality

 ...-Time Hotel Night Auditor . As a Night Auditor, you will play a vital role in the smooth operation of our hotel during the overnight hours . You will be responsible for working the front desk and performing daily closing procedures, including some accounting functions... 

AECOM

Civil / Structural Engineer Job at AECOM

 ...become part of a global team of over 50,000 planners, designers, engineers, scientists, digital innovators, program and construction...  ...AECOM has a position available for an mid-career Civil/Structural Engineer to support our growing Energy Business Line. This position... 

AdvisaCare

Per Diem MSW Social Worker Job at AdvisaCare

 ...day! AdvisaCare Home Health and Hospice is looking for a part time/per diem , compassionate MSW (Masters of Social Work) to join...  ...and reliable transportation Benefits ~401K Retirement Plan ~ Medical Benefits Available ~ Ability to earn PTO... 

Top Candidate Search Group

Specialty Pharmaceutical Sales Representative Job at Top Candidate Search Group

 ...Title: Specialty Pharmaceutical Sales Representative Territory : Central NJ -Princeton, Trenton, Red Bank areas & right over into some of Eastern...  ...Degree ~1-3 Years of Professional Outside Sales Experience ~ Valid Drivers License ~ Excellent Oral Communication...