ETL Developer

CloudVital; Golden Horseshoe; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading company in the Golden Horseshoe area is seeking an ETL Developer to design and maintain ETL processes. This hybrid role offers the chance to work with cutting-edge technologies in a collaborative environment. The ideal candidate will have extensive experience with ETL tools, strong SQL skills, and a passion for complex data structures. If you're ready for an exciting opportunity, we want to hear from you!

Qualifications

• Extensive experience with ETL tools and Azure Data Factory.
• Strong SQL competence and understanding of data modelling.

Responsibilities

• Collaborate with teams to gather requirements for data integration.
• Implement solutions using Azure Data Factory and Informatica.
• Debug and optimize ETL processes.

Skills

SQL

Data Modelling

Attention to Detail

Problem Solving

Tools

Informatica Power Centre

Microsoft SSIS

Azure Data Factory

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

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

Mid-Senior level

Employment type

Full-time

Job function

Information Technology

IT Services and IT Consulting, Information Services, and Technology, Information and Media

J-18808-Ljbffr

Create a job alert for this search

Etl Developer • Golden Horseshoe, ON, Canada