Requisition ID: 259874
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
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
Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.
At Scotiabank, 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. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. 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.
