Sr. Software Developer - ETLmicro1 • Toronto, ON, CA

Sr. Software Developer - ETL

micro1 • Toronto, ON, CA

30+ days ago

Job type

Full-time

Job description

Overview

Job Description : RQ09622 - Sr. Software Developer - ETL. Downtown, Toronto (St. Clair W). Hybrid - Candidate MUST work 3 days onsite and 2 days remote. Starting October 20, resources are expected to come into the office 4 days per week. Starting January 5, resources are expected to come into the office 5 days per week. This is subject to change based on manager discretion. Contract 6 months, possible extension.

Responsibilities

Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
Translate technical systems specifications into working, tested applications, including developing detailed programming specifications, writing and / or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
Resolve and troubleshoot technical problems during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

Must-Haves

Design, build, automate and optimize complex data ETL / ELT processes using PL / SQL and equivalent.

Cloud technologies (Azure, Google, AWS).

Advanced skills and hands-on experience with Azure SQL Server and Azure Data Factory.

PL / SQL for data extraction, transformation, and loading; initial setup and other ETL experience management and support (troubleshooting, performance tuning, failover and recovery).

Working knowledge of issue tracking system JIRA, Azure DevOps.

Nice-To-Have

Public Sector experience.

FULL RESUME EVALUATION CRITERIA

Technical Skills – 40%

5+ years of experience with data warehousing design and development (extraction, transformation, loading) into star / snowflake schemas.

Design, build, automate and optimize complex data ETL / ELT processes using PL / SQL and equivalent.

Writing complex procedures / pkg / views / scripts for data denormalization, extraction, cleansing, transformation, and loading.

Creating data assets (denormalized) from highly normalized Oracle databases and loading into other DBMS (Microsoft SQL Server, PostgreSQL, etc.).

Relational databases, data modelling (relational & dimensional), advanced SQL, query optimization, data replication, administration.

Advanced SQL skills (PL / SQL, T-SQL), scripting languages (Python, Unix shell).

Cloud technologies (Azure, Google, AWS); Azure SQL Server and Azure Data Factory; creating Data Factory pipelines for copy activity and custom Azure development.

PL / SQL for data extraction, transformation, loading; initial setup and other ETL experience management and support (troubleshooting, performance tuning, failover and recovery).

ElasticSearch for search / reporting, performance tuning and optimization.

JIRA, Azure DevOps; GitHub for version control and data model changes.

Oracle tools and data warehousing topics (OEM, Data Guard, Exadata, etc.).

Data migration and integration across different platforms; recovery and refresh production and Dev / UAT / Test using RMAN to SAN storage.

Core Skills – 30%

Technical analysis, program code, detailed programming and reports specifications, program design, writing and unit tests.

Software in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways.

Developing and maintaining system design models, technical documentation and specifications.

Technical evaluation and assessment of options for technical design issues, application configuration, and integration capabilities.

Business intelligence and data analytics, data warehouse design, relational data modeling development and support.

Contributing to design / development project plans, work breakdown, and resource estimates.

Translating business requirements into application design with IT needs.

Working with technical systems specifications and translating them into working, tested applications for large, complex, mission-critical apps.

General Skills – 25%

Exceptional analytical, problem solving and decision-making skills; strong interpersonal, verbal and written communication.

Proven troubleshooting and critical thinking experience; strong listening skills to facilitate issue resolution.

Effective consulting skills to engage with stakeholders and build strong working relationships.

Excellent customer service skills, tact and diplomacy to manage client needs effectively.

Motivated, flexible, detail-oriented and creative team player with perseverance, organization and multi-tasking abilities; proven track record for meeting deadlines.

#J-18808-Ljbffr

Create a job alert for this search

Sr Software Developer • Toronto, ON, CA

Similar jobs

ETL TESTER

Pyxidia Techlab LLP • Toronto, ON, Canada

Full-time

We are seeking a skilled ETL Tester with substantial hands-on experience in advanced SQL and Python.This role is open to candidates with either a Quality Assurance (QA) or Developer background, pro...Show more

Last updated: 20 days ago • Promoted

Staff SRE : Accelerate Developer Velocity & Reliability

ContactMonkey • Toronto

Full-time

A leading communication technology firm in Toronto is seeking a Staff Site Reliability Engineer to enhance platform stability and developer experience. You will leverage your experience in cloud inf...Show more

Last updated: 11 days ago • Promoted

Senior Software Engineer II

Tripledot Studios Limited • Toronto C6A, ON, Canada

Remote

Full-time +1

Tripledot is one of the largest independent mobile games companies in the world.We are a multi‑award‑winning organisation, with a global 2,500+ strong team across 12 studios.Our expanded portfolio ...Show more

Last updated: 4 days ago • Promoted

Project Manager – Intelligent Integrated Systems

Recruitment By Design • Greater Toronto Area, Canada

Full-time +1

Project Manager – Intelligent Integrated Systems.Our client, an award-winning Canadian multidisciplinary consulting firm, is seeking a Project Manager – Intelligent Integrated Systems for their Tor...Show more

Last updated: 10 days ago • Promoted

Senior Software Engineer II, Smart Trailer & Connected Equipment

Samsara • Toronto C6A, ON, Canada

Remote

Full-time

Samsara (NYSE : IOT) is the pioneer of the Connected Operations™ Cloud, which is a platform that enables organizations that depend on physical operations to harness Internet of Things (IoT) data to ...Show more

Last updated: 30+ days ago • Promoted

Senior Software Engineer

Saint Laurent Consulting • toronto, on, ca

Full-time

Saint Laurent Consulting - Hiring on behalf of our client.Location & Work Authorization (required).Have Canadian Citizenship or Permanent Residency. Our client is on a mission to revolutionize derma...Show more

Last updated: 30+ days ago • Promoted

Senior Analyst

Vaco by Highspring • Markham, ON, CA

Temporary

Our client is sourcing a Senior Analyst for a 6-month contract.Responsible for month-end, quarter-end, and annual close process in accordance with company requirements. Responsible for expense reimb...Show more

Last updated: 7 days ago • Promoted

ETL & Functional Tester ( Canada Only)

Divine Match Talent • Toronto, ON, Canada

Full-time

Our client is a leading provider of innovative healthcare technology solutions focused on organ transplantation and allocation. They deliver powerful, scalable platforms that support national-level ...Show more

Last updated: 30+ days ago • Promoted

Senior Software Engineer

Sitetracker • Toronto C6A, ON, Canada

Full-time

This is a key role for an engineer passionate about delivering high-quality and efficient software solutions.We're looking for a seasoned problem‑solver—not just a Salesforce developer—who can quic...Show more

Last updated: 30+ days ago • Promoted

Software Developer III

Orthofix Holdings, Inc. • Toronto C6A, ON, Canada

Full-time

Software Developer III page is loaded## Software Developer IIIlocations : Torontotime type : Full timeposted on : Posted Todayjob requisition id : OFX25550Guided by our organizational values – ...Show more

Last updated: 30+ days ago • Promoted

ETL Informatica Developer

Cognizant • Toronto

Full-time

Get AI-powered advice on this job and more exclusive features.We Are Cognizant Artificial Intelligence.Digital technologies, including analytics and AI, give companies a once-in-a-generation opport...Show more

Last updated: 11 days ago • Promoted

Senior Software Engineer - Saint Laurent Consulting

Saint Laurent Consulting • toronto, on, ca

Full-time

Last updated: 30+ days ago • Promoted

Sr Software Engineer

hireVouch • Toronto, ON, Canada

Full-time

We’re looking for a software engineer to join us in building the future of business banking and cash management.You’ll work closely with other engineers, product, and design to design, ...Show more

Last updated: 30+ days ago • Promoted

Software Engineer III - Store Browse

Rakuten Kobo Inc. • Toronto

Full-time

Our employees rank us highly in terms of commitment to work / life balance.We realize that for our people to be innovative, creative and passionate they need to feel valued and supported.We believe i...Show more

Last updated: 12 days ago • Promoted

Senior ETL SDET

J&M Group • Toronto

Full-time

Be among the first 25 applicants.Good knowledge of Testing Life Cycle, SDLC and Defect Management processes for application support and development. Good knowledge with QE Processes, Methodologies a...Show more

Last updated: 15 days ago • Promoted

ETL Tech Lead

Hays • Toronto, ON, Canada

Full-time

You’ll be joining a leading organization committed to delivering innovative solutions that support strategic initiatives across the health information sector. The company values collaboration, excel...Show more

Last updated: 17 days ago • Promoted

Engineering Sr. Software Engineer, Infra Palo Alto, California

getjerry.com • Toronto C6A, ON, Canada

Remote

Full-time

We’re building the first AI-powered AllCar™ super app to make car ownership affordable, seamless, and even magical.From insurance to repairs to road safety, we’re connecting the entire car ownershi...Show more

Last updated: 30+ days ago • Promoted

RQ09562 - Software Developer - Senior

freelance.ca • Toronto, Canada

Full-time

Probable after the initial mandate.Siebel technical configuration / design / development / integration.Siebel integration with Adobe AEM , J2EE and etc. Experience in OBIEE and PowerBI report develop...Show more

Last updated: 30+ days ago • Promoted