ETL Developer

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

Job summary

An innovative firm is seeking a skilled ETL Developer to enhance data integration and transformation processes. This hybrid role offers the chance to work both on-site and remotely, allowing for flexibility while contributing to vital data projects. You'll collaborate with cross-functional teams, implement solutions with Azure Data Factory and Informatica, and manage complex data transformations. If you have a passion for data and a knack for problem-solving, this is a fantastic opportunity to make an impact in a dynamic environment.

Qualifications

• Proficiency in SQL with query performance tuning.
• Extensive experience with Azure Data Factory and Informatica.

Responsibilities

• Collaborate with teams to analyze requirements for data integration.
• Develop and maintain ETL processes using Azure Data Factory.

Skills

SQL

Informatica PowerCenter

Azure Data Factory

Data modeling

Attention to detail

Problem solving

Tools

Azure CI/CD

Microsoft SSIS

Job description

We are currently seeking an ETL developer to design, develop, and maintain ETL processes for data integration and transformation.

Job Role:

ETL Developer

Job Type:

Full-Time/Contract

Location:

Toronto, Canada

Role Details:

This is a Hybrid role with 3 days onsite and 2 days remote!

Responsibilities:

1. Collaborate with cross-functional teams to gather and analyze requirements for data integration projects.
2. Implement solutions using Azure Data Factory (ADF) pipeline, stored procedures, and Informatica PowerCenter to populate enterprise data warehouses.
3. Develop Azure CI/CD pipelines to automate ADF releases.
4. Implement complex data conversions, e.g., binary to character, EBCDIC to UTF.
5. Develop complex data transformations for derived and calculated values.
6. Integrate data sets from diverse source systems.
7. Manage initial data loads and incremental loads using ADF.
8. Promote ETL/ELT processes through development, testing, QA, UAT, and production environments.
9. Debug ADF pipelines, stored procedures, and Informatica workflows to investigate and fix defects.
10. Optimize performance of ADF pipelines, Azure SQL, Synapse databases, and Informatica workflows.

Skills Required:

• Proficiency in SQL, including query performance tuning and index management.
• Understanding of data modeling concepts.
• Extensive experience with Informatica PowerCenter and Microsoft SSIS.
• Extensive experience with Azure Data Factory.
• High attention to detail.
• Passion for complex data structures and problem solving.

Additional Details:

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Information Technology
• Industries: IT Services, IT Consulting, Technology, Media

Referrals increase your chances of interviewing at CloudVital by 2x.

Note:

Sign in to set job alerts for “ETL Developer” roles.