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

Job Role: Senior ETL Developer

Job Type: Full -Time/Contract

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

Responsibilities:

- Collaborate with cross-functional teams to gather and analyze requirements for data integration projects.
- Analyze requirements/specifications and architectural/system design documents
- Implement solutions using Azure Data Factory (ADF) pipelines and stored procedures, and Informatica Power Centre to populate the 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 prospect to work with cutting-edge technologies in a collaborative environment, we would love to hear from you.

#J-18808-Ljbffr

📌 Senior ETL Developer (Toronto)
🏢 CloudVital
📍 Toronto