Develops, operates, troubleshoots, and modernizes enterprise data integrations using Talend. Responsibilities include building ETL/ELT pipelines, APIs, batch and real-time jobs, SQL transformations, scheduling, monitoring, production support, incident resolution, data quality, root-cause analysis, and platform maintenance. The role collaborates with technical and business stakeholders across development, testing, and production environments, while applying AI and automation to improve pipeline development, testing, monitoring, and documentation.
This is a remote position.
Project Description
Project: Data Management Platform Integration Services
The Government of Alberta is seeking a hands-on Talend Integration Platform Analyst to develop, operate, troubleshoot, and enhance enterprise data integrations within the Data Management Platform. The role focuses on Talend-based ETL/ELT integrations, SQL development, job scheduling and monitoring, production support, incident resolution, data quality, and integration modernization.
The resource will collaborate with data engineers, solution architects, platform administrators, application teams, vendors, and business stakeholders to deliver reliable and scalable integrations across databases, files, APIs, cloud platforms, and enterprise applications.
Key Responsibilities
- Design, develop, test, deploy, and maintain Talend integration jobs, services, APIs, and reusable components.
- Develop ETL/ELT pipelines across databases, files, APIs, cloud platforms, and enterprise applications.
- Translate business/data requirements into technical designs, mappings, transformations, and reconciliation processes.
- Build parameterized and environment-aware integrations across Dev, Test, and Production.
- Develop batch and near-real-time integrations.
- Administer, schedule, orchestrate, monitor, and troubleshoot Talend jobs and platform components.
- Support Talend Management Console (TMC) and Talend platform operations.
- Investigate production incidents, failed data loads, integration errors, and performance issues.
- Perform root-cause analysis and implement corrective/preventive actions.
- Implement logging, monitoring, alerting, and automated recovery mechanisms.
- Support releases, upgrades, patching, and environment maintenance.
- Collaborate with infrastructure teams, vendors, business stakeholders, and application teams.
- Apply AI and automation tools for pipeline development, testing, monitoring, documentation, code generation, optimization, and review.
- Participate in solution design, estimation, and release planning.
Requirements
Mandatory Requirements
- Post-secondary degree, diploma, or certificate in Computer Science or a related field.
- Minimum 3 years of experience designing, developing, testing, and supporting enterprise data integration solutions.
- Minimum 5 years of experience administering and supporting Talend Management Console (TMC) or Talend platform.
- Minimum 3 years of experience installing, configuring, supporting, and troubleshooting Talend Remote Engine.
- Minimum 2 years of experience providing production support for enterprise integration solutions.
- Minimum 4 years of experience working within a mature Software Development Lifecycle (SDLC).
- Minimum 1 year of experience using AI for code generation, data analysis, automation, or related development activities.
- Hands-on experience with Talend Data Integration / Talend Data Fabric / Talend Studio.
Nice-to-Have Requirements
- 6+ years of business requirements analysis related to data/integration.
- 6+ years of strong Microsoft SQL Server experience.
- 2+ years building scalable ETL pipelines, enforcing data quality, and working with cloud platforms.
- 3+ years designing and integrating RESTful APIs.
- 3+ years working with Message Queueing Technologies.
- 1+ year working with ServiceNow/Azure-based Data Management Platform integrations.
Similar Jobs
Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
Leads business systems analysis and data engineering support for military sustainment digital services. The role gathers and documents requirements, maps workflows, defines reporting and data needs, supports ETL/ELT, SQL analysis, integrations, dashboards, testing, governance, and implementation readiness. It partners with government, program, supplier, operational, product, and technical stakeholders to improve readiness and operational performance, while mentoring junior analysts and maintaining requirements, process, data, and delivery documentation.
Top Skills:
AgileAmazon RedshiftAPIsAWSAzure SynapseConfluenceData ModelingDatabricksEtl/EltGitJIRALookerMiddlewarePower BIQlikSnowflakeSplunkSQLTableau
Artificial Intelligence • Marketing Tech • Software
Design, build, deploy, and maintain scalable multi-source ELT pipelines and enterprise data warehouse infrastructure. The role involves optimizing data systems for cost, performance, reliability, and SLAs; curating campaign and business data; creating monitoring and automation; and collaborating with engineering, analytics, SRE, and platform teams to deliver reliable data products.
Top Skills:
AirbyteAmazon AuroraAmazon RedshiftApache AirflowApache FlinkApache IcebergAWSCi/CdCloudFormationDagsterDbtGitJavaPythonSQLTableauTerraform
Pet • Software
Build and own Snout’s data foundation, including PostgreSQL and dbt warehouses, ingestion pipelines, dimensional models, data quality, documentation, and reliable rebuilds. Reconcile data from veterinary practice-management systems, support LLM/AI tooling, translate stakeholder needs into technical plans, and establish the foundation for a future data team and analyst.
Top Skills:
AWSDbtLlm/AiPostgresPythonSQL
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
