Programmer Analyst Advisory

Responsibilities

• Lead ETL development functions for all projects and clients within the Data Composition applications.
• Design, develop, and maintain scalable ETL solutions using Talend Data Integration to support enterprise data platforms.
• Build data pipelines aligned with Data Warehousing concepts, including fact/dimension loads and Slowly Changing Dimensions (SCD).
• Manage Talend jobs using Talend Management Console (TMC), including deployment, scheduling, and monitoring.
• Develop and maintain Unix/Linux shell scripts (bash/ksh) to automate ETL workflows and operational processes.
• Handle EBCDIC file processing and conversion, ensuring accurate parsing and character encoding.
• Perform data validation, reconciliation, and audit checks using advanced SQL.
• Provide technical leadership, coaching, and mentorship to less experienced team members.
• Collaborate with cross-functional teams and stakeholders to translate business requirements into technical solutions.
• Provide production support, including troubleshooting and overnight/weekend implementations when required.

Requirements

• Bachelor's degree in Computer Science or an equivalent field.
• 8-10 years of experience in ETL development using technologies such as Talend, Informatica PowerCenter, or IBM DataStage.
• Strong hands-on expertise with Talend Data Integration/Talend Studio (tMap, joblets, context variables).
• Proven experience with Talend Management Console (TMC) for job deployment and environment management.
• Solid understanding of Data Warehousing principles, dimensional modeling, and batch processing.
• Advanced proficiency in SQL for data transformation and performance tuning.
• Strong experience in Unix/Linux environments and shell scripting (bash/ksh).
• Experience processing EBCDIC encoded files and copybook-based fixed-length formats.

Benefits

• Competitive rewards program including bonus, flexible vacation, and personal/sick days.
• Comprehensive benefits starting from day one.
• Upskilling opportunities through online courses and tuition assistance.
• Inclusive and diverse work culture with various Employee Resource Groups (ERGs).
• Dynamic workspace with collaborative areas and amenities.

About the Company

Scotiabank is a leading bank in the Americas, dedicated to helping customers, families, and communities achieve success through a broad range of financial products and services. We foster an inclusive, high-performing culture where diversity and equity are core values.