Sr. Data Integration and Development Engineer

Requisition ID: 222859

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 solution that best addresses a 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 where appropriate 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 a 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 assist in post implementation shakedown testing, as required.
• Meet the SLA/SLO for incidents and project timelines.

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

• 5+ years’ IT industry experience with ETL tools like Talend, DataStage, Informatica etc.
• 3 to 5+ years’ experience with relational databases with a 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 i.e., MS Outlook, MS Word, Excel, Access, PowerPoint, and Project
• Understanding of Database environment (i.e., relational, structural, etc.)
• Familiar with Dockers, Kubernetes
• Must be Curious, Open minded, willing to learn and question the status quo as required
• Strong Communication skills (Verbal and Written) in English
• Understand the Business requirements and translate it into technical specs.
• Articulation skills to convey the message across to various stakeholders.
• Think big picture instead of tunnel vision for the initiatives you are working on.
• Bachelor's degree in a technical field such as computer science, computer engineering or related field required

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 such as hackathons, contests, cooking with friends, Humans of Digital and much more!

Working location condition: Hybrid

#LI-Hybrid  

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. If you require technical assistance, please click here. 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.