Software Developer ETL 9197-3010

Foilcon; Toronto; Hybrid; CAD 70,000 - 110,000; Full time

Job summary

An innovative firm is seeking a skilled Software Developer specializing in ETL processes to join their dynamic Data Management team. This hybrid role involves collaborating with various business clients to understand technical requirements and develop robust ETL solutions using Microsoft Azure and AWS technologies. You will be responsible for connecting diverse data sources, optimizing SQL code, and ensuring data integrity through rigorous testing. This exciting opportunity offers a chance to work in a collaborative environment where your contributions will directly impact data-driven initiatives. If you are passionate about data management and thrive in a fast-paced setting, this role is perfect for you.

Qualifications

• Experience with Microsoft Azure and AWS data services.
• Proficiency in developing ETL programs and data modeling.

Responsibilities

• Support cross-functional data initiatives with business clients.
• Develop ETL processes and optimize SQL code for reporting.

Skills

Microsoft Azure Data Factory

AWS technologies

ETL processes

SQL

Data modeling

Git

Technical documentation

Business requirements validation

Communication skills

Education

Bachelor's degree in Computer Science or related field

Tools

Azure Data Factory

AWS Glue

Power BI

SQL Server

Amazon Aurora

Job description

Join to apply for the Software Developer ETL 9197-3010 role at Foilcon

3 days ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

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

Description

Responsibilities

1. Work as an integrated member of the Data Management team to support cross functional data initiatives with various business clients.
2. Interact with Business teams to better understand the technical functionality requirements and analyze data requirements and their impact to the existing systems.
3. Responsible for connecting various source and target systems (Oracle, Microsoft, Amazon Aurora, AWS services, APIs, flat files, etc.) and performing Extract, Transform, and Load (ETL) activities.
4. Develop ETL processes within Azure Data Factory or AWS equivalents such as Glue, Kinesis Data Firehose, SageMaker, Data Wrangler, OpenSearch Service, etc., and SQL code to meet business requirements.
5. Create ETL mappings, develop stored procedures, SQL queries, and optimize SQL code for ETL processes and reporting databases.
6. Execute unit tests to ensure code accuracy, data integrity, and performance standards.
7. Participate in meetings and scrums, handle incident and enhancement tickets, and provide technical support.
8. Create and maintain technical documentation, including data models.

Skills

Experience and Skill Set Requirements

1. Experience with Microsoft Azure Data Factory, Azure SQL Database, Azure Data Lake, Power BI.
2. Experience with AWS technologies like Amazon Aurora, Glue, OpenSearch.
3. Experience developing data extraction, transformation, and load programs across various data repositories.
4. Experience with ETL scheduling, data integration, cleansing, and analytics.
5. Knowledge of data modeling and design for data warehouses.
6. Proficiency in database management, complex SQL queries, and performance tuning.
7. Experience with Git and source control strategies.
8. Ability to create detailed technical documentation.
9. Experience eliciting and validating business requirements.
10. Understanding of the software development lifecycle.
11. Strong communication skills, both verbal and written.

Nice To Have Skills

1. Knowledge of Accessibility for Ontarians with Disabilities Act (AODA).
2. Experience designing dashboards and reports.
3. Programming skills in C# and developing APIs or functions.
4. Scripting experience with PowerShell or similar languages.

Evaluation Criteria

Core Technical Skills: 50%

1. Experience with Microsoft Azure and AWS data services.
2. Proficiency in developing ETL programs and data modeling.
3. Experience with SQL and database optimization.
4. Ability to document technical processes.

Other Technical Skills: 35%

1. Dashboard and report development experience.
2. Programming and scripting skills.
3. Version control and software lifecycle experience.

Communication Skills: 10%

1. Business requirements documentation and validation.
2. Effective verbal and written communication.

Standards and Best Practices: 5%

• Knowledge of AODA standards.

Must Haves

• Experience with Microsoft Azure data services.
• Experience with AWS data services.
• ETL development across various data repositories.
• ETL scheduling and dependency logic.
• Data integration, cleansing, and analytics.
• Data modeling for warehouses.

Additional Information

• Seniority level: Mid-Senior level
• Employment type: Contract
• Job function: Engineering and IT
• Industries: IT Services and Consulting