Job Information
Scotiabank Software Developer - ETL in Toronto, Ontario
Software Developer - ETL
Requisition ID: 200788
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
Reporting to the Senior Manager, you are responsible for the requirements gathering, turn business requirements into data model and coded into our environment. An active collaborator on the Agile project team, you are responsible for driving the full software development lifecycle (SDLC) from the beginning to the completion of the projects, also you will follow up with the troubleshooting of any production issues reported and fix if required, any further enhancements and ensure working products are delivered with quality.
Is this role right for you? In this role you will:
Analyzes & acquires data from primary and secondary data sources – creating mapping specifications for use by development resources
Participate in detailed discovery of data from the source, mapping the data to the data model after thorough analysis.
Work with Business representatives and partner to understand requirements support the development of the ELT work.
Evaluation of data identified from multiple sources, reconcile conflicts and classification of data in logical categories
Build expertise in various data domains and take ownership of assigned data domains and be a single point of contact
Documents, plans for collection, data cleansing, and normalization of data
Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats
Do you have the skills that will enable you to succeed in this role? We’d love to work with you if you have:
Ideally 5+ years’ experience in Informatica and DataStage
2+years of Unix and Windows Shell Scripting
Highly analytical and good understanding of databases, technical architecture, and query tools
Experience in working with SQL and NoSQL tools
Advance knowledge of writing complex SQL queries
Advanced skills using Excel spreadsheet
Experience working in Agile/ Lean delivery teams
Ability to adapt and quickly adjust to change
Ability to work with cross functional teams
Should be a team player and work collaboratively
Excellent verbal, written and presentation skills
Troubleshoot and resolve database and application defects in a timely manner with consultation with internal and external groups as needed.
Train and assist users at all levels.
Analyze root causes of operational malfunctions including but not limited to batch jobs and provide resolutions.
Analyze highly complex business requirements; generate technical specifications to design or redesign complex software components and applications.
Act as an expert technical resource in Data Warehouse/DBs and ETL
Leverage industry best practices to design, test, implement and support a solution.
Assure quality, security and compliance requirements are met for supported area.
Be flexible and thrive in an evolving environment.
Adapt to change quickly and adjust work accordingly in a positive manner.
On-call responsibilities to operate as the L2 point of contact for monitoring TIDAL/EDL jobs requests may be required for weekends rotation
Independently support existing applications and resolve issues.
Experience with SAS or Talend applications
Familiarity with JIRA/SharePoint
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.
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, pleaseclick here (https://www.scotiabank.com/careers/en/careers/technical-support-for-applicants.html) . 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.