RQ10127 ETL Software Developer

EmergiTEL

Not Interested
Bookmark
Report This Job

profile Job Location:

Toronto - Canada

profile Monthly Salary: Not Disclosed
Posted on: 23 hours ago
Vacancies: 1 Vacancy

Job Summary

Job Title: Software Developer ETL (Senior)

Work Arrangement

Onsite (5 days per week)

Role Summary

The Senior ETL Software Developer is responsible for designing developing and maintaining scalable data pipelines and analytics solutions across cloud-based and enterprise data platforms. The role focuses on ETL development data integration data modeling and performance optimization to support data warehouse data lake and business intelligence solutions.

Key Responsibilities

  • Design develop and maintain ETL pipelines for structured and semi-structured data sources

  • Perform data extraction transformation and loading for both initial and incremental loads

  • Translate technical and business requirements into working tested ETL solutions

  • Develop detailed programming specifications and write high-quality reusable code

  • Build and maintain scheduling and dependency logic for ETL workflows

  • Conduct unit testing debugging and performance tuning of ETL processes

  • Investigate data issues identify root causes and propose corrective solutions

  • Ensure data architecture is scalable maintainable and aligned with best practices

  • Create and maintain technical documentation (ETL mappings data models architecture diagrams)

  • Collaborate with business and technical stakeholders throughout the SDLC

  • Provide post-implementation support including troubleshooting and enhancements

Mandatory Technical Skills

  • Strong experience with Microsoft Azure data technologies including:

    • Azure Data Factory

    • Azure SQL Database

    • Azure Data Lake

    • Power BI

  • Hands-on experience with the Databricks platform

  • Experience with AWS data services including:

    • Amazon Aurora

    • Amazon Relational Database Service

    • AWS Glue

    • OpenSearch

  • Strong experience developing ETL solutions across multiple data repositories

  • Expertise in data integration data cleansing and data analytics

  • Strong knowledge of data modeling and design principles for data marts and data warehouses

  • Experience designing modern analytics architectures (data warehouses data lakes lakehouses)

  • Advanced SQL skills including complex queries and performance tuning

  • Experience with database management and administration

  • Experience using Git and source control strategies

  • Strong understanding of the full Software Development Life Cycle (SDLC)

General Development & Analysis Skills

  • Experience in application design coding testing debugging and documentation

  • Familiarity with structured development methodologies

  • Ability to elicit document and validate business requirements

  • Experience collaborating with cross-functional IT and business teams

  • Strong analytical problem-solving and decision-making skills

  • Proven ability to meet deadlines and work independently or as part of a team

Nice-to-Have Skills

  • Experience designing dashboards and reports (scheduled and ad-hoc) highlighting KPIs and trends

  • Programming experience with C# APIs or cloud-based functions

  • Scripting experience using PowerShell or other scripting languages

  • Experience with middleware gateways or integration platforms

  • Knowledge of AODA and accessibility standards

  • Experience conducting design walkthroughs and providing user/system documentation


Required Experience:

IC

Job Title: Software Developer ETL (Senior)Work ArrangementOnsite (5 days per week)Role SummaryThe Senior ETL Software Developer is responsible for designing developing and maintaining scalable data pipelines and analytics solutions across cloud-based and enterprise data platforms. The role focuses ...
View more view more

Key Skills

  • SQL
  • Pentaho
  • PL/SQL
  • Microsoft SQL Server
  • SSIS
  • Informatica
  • Shell Scripting
  • T Sql
  • Teradata
  • Data Modeling
  • Data Warehouse
  • Oracle

About Company

Company Logo

Learn more

View Profile View Profile