ETL Developer

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

Job summary

CloudVital is seeking a skilled ETL Developer to design, develop, and maintain ETL processes for data integration and transformation. This hybrid role involves collaborative projects utilizing Azure Data Factory and Informatica Power Centre, aimed at optimizing complex data structures. Ideal candidates will have a detail-oriented approach and strong SQL skills, contributing to innovative solutions in a technology-driven environment.

Qualifications

• Mid-Senior level ETL Developer with experience in Azure Data Factory and Informatica.
• Competent in SQL and data modeling.
• Attention to detail and strong problem-solving skills required.

Responsibilities

• Collaborate with teams for data integration requirements.
• Implement solutions using ADF and Informatica.
• Optimize performance of ETL processes.

Skills

SQL competence

Data modeling concepts

Informatica Power Centre

Azure Data Factory

Attention to detail

Problem solving

Job description

3 days ago Be among the first 25 applicants

Direct message the job poster from CloudVital

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

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

Responsibilities:

· Collaborate with cross-functional teams to gather and analyze requirements for data integration projects.

· Implement solution using Azure Data Factory (ADF) pipeline and stored procedure, and Informatica Power Centre to populate enterprise data warehouse

· Develop Azure CI/CD pipeline to automate ADF release

· Implement complex data conversion, e.g., binary to character, EBCDIC to UTF

· Implement complex data transformation(s) for derived and calculated values

· Integrate data sets from diverse source systems

· Implement ADF for initial data load and incremental load

· Promote ADF and Informatica ETL/ELT including: Development, Integration Testing, QA, UAT, Production

· Debug ADF pipeline and stored procedure and Informatica workflow to investigate and fix defects

· Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow

Skills Required:

· SQL competence (query performance tuning, index management, etc.) and a grasp of database structure are required.

· Understanding of data modelling concepts.

· Extensive experience with ETL tools Informatica Power Centre and Microsoft SSIS

· Extensive experience with Azure Data Factory

· High attention to detail

· Passionate about complex data structures and problem solving

If you are a skilled ETL Developer looking for an exciting opportunity to work with cutting-edge technologies in a collaborative environment, we would love to hear from you.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Software Development and Technology, Information and Media

Referrals increase your chances of interviewing at CloudVital by 2x

Get notified about new ETL Developer jobs in Toronto, Ontario, Canada.

Freelance GenAI Developer - Prompt Engineering & Data Workflows

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.