Sr. Data Integration and Development Engineer

Sr. Data Integration and Development Engineer Join to apply for the Sr. Data Integration and Development Engineer role at Scotiabank Requisition ID: 245135 Join a purpose driven winning team, committed to results, in an inclusive and high‑performing culture. Join a friendly, passionate, and seasoned team who is committed to deliver results in an efficient manner. The Team is responsible for Data sourcing, transformation, Integration, Quality and Availability. The team serves the customers of all Wealth business lines, including iTrade, Scotia McLeod, Private Investment Council and Scotia Trust. The team is known for excellence in delivery and support of many critical client facing and back‑office applications. Is this role right for you? In this role you will: ETL Process Analysis, Design and Development Develop ETL code and build packages as per best practices and suggest improvements when possible. Lead development efforts in ingesting and transforming data from various sources. Building scripts, writing specifications and responsible for end‑to‑end delivery of data. Develop and test code from design specifications, as well as implement and support enhancements to applications. Provide technical expertise in medium to complex projects as a Technical Lead capable of providing guidance to junior members as needed. Has some hands‑on experience working in an agile and Kanban environment and organization standards. Works in close collaboration with Technical Business Analyst, Architects and other cross‑functional team members in creating design documents, outlining overview, diagrams, technical requirements and solutions that best address business needs. Participate in technical discussions, client meetings and presentation of solutions to the technical team members as well as business. Participate in code review of peers and junior team members and recommend suggestions for improvement to ensure high quality product. ETL Processes Support, Testing & Deployment. Participate in Unit, IST, UAT, regression testing on projects as needed. Prepare test cases and test scripts and assist in creating and retrieving required test data. Provide Release Management support and facilitation, ensuring all releases are delivered efficiently and without defect. Act as liaison with other departments to create the release checklist, as required. Provide overnight and weekend support for project implementations and releases as needed (Pager support may be required). Assist in creating internal operation support manuals. Create support strategies and post‑implementation shakedown testing as required. Meet the SLA/SLO for incidents and project timelines. Communications Management. Maintain good understanding of the Division's business strategies, business policies, financial instruments, risk management and back‑office processing. Identify and communicate any impediments with practical solutions to Sr. management, downstream systems/processes. Be proactive rather than reactive. Team player. Work with established mature team members, adapt to team norms, culture and dynamic. Willing to adopt, practice agile, Kanban and scrum principles. Utilize Kanban board to manage workflow. Engage, inspire, and cultivate high performing team culture. Collaborate with team members in person and virtually from different regions in Canada and Colombia. Collaborate with various stakeholders such as product owner, business lines and QA team. Must Have Skills 5+ years’ IT industry experience with ETL tools like Talend, DataStage, Informatica etc. 3 to 5+ years’ experience with relational databases with good knowledge of SQL scripting, database structures, principles and design theories. Hands‑on experience with data integration, development using one or more tool and technologies like shell scripting, Java, AutoSys, Tidal. Familiar with Unix, Linux and Windows platforms. Experience with data sourcing, ETL and data integration. Hands‑on experience with MS Office Suite (Outlook, Word, Excel, Access, PowerPoint, Project). Understanding of database environments (relational, structural, etc.). Familiar with Dockers, Kubernetes. Bachelor's degree in a technical field such as computer science, computer engineering or related field required. Nice‑To‑Have Skills Exposure to wealth products. Wealth/financial industry exposure. Code versioning tool experience (Artifactory, Bitbucket, DevOps pipeline). Familiarity with Jira, Confluence and ServiceNow. Familiarity with Agile, Kanban methodology and Continuous Improvement mindset. Familiar with cloud technologies like GCP or Azure and working towards or having certification. 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. Accessibility and Workplace Accommodations – We value the unique skills and experiences each individual brings and are committed to creating and maintaining an inclusive and accessible environment. Upskilling through online courses, cross‑functional development opportunities, and tuition assistance. Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits from day one. Dynamic Ecosystem – Free tea & coffee, universal washrooms, and lots of space for team collaboration. Community Engagement – Opportunities for community engagement and belonging with programs such as hackathons, contests, cooking with friends, Humans of Digital and more. 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 and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation 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. Referrals increase your chances of interviewing at Scotiabank by 2x. #J-18808-Ljbffr