If interested, please share your Resume at [email protected] / [email protected]

Position Title: Senior Software Developer – ETL

Location: 222 Jarvis Street, Toronto, Ontario
(Hybrid work environment: 3 days onsite, 2 days remote)

Start Date: July 21, 2025

End Date: March 31, 2026 (with potential extension)

Job Description:

We are seeking a Senior Software Developer - ETL to join our dynamic Data Management team. The candidate will work on cross-functional data initiatives with business clients and contribute to the development and support of ETL solutions using Microsoft Azure and AWS platforms.

Responsibilities:

• Collaborate with business teams to understand data requirements and impact on existing systems.

• Connect various source and target systems (Oracle, Microsoft SQL Server, Amazon Aurora, APIs, flat files, etc.) to perform ETL activities.

• Develop ETL solutions using Azure Data Factory and AWS technologies such as Glue, Kinesis Data Firehose, SageMaker, Data Wrangler, and OpenSearch Service.

• Create ETL mappings, stored procedures, and complex SQL queries.

• Tune and optimize SQL code for ETL processes and reporting databases.

• Perform unit tests ensuring data accuracy, integrity, and performance.

• Participate in meetings, incident resolution, enhancement requests, and support tickets.

• Create and maintain technical documentation including data models and architecture artifacts.

Required Skills and Qualifications:

Core Technical Skills:

• Strong experience with Microsoft technologies: Azure Data Factory, Azure SQL Database, Azure Data Lake, Power BI.

• Experience with AWS technologies: Amazon Aurora, AWS RDS, Glue, OpenSearch, etc.

• Expertise in developing ETL programs for various data repositories (structured and semi-structured files, relational and multi-dimensional data stores).

• Strong skills in database management, SQL query optimization, and performance tuning.

• Experience in building and maintaining ETL scheduling and dependency logic.

• Data integration, cleansing, analytics, and modeling experience.

• Proficiency with Git and knowledge of source control strategies.

Other Skills:

• Strong communication skills: verbal and written.

• Experience in documenting and validating business requirements.

• Familiarity with software development lifecycle (Development, Testing, QA, Delivery).

Nice-to-Have Skills:

• Knowledge of Accessibility for Ontarians with Disabilities Act (AODA) standards.

• Experience designing dashboards and KPIs.

• Programming experience with C#, PowerShell, or other scripting languages.

If interested, please share your Resume at [email protected] / [email protected]