Apply on Kit Job: kitjob.ca/job/2frxfc

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

This is an onsite role located in Toronto, requiring you to work in the office 5 days a week.

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 Center 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 Center 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 cooperative environment, we would love to hear from you.

Please apply via LinkedIn or send us your resumes at .

#J-18808-Ljbffr

Apply on Kit Job: kitjob.ca/job/2frxfc

📌 ETL Developer (Toronto)
🏢 CloudVital
📍 Toronto