ETL Developer - Remote

Overview

The ETL Developer will be responsible for designing, developing, and implementing data pipelines using Azure Data Factory and Informatica PowerCenter, ensuring efficient extraction, transformation, and loading of data.

In Short

• Design, develop, and implement data pipelines using Azure Data Factory.
• Develop Azure CI/CD pipelines to automate ADF releases.
• Extensive experience with ETL processes and data integration.
• Collaborate with IT professionals throughout the software development life cycle.
• Document information from diverse business area stakeholders.
• Monitor and analyze incidents, providing timely resolutions.
• Optimize performance of ADF pipelines and databases.
• Implement complex data transformations and conversions.
• Provide effective knowledge transfer to Ministry staff.
• Work in a hybrid model with 3 days onsite and 2 days remote.

Requirements

• Extensive experience with Azure Data Factory and Informatica.
• Strong knowledge of SQL Server and Oracle PL/SQL.
• Experience with CI/CD pipelines and Azure DevOps.
• Ability to design logical and physical data models.
• Experience in performance tuning on large data volumes.
• Knowledge of Business Intelligence tools like IBM Cognos and Microsoft PowerBI.
• Experience in maintaining and improving existing ETL processes.
• Strong problem-solving skills and attention to detail.
• Excellent communication and documentation skills.
• Ability to work collaboratively in a team environment.

Benefits

• Opportunity to work with a leading Ministry in Ontario.
• Hybrid work model providing flexibility.
• Engagement in diverse and challenging projects.
• Professional development opportunities.
• Supportive work environment.