Senior ETL Developer

Infotek Consulting Inc.; Toronto; On-site; CAD 110,000 - 160,000; Full time

Job summary

Infotek Consulting Inc. seeks an experienced Senior ETL Developer to design, develop, and maintain data pipelines for data warehousing, BI, and analytics. The role requires strong Microsoft Azure, Databricks, AWS, SQL, and ETL development expertise, with a focus on data integration and performance optimization.

The successful candidate will design data models for warehouses, implement scheduling workflows, and collaborate with stakeholders across the SDLC in an onsite Ontario office.

Qualifications

• Experience designing ETL pipelines for data warehousing and analytics.
• Strong Azure expertise including Azure Data Factory and Azure SQL Database.
• Hands-on Databricks and AWS tech (Aurora, RDS, Glue, OpenSearch).
• Proven ability to implement ETL scheduling and dependencies.
• Strong SQL development and data modeling for data warehouses.

Responsibilities

• Design, develop, and maintain ETL pipelines and data integration.
• Build data warehouse and BI applications with scalable performance.
• Define scheduling, dependencies, and automated processing workflows.
• Collaborate with stakeholders and teams throughout the SDLC.
• Produce technical docs including mappings and data models.

Skills

Azure

Power BI

Databricks

AWS

SQL

ETL development

Data integration

Data modeling

Performance tuning

Git

Requirements gathering

SDLC

Analytical thinking

Communication skills

Tools

Azure Data Factory

Azure SQL Database

Azure Data Lake

Amazon Aurora

OpenSearch

Amazon RDS

Git

PowerShell

Job description

Schedule: Monday to Friday, 7.25 hours per day

Job Description

We are seeking an experienced Senior ETL Developer to design, develop, and maintain data pipelines and backend applications supporting data warehousing, business intelligence, and analytics solutions. The ideal candidate will have strong expertise in Microsoft Azure, Databricks, AWS, SQL, and ETL development, along with experience in data integration, data modeling, and performance optimization.

Key Responsibilities

• Design, develop, and maintain ETL pipelines for extracting, transforming, loading, and integrating data from various structured and semi-structured sources.
• Develop and optimize data pipelines using Azure Data Factory, Databricks, Azure SQL Database, Azure Data Lake, and AWS services.
• Build and maintain data warehouse and business intelligence applications, ensuring scalability, performance, and data quality.
• Develop and maintain ETL scheduling, dependencies, and automated data processing workflows.
• Perform data cleansing, validation, troubleshooting, and performance tuning.
• Write complex SQL queries and manage database operations and administration.
• Design data models for data warehouses and data marts.
• Translate technical specifications and business requirements into tested, reliable applications.
• Conduct unit testing, debugging, quality assurance, and post-implementation support.
• Maintain technical documentation, including source-to-target mappings, data models, architecture diagrams, and detailed design documents.
• Collaborate with business stakeholders, technical teams, and subject matter experts throughout the software development lifecycle.
• Follow coding standards, source control practices, and established development methodologies.

Mandatory Qualifications

• Strong experience with Microsoft Azure technologies, including:
• Power BI
• Hands-on experience with the Databricks platform.
• Experience with AWS technologies, including Amazon Aurora, Amazon Relational Database Service (RDS), AWS Glue, and OpenSearch.
• Proven experience developing ETL processes for initial and recurring data loads across multiple data repositories.
• Experience implementing and maintaining ETL scheduling and dependency logic.
• Strong knowledge of data integration, data cleansing, and data analytics.
• Experience with data modeling and design principles for data warehouses and data marts.
• Strong SQL development skills, including complex queries and performance tuning.
• Experience with database management and administration.
• Experience using Git and source control strategies.
• Ability to gather, document, and validate business and technical requirements.
• Experience across the software development lifecycle, including development, testing, quality assurance, and delivery.
• Strong analytical, troubleshooting, problem-solving, and communication skills.

Nice-to-Have Qualifications

• Experience designing Power BI dashboards, KPI reports, and scheduled or ad hoc reports.
• Experience with C#, APIs, serverless functions, or similar application development.
• Experience with PowerShell and other scripting languages.
• Knowledge of accessibility standards, including the Accessibility for Ontarians with Disabilities Act (AODA).
• Experience with application deployment, technical documentation, and post-implementation support.
• Knowledge of information management principles, policies, and best practices.

Work Arrangement

This is an onsite contract opportunity requiring attendance at the designated Ontario office five days per week, Monday to Friday, during standard business hours.

Note: We use AI tools to: obtain basic information, detect plagiarism, false employment history or references, categorize your skills, and do an initial match with job posting.