Developer – SQL & Talend ETL Specialist

About the role

This position is for an experienced Developer who will design, build, and optimise data integration workflows using SQL and Talend ETL. Working in a hybrid environment on a day‑shift schedule, you will ensure reliable movement and transformation of critical business data to support analytics, reporting, and regulatory requirements.

Key responsibilities

• Design and implement scalable Talend ETL solutions for enterprise reporting and analytics.
• Develop, optimise, and troubleshoot complex SQL queries, stored procedures, and transformation logic.
• Analyse business requirements and source systems to define mapping rules and integration patterns.
• Collaborate with data architects, analysts, and application teams to align ETL solutions with strategic objectives.
• Implement data quality checks, validation routines, and reconciliation processes within Talend workflows.
• Monitor scheduled ETL jobs, identify bottlenecks, and perform root‑cause analysis on failures.
• Document technical designs, data‑flow diagrams, and operational procedures.
• Work with operations to create deployment pipelines, environment promotion practices, and configuration management.
• Coordinate integration testing, system testing, and data validation for new or enhanced ETL solutions.
• Apply secure access patterns to meet data‑privacy and compliance requirements.
• Contribute to continuous‑improvement initiatives by refactoring inefficient jobs and adopting best practices.

Required profile

• Proven experience as a Developer specialising in SQL data integration and Talend ETL.
• Strong analytical skills to translate business requirements into technical solutions.
• Ability to work effectively in a hybrid, collaborative environment.
• Detail‑oriented with a focus on data quality, performance, and maintainability.

Required skills

• SQL (queries, stored procedures, data transformation).
• Talend ETL platform.
• Data integration and ETL workflow design.
• Data quality validation and reconciliation techniques.
• Monitoring and performance tuning of scheduled ETL jobs.
• Technical documentation (design diagrams, operational procedures).
• Deployment pipelines and configuration management.
• Secure data access and compliance best practices.