Design, develop, deploy, monitor, and support Talend-based enterprise data integration solutions. Build ETL/ELT pipelines, SQL transformations, API integrations, and Talend administration (TMC, Remote Engine). Troubleshoot production data pipelines, perform data reconciliation, implement data governance and security controls, and collaborate with stakeholders to ensure compliant data movement across cloud and legacy systems.
This is a remote position.
Job Description:
The client is seeking a hands-on Talend Integration Analyst to support the Digital Regulatory Assurance System (DRAS). The resource will design, develop, test, deploy, monitor, and support enterprise data integration solutions using Talend Integration Platform.
The role requires strong experience with Talend Studio, Talend Management Console (TMC), Talend Remote Engine, SQL, ETL/ELT, relational databases, APIs, production support, and data pipeline troubleshooting.
The successful candidate will work closely with data engineers, platform administrators, ministry stakeholders, and vendor support teams to ensure reliable and secure movement of data across legacy systems, modern platforms, cloud services, databases, APIs, and analytics environments.
Talend / Data Integration
- Design, develop, test, and maintain Talend Data Integration / Data Fabric jobs.
- Build reusable Talend jobs, routes, components, and integration workflows.
- Develop ETL/ELT processes for extracting, transforming, validating, and loading enterprise data.
- Create data mappings, transformation rules, reconciliation logic, and validation processes.
- Build parameterized and context-aware Talend jobs across Dev, Test, and Production.
- Develop scalable batch and near-real-time data integration solutions.
- Administer and support Talend Management Console (TMC).
- Install, configure, monitor, and troubleshoot Talend Remote Engine.
- Schedule, deploy, orchestrate, and monitor Talend jobs.
- Monitor job execution, throughput, failures, and performance.
- Troubleshoot integration failures, data-load issues, and production incidents.
- Provide ongoing production support within established SLAs.
- Develop complex SQL queries, stored procedures, data transformations, and validation logic.
- Work with relational databases such as:
- Microsoft SQL Server
- Oracle
- PostgreSQL
- Perform data reconciliation, quality checks, and troubleshooting.
- Optimize queries and integration processes for performance.
- Design and integrate RESTful APIs.
- Develop and expose secure data services using Azure API Management.
- Integrate APIs with enterprise applications and downstream systems.
- Support cloud-based data movement and integration.
- Implement data governance practices including:
- Metadata management
- Data classification
- Data lineage
- Data quality
- Apply privacy and security controls including:
- Role-based access control
- Encryption
- Data masking
- Ensure compliance with Government of Alberta privacy and regulatory requirements, including POPA.
- Use AI-assisted tools for:
- Code generation
- Code review
- Code optimization
- Data analysis
- Pipeline development
- Testing
- Monitoring
- Documentation
RequirementsMandatory Requirements
- Post-secondary degree, diploma, or certificate in Computer Science or a related field.
- 3+ years of experience designing, developing, testing, and supporting enterprise data integration solutions.
- 3+ years of hands-on experience with Talend Data Integration / Talend Studio / Talend Data Fabric.
- 3+ years of experience administering and supporting Talend Management Console (TMC).
- 3+ years of experience installing, configuring, supporting, and troubleshooting Talend Remote Engine.
- 2+ years of experience providing production support for enterprise integration solutions.
- 4+ years of experience working within a mature SDLC environment.
- 1+ year of experience using AI tools for code generation, data analysis, automation, testing, optimization, or documentation.
- Strong SQL and relational database experience.
- Hands-on experience with ETL/ELT, data mapping, transformation, and reconciliation.
- Experience with Talend job scheduling, deployment, orchestration, monitoring, and troubleshooting.
- Experience building reusable, parameterized, and context-aware integration jobs.
- Experience supporting batch and near-real-time data integration.
- Experience troubleshooting production data pipelines, integration failures, and data-load issues.
- 6+ years of experience performing business requirements analysis related to data and integration.
- 6+ years of strong technical experience with Microsoft SQL Server.
- 2+ years of experience building scalable ETL pipelines, data quality solutions, and cloud integrations.
- 3+ years of experience designing and integrating RESTful APIs.
- Experience with Azure API Management.
- 3+ years of experience with Message Queueing Technologies.
- Experience with ServiceNow–Azure Data Management Platform integrations.
- Experience with data governance, metadata management, data lineage, and data classification.
- Experience with cloud platforms and cloud-based data integration.
- Experience in government, environmental, healthcare, or other regulated environments.
- Experience implementing RBAC, encryption, data masking, and privacy controls.
- Experience using AI-assisted development tools such as GitHub Copilot, ChatGPT, or similar tools.
Similar Jobs
Information Technology • Professional Services • Software • Consulting
Design, develop, test, and support enterprise ETL/ELT data integration and pipeline solutions using Talend and relational databases. Build mappings, transformations, reconciliation, and reusable components; optimize SQL; administer Talend tooling; integrate REST APIs via Azure API Management; monitor and troubleshoot production pipelines; support data quality, governance, metadata, lineage, security, and SDLC processes while collaborating with stakeholders and using AI/automation tools for productivity.
Top Skills:
Ai ToolsAzureAzure Api ManagementEtl/EltMessage Queuing TechnologiesMicrosoft Sql ServerOraclePostgresRelational DatabasesRest ApisServicenowSQLTalendTalend Administration CenterTalend Management ConsoleTalend Remote Engine
Artificial Intelligence • Biotech
Build reusable Python libraries and reproducible analysis pipelines for image and experimental data; define data models and provenance; partner with wet‑lab scientists to translate requirements and validate methods; establish testing, validation, versioning, and observability for scientific workflows.
Top Skills:
AirflowDagsterGitPrefectPython
Digital Media • Gaming • Information Technology • Software • Sports • Esports • Big Data Analytics
Lead end-to-end personalization data science initiatives: design and deploy machine learning and statistical models into production, optimize recommendations and content layouts, partner with engineering/product/analytics, monitor performance, and mentor junior scientists.
Top Skills:
Data VisualizationMachine LearningPersonalization AlgorithmsProduction Model DeploymentPythonStatistical Modeling
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
