ETL Developer
Location Address: WFH (Toronto once restrictions are lifted)
Contract Duration: 6 months (from start date)
Extension: Yes
FTE: Yes
Number of Positions: 1
Schedule Hours: 9am-5pm, Monday-Friday
Story Behind the Need
• Business group: GWMS – Digital Client Services – Group 1
• Project: The GWMS CRM team is the Salesforce Centre of Excellence for Scotiabank. The team is currently responsible for 10 different Salesforce Orgs across multiple lines of Business and is in the process of further expanding to additional lines of Business and new geographies.
• Reason for request: In support of this growth, the team is looking for an experienced Senior Data Integration Developer to both deliver on existing initiatives and establish Business-Technology roadmaps for future initiatives.
Candidate Value Proposition
• The successful candidate will have the opportunity to work on an expansion in the international wealth management space at one of the Big Five Banks in Canada.
Typical Day in Role
• Develop ETL code and build packages based on existing standards and suggest improvements when possible
• Leading 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 and advise to the team
• Works in close collaboration with Architects and other cross functional team members in creating design documents, diagrams, technical requirements, and solutions that best address business needs
• Investigate failures, perform root cause analysis and utilize internal defect tracking tool to create detailed, high quality error report
Candidate Requirements/Must Have Skills:
• 5+ years experience ETL Development / Architect level experience with Talend for recent projects
• Professional experience with tools like Data Loader, Data Stage, Talend, Mulesoft
• Familiar with Integrating Salesforce with other cloud based application systems using REST, SOAP API
• Experience with deployment processes and release pipelines. Eg : Jenkins, Bitbucket/Git
• 5+ years experience with Core Java Development
• Ability to work in cross functional teams using agile methodologies like SCRUM/Kanban
Nice-To-Have Skills:
• Experience with large Salesforce implementations
• Previous experience in a financial institution or banking industry
Soft Skills:
• Excellent communication skills to clearly articulate integration requirements to business users. Interaction with various business lines will be imperative for success of integration
• Strong leadership skills
Degrees or certifications:
• Bachelors degree in Computer Science or equivalent required
• Salesforce certifications would be an asset
Candidate Review & Selection
• Structure and Format:
• 1st round – panel video interview (scenario-based) with HM & Senior Tech Resource & Codility assessment
• 2nd round – panel video interview (scenario-based) with HM & Senior Tech Resource
Additional notes:
• The successful candidate is expected to be able to come onboard and hit the ground running within the first two weeks
• Must haves have been ranked in order of importance