Scotiabank

Programmer Analyst Advisory

Scotiabank • $90K — $120K *
Toronto, ON M3C 0E3In-Person
Information Technology
8 - 10 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Computer Science or equivalent experience.
  • 8-10 years of experience in ETL development with Talend, Informatica PowerCenter, and IBM DataStage.
  • Strong hands-on experience with Talend Data Integration including tMap and error handling mechanisms.
  • Proven experience with Talend Management Console for job management and monitoring.
  • Advanced proficiency in SQL for data transformation and performance tuning.
  • Solid understanding of data warehousing and batch processing principles.
  • Experience in Unix/Linux environments and shell scripting for ETL automation.

Responsibilities

  • Lead ETL development functions for various projects and clients.
  • Design, develop, and maintain ETL solutions using Talend and other technologies.
  • Build data pipelines aligned with Data Warehousing concepts.
  • Manage Talend jobs through the Talend Management Console.
  • Translate business requirements into optimized Talend job designs.
  • Perform data validation and reconciliation using SQL.
  • Troubleshoot ETL and SQL issues in production and non-production environments.

Benefits

  • Commitment to Diversity, Equity, Inclusion & Allyship.
  • Accessibility and workplace accommodations for all employees.
  • Opportunities for upskilling through courses and development.
  • Competitive rewards including flexible vacation and benefits starting day one.
  • Dynamic work environment with amenities for collaboration.
  • Community engagement programs available for all locations.
Full Job Description
Requisition ID: 259874

The Programmer Analyst Advisory be responsible for the ETL development for the Data Composition applications within Canada. The incumbent will influence the technology solution in relationship to architecture, design and development to meet client's requirements.

The incumbent will contribute to the overall success of the team by ensuring specific individual goals, plans, initiatives are executed/delivered in support of the team's business strategies and objectives. Ensures are activities conducted are in compliance with governing regulations, internal policies and procedures.

Is this role right for you? In this role, you will:

  • Leads the ETL development functions for all projects/clients
  • Design, develop, and maintain scalable ETL solutions using Talend Data Integration as well as other ETL technologies to support enterprise data platforms
  • Build data pipelines aligned with Data Warehousing concepts, including fact/dimension loads, incremental processing, and Slowly Changing Dimensions (SCD)
  • Manage Talend jobs using Talend Management Console (TMC), including deployments, scheduling, monitoring, and log analysis across environments
  • Translate business and data requirements into optimized Talend job designs, applying best practices for performance, reusability, and error handling
  • Perform data validation, reconciliation, and audit checks using SQL to ensure data accuracy and completeness
  • Develop and maintain Unix/Linux shell scripts to automate ETL workflows, job execution, and operational processes
  • Troubleshoot and resolve ETL, SQL, and Unix related issues in both non production and production environments
  • Handle EBCDIC file processing and conversion (including copybook based fixed width files), ensuring accurate parsing, character encoding conversion, and downstream compatibility
  • Develop and maintain complex data mappings using Talend components such as tMap and Talend Data Mapper, handling hierarchical, flat file, and structured data formats
  • Collaborate with cross functional teams across development, testing, and deployment phases to support end to end delivery.
  • Manage Client Stakeholders for support on existing services as well as new functions as part of project execution
  • Provide overnight and weekend support to conduct Production code implementations
  • Leads the execution of day-to-day project and task oriented work efforts and meeting customer expectations for contracted time, cost and specification definitions
  • Builds and maintains solid, professional working relationships with peers within the business lines
  • Meets scheduled milestones to ensure project/program objectives are met in a timely manner, has an in-depth knowledge of the principles, theories, practices and techniques for managing the activities related to planning, managing and implementing software solutions
  • Deliver the assigned project to specs within the projected timelines
  • Works closely with customers, Business Analysts, and team members to understand business requirements that drive the analysis and design of quality technical solutions
  • Involved in the full systems life cycle and is responsible for designing, coding, testing, implementing, and supporting applications software that is delivered on time and within budget
  • Makes recommendations towards the development of new code or reuse of existing code, and do the code review afterward
  • Participation in component and data architecture design, performance monitoring and product evaluation
  • Provides front-line application support and coordination when application problems occur, provides production support independently
  • Liaisons with external vendors, product users, operations staff, technical support groups and other development teams in all phases of development project activities and production support activities
  • Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
  • Participate on an ongoing, active and concurrent basis as technical consultant, informing design, development, coding, testing, and debugging of new / packaged solutions or significant enhancements to existing applications to deliver the best possible application performance
  • Provide technical leadership and subject matter expertise to fellow team members and stakeholders across business and technical project dimensions:
  • Provides thought-leadership to fellow team members and stakeholders across business and technical project dimensions solving complex programming issues
  • Ability to research and recommend enhancements to the strategic technology evolution of the product based on new and emerging technologies and industry best practices
  • Actively inform and provide recommendations on technology roadmaps, team development standards, system architecture / integration, product design, data modelling, testing, etc.
  • Act as coach and mentor to less experienced and or new team members (e.g. conduct tech walkthroughs)
  • In an agile environment, develop cost effective and efficient applications to meet business objectives by analyzing user requirements, providing technical specifications and design and developing/maintaining programs according to standards. The incumbent must ensure programs and applications developed meet the high availability, integrity and reliability of the on-line transaction processing environment
  • Provide production and user acceptance testing support to assigned applications by identifying, evaluating, escalating, resolving problems and supporting other team members. The incumbent may be required to provide after hours support to ensure systems are operational according to documented user service level agreements.
  • Implement new systems or enhancements by reviewing programs written by team members, establishing and executing system test procedures, developing implementation plan, developing the required program and system documentation and ensuring all functionality has been delivered as required. The incumbent is also required to provide post implementation support to ensure quality delivery
  • Assist project leader or Manager by supervising more junior staff, providing backup support to the Project Leader or Manager, assisting with the development of detailed workplaces and monitoring progress against plan
  • Keep current on rapidly changing technological trends, self teach new technologies and maintain an understanding of the Division's business and technology strategies
  • Actively pursues effective and efficient operations of his/her respective areas in accordance with Scotiabank's Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.
  • Champions a high performance environment and contributes to an inclusive work environment


Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:

  • Bachelor in Computer science or equivalent
  • 8-10 Years of experience developing on various ETL technologies including Talend, Informatica PowerCenter and IBM DataStage, Python (with a focus on data integration)
  • Strong hands on experience with Talend Data Integration/Talend Studio, including tMap, joblets, context variables, and error handling mechanisms.
  • Proven experience working with Talend Management Console (TMC) for job deployment, scheduling, environment management, and monitoring.
  • Solid understanding of Data Warehousing principles, including dimensional modeling, SCD types, and batch processing strategies.
  • Advanced proficiency in SQL for data transformation, reconciliation, validation, and performance tuning.
  • Strong experience working in Unix/Linux environments, including file system operations and process control.
  • Hands on expertise in shell scripting (bash/ksh) for ETL automation and operational support.
  • Experience supporting ETL solutions across DEV, UAT, and PROD environments.
  • Familiarity with enterprise data security, access controls, and audit requirements in batch oriented data integration systems.
  • Hands on experience reading and processing EBCDIC encoded files, including copybook based fixed length formats, and converting them to ASCII/UTF 8 as part of ETL pipelines.


What's in it for you?

  • Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
  • Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
  • Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
  • Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
  • Dynamic Ecosystem - Free tea & coffee, universal washrooms, and lots of space for team collaboration.
  • Community Engagement - No matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs.


Location(s): Canada : Ontario : Toronto

Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.

About Scotiabank

Scotiabankers are committed to helping individuals, companies, and communities to thrive in a changing world. From personal and business banking, brokerage, and insurance, to private wealth, and the most sophisticated commercial, corporate and institutional services, they serve the diverse needs of some 21 million customers in more than 55 countries. Founded in 1832 in Halifax, Nova Scotia, their growth has always been fuelled by the success of their customers and their longevity secured by an unshakable commitment to carefully and expertly managing risk and capital. That focus on doing what's right for customers—short- andlong-term—has made us a global financial services leader. Headquartered in Canada, they are over 86, 000 Scotiabankers strong. Each of us are committed to being the best at understanding their customers' needs and all of us working together to deliver practical advice and relevant solutions that help their customers become financially better off.

Scotiabank Careers

Join Scotiabank, a premier financial institution, and become part of a diverse and inclusive team that’s leading the way in global banking. At Scotiabank, we offer more than just job opportunities; we provide a platform for professional growth and innovation in the financial services industry.

Work You’ll Do

At Scotiabank, we’re not just filling positions; we’re cultivating leaders. Dive into a workplace where diversity training and leadership development shape the path to your future. Our commitment to professional growth is evident in our robust training programs and continuous learning opportunities that foster innovation and strategic thinking.

Explore a World of Opportunities

Whether you’re looking for a full-time position, an internship, or a leadership role, Scotiabank has a spectrum of opportunities to fit your career ambitions. Our team is composed of individuals who bring a wealth of skills and perspectives to our company, driving us forward with their creativity and strategic insights.

Innovative Work Environment

Scotiabank’s culture is one of collaboration and respect, where each team member’s contribution is valued. Engage in meaningful work that challenges you to leverage your skills and push the boundaries of what’s possible in the banking sector. Our innovative projects not only support the growth of the company but also ensure our position as a leader in the industry.

Benefits and Growth

Choosing a career at Scotiabank means opting for a life of growth and opportunity. Our employees enjoy competitive benefits, including comprehensive health coverage, retirement plans, and flexible working conditions, all designed to support your career and personal life. We believe in nurturing our team’s potential by providing them with the tools they need to succeed both professionally and personally.

Join Our Team

Ready to take the next step in your career? Explore the job opportunities at Scotiabank by searching our open positions that match your skills and interests. We are continuously hiring and looking for passionate, curious, and solution-driven team players.

Networking and Professional Development

Stay connected and advance your career through Scotiabank’s extensive networking opportunities. Participate in events that connect you with other professionals and leaders within the industry. Our career resources will help you prepare your resume, ace your interviews, and land the job that best suits your career goals.

Stay Ahead

Keep up to date with the latest in career tips, industry insights, and company news—all from the people who work here at Scotiabank. Personalize your experience by subscribing to job alert emails tailored to your preferences and be the first to know about new openings and exciting developments. Join Scotiabank and be part of a team that values integrity, respect, and accountability. Discover how your career can flourish in an environment committed to your professional development and personal growth.
Learn more about Scotiabank
Size
90,619 employees
Market Cap
$57.5 billion
Industry
Finance & Insurance
5 Year Trend
+7%
NASDAQ
BNS
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Scotiabank

More Information Technology Jobs

Find similar Programmer Analyst Advisory jobs:

NationwideToronto, ON