Platform Engineer – Data Pipelines & ETL (Java/SQL)

Scotiabank; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading financial institution in Toronto is seeking an experienced Developer with strong skills in Java and ETL development using IBM DataStage. The role involves designing, developing, and maintaining applications while optimizing data pipelines. The ideal candidate will have a solid understanding of Oracle SQL and scripting experience. The organization emphasizes inclusion and offers competitive rewards, benefits, and opportunities for professional growth.

Benefits

Diversity and inclusion initiatives

Upskilling opportunities

Competitive rewards program

Community engagement opportunities

Qualifications

• Strong proficiency in Java (JDK 8+), OOP concepts, and REST APIs.
• Experience with IBM DataStage for ETL design and development.
• Solid understanding of Oracle database concepts and SQL optimization.
• Good OS-level knowledge: Linux/Unix.
• Scripting experience (e.g., Shell, Python, Batch).
• Experience with CI/CD tools is an asset.
• Strong analytical skills and attention to detail.

Responsibilities

• Design, develop, and maintain applications using Java.
• Build and troubleshoot ETL workflows using IBM DataStage.
• Write SQL queries for Oracle databases.
• Develop automation scripts using Shell or Python.
• Collaborate with teams to deliver scalable solutions.

Skills

Java

ETL development (IBM DataStage)

Oracle SQL

Shell scripting

Python scripting

CI/CD tools

Power BI

Job description

A leading financial institution in Toronto is seeking an experienced Developer with strong skills in Java and ETL development using IBM DataStage. The role involves designing, developing, and maintaining applications while optimizing data pipelines. The ideal candidate will have a solid understanding of Oracle SQL and scripting experience. The organization emphasizes inclusion and offers competitive rewards, benefits, and opportunities for professional growth.