Software Developer ETL 9197-3010

Dheya; Toronto; Hybrid; CAD 70,000 - 100,000; Full time

Job summary

A leading company in Toronto is seeking a Data Management Developer for a hybrid role. You will work on data initiatives, develop ETL processes using AWS tools, and ensure compliance with data standards. The ideal candidate has strong AWS skills, experience with database management, and excellent communication abilities.

Qualifications

• Experience with data extraction, transformation, and load programs.
• Strong background in AWS ETL processes and database management.
• Ability to create detailed technical documentation.

Responsibilities

• Develop ETL processes and maintain data integrity.
• Support cross-functional data initiatives with various business clients.
• Execute unit tests and provide technical support.

Skills

Data modeling and design principles

ETL processes development

AWS suite (Amazon Aurora, RDS, Glue)

SQL coding

Strong communication skills

Tools

Azure Data Factory

PowerShell

Git

Job description

HM Note : This hybrid contract role is three (3) days in office. Candidates' resumes must include first and last name.

Description

Responsibilities :

• Work as an integrated member of the Data Management team to support cross-functional data initiatives with various business clients.
• Interact with Business teams to understand technical functionalities, requirements, and analyze data requirements and their impact on existing systems.
• Connect various source and target systems (Oracle, Microsoft, Amazon Aurora, Amazon RDS, databases, APIs, flat files, etc.) and perform ETL activities.
• Develop ETL processes within Azure Data Factory or AWS equivalents such as Glue, Kinesis Data Firehose, SageMaker, Data Wrangler, OpenSearch, etc., and SQL code to meet business needs.
• Execute unit tests to ensure accuracy of code changes and verify data integrity and performance requirements.
• Participate in meetings and scrums, work on incident and enhancement tickets, and provide technical support.

Experience and Skill Set Requirements

Design, develop, and maintain database back-end and ETL applications for Data Warehouse and Business Intelligence solutions, ensuring scalability, standards compliance, and documentation.

Mandatory Skills :

• Experience with AWS suite : Amazon Aurora, Amazon RDS, Glue, OpenSearch, etc.
• Developing data extraction, transformation, and load programs for various data repositories.
• Developing, implementing, and maintaining ETL schedule / dependency logic.
• Data modeling and design principles for data marts and warehouses.
• Experience with Git and source control strategies.
• Creating technical documentation like ETL mappings, data model diagrams, architecture artifacts, and detailed design documents.
• Strong communication skills for clear and effective verbal and written communication.

Nice to Have Skills :

• Knowledge of AODA regulations and standards.
• Programming in C# and developing APIs, functions, etc.
• Scripting with PowerShell and other scripting languages.

Evaluation Criteria :

Core Technical Skills (50%), Other Technical Skills (35%), Communication Skills (10%), Standards and Best Practices (5%).

J-18808-Ljbffr

Create a job alert for this search

Software Developer • Toronto, ON, Canada