Software Engineer (ETL Development focus)

Software Engineer (ETL Development focus)

Requisition ID: 265190

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. As a Software Engineer (ETL Development focus) within Client Systems, Canadian Banking Engineering team, you will play a key role in designing, developing, and modernizing enterprise-grade data integration platforms. This includes building scalable batch and distributed data pipelines, enabling high-performance data processing using Spark, and supporting the transformation of legacy ETL workloads into modern, cloud-ready architectures. This role is ideal for someone who thrives in large-scale data transformation programs, enjoys working on high-volume data pipelines, and is motivated to deliver reliable, performant, and future-ready data integration solutions.

Is this role right for you?

In this role, you will:

• Design, develop, and support scalable ETL/data pipelines using tools such as Talend and Apache Spark framework
• Lead and contribute to the migration of legacy ETL workloads to modern frameworks (e.g. Spark )
• Build and optimize large-scale batch and distributed data processing pipelines
• Analyze ETL performance (CPU, memory, I/O, runtime bottlenecks) and implement tuning strategies
• Develop reusable ETL frameworks, components, and orchestration patterns for enterprise use
• Implement data ingestion, transformation, and data quality checks across structured and semi-structured data sources
• Develop and maintain complex SQL transformations, stored procedures, and data models
• Integrate ETL pipelines with enterprise systems using messaging (Kafka/MQ), APIs, and batch orchestration frameworks
• Ensure data integrity, lineage, reconciliation, and auditability across pipelines
• Collaborate with architecture and engineering teams to design target-state data platforms and migration approaches
• Participate in end-to-end system integration and migration testing across distributed platforms
• Contribute to technical design discussions and provide input to stakeholders
• Collaborate with cross-functional teams including data engineering, application support, database, and infrastructure teams
• Mentor junior developers and promote best practices in ETL design, perform