Sr. Data Integration and Development Engineer
Sr. Data Integration and Development Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Requisition ID: 235082
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.
IF:
- You are curious willing to learn committed and can think out of box.
- You have excellent communication skills and can articulate technical material in a simple manner to the business partners and implement that using the technology
- You like challenges and love to solve problems
Then we would like to hear from you.
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 Wed love to work with you if you have:
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 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
- Bachelors 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 like Arcade Bitbucket and DevOps pipeline.
- Familiarity with Jira Confluence and Service Now
- Familiarity with Agile Kanban methodology and Continuous Improvement mindset.
- Familiar with Cloud technologies like GCP or Azure and working towards or have acquired a certification.
Whats 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 - We offer opportunities for community engagement & belonging with our various programs such as hackathons.
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.
Required Experience:
Senior IC
Employment Type
Full Time
