ETL Developer

Location: Toronto, ON (Hybrid, 4 days per week on-site at 87 Sir William Hearst Ave.)
Language: Excellent written and verbal English communication skills
Duration: Contract
Background Check Requirement: Must be eligible to meet applicable government security screening requirements. Previous Ontario Public Service (OPS) experience is mandatory.

About the Opportunity
Join a high-impact public sector team focused on delivering modern, reliable data integration solutions that support critical government services. This opportunity is ideal for an experienced ETL and Azure Data Developer who thrives in complex technical environments and enjoys transforming business requirements into scalable, high-quality data solutions.

Working alongside cross-functional technical and business teams, you'll contribute to the design, development, and enhancement of enterprise data platforms. Your expertise will help drive innovation, improve data quality, and support informed decision-making across the organization.

What's In It for You
You'll have the opportunity to work on meaningful projects that leverage modern Azure technologies while collaborating with experienced professionals in a highly collaborative environment.

This role offers exposure to enterprise-scale data initiatives, the chance to contribute to continuous improvement, and the opportunity to expand your expertise in cloud-based data integration, DevOps, and business intelligence solutions.

Your Responsibilities
• You'll design, develop, and implement enterprise ETL solutions using Azure Data Factory, Databricks, Logic Apps, and Function Apps.
• You'll build and maintain data movement pipelines, perform complex data transformations, and optimize performance for large data volumes.
• You'll enhance and support existing ETL processes by troubleshooting issues, validating data transformations, and improving overall reliability.
• You'll develop database solutions using Oracle PL/SQL and SQL Server stored procedures to support business and operational requirements.
• You'll contribute to Azure DevOps CI/CD pipelines, source control, and deployment processes using GitHub, Azure Repos, Azure Pipelines, and Azure Resource Manager.
• You'll collaborate with business stakeholders to gather requirements and deliver scalable, high-quality data integration solutions.
• You'll support reporting and analytics initiatives using IBM Cognos and Microsoft Power BI.

Skills and Qualifications
• Previous Ontario Public Service (OPS) experience is required.
• Extensive experience designing and developing ETL solutions using Azure Data Factory and Databricks, including Self-Hosted Integration Runtime, ETL pipelines, performance tuning, complex data transformations, Azure Roles, and ADF Debugger.
• Hands-on experience with Informatica, including Workflow Manager, Repository Manager, Designer, and Workflow Monitor.
• Experience developing solutions using Logic Apps and Azure Function Apps, along with Rapid Application Development (RAD) methodologies.
• Strong experience with Azure DevOps, CI/CD concepts, Azure Boards, Azure Test Plans, Azure Pipelines, Azure Repos, Azure Artifacts, GitHub, and source code version control.
• Extensive experience developing Oracle PL/SQL programs, SQL Server stored procedures, and working with Oracle, Microsoft SQL Server, Azure SQL Database, Synapse, and relational and hierarchical database technologies.
• Strong analytical, problem-solving, and communication skills with the ability to work effectively in collaborative technical environments.

Why Partner with Altis
If you've never worked with a staffing agency before, we make it easy. We work with top employers across Canada who have great jobs to fill, each vetted and verified by our team. When you apply for a job with Altis, we get to know you as a candidate and learn what your strengths are. Then, if you're a solid match, we handle all the logistics, advocating for you as a candidate for the role, providing access to coaching and connecting you directly with the hiring manager. And rest assured, all our services are free of cost for candidates.

We appreciate the time and effort all applicants invest in their submissions. Please note that only candidates shortlisted for this role will be contacted directly. However, your profile will remain under consideration for future opportunities that align with your experience and career goals. All qualified applicants will receive fair consideration for employment. We welcome individuals of all backgrounds, experiences, and identities including those who identify as women, members of racialized groups, Indigenous Peoples, persons with disabilities, and 2SLGBTQIA+ communities. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions. Our human recruiters review all applications and always make the final hiring decision. On occasion, we also use AI-assisted tools to help review applications.