ETL Developer
Location Address: WFH, followed by Toronto (subject to change)
Contract Duration: Start ASAP to 10/31/2022
Extension: Possible
Number of Positions: 1
Schedule Hours: 9am-5pm, Monday-Friday
Story Behind the Need
• Business group: FCORE (previously FCRMT) – Application Development
• Project: Application is called “Name Screening Application”, and it uses a vendor product from Accuity. SQL server is used as a database and SSIS as ETL tool.
• Reason for request: Onboarding for NS Enhancement, IB and Party Master Project
Candidate Value Proposition
– The successful candidate will have exposure to AML area where they will be able to interact with relevant stakeholders.
Typical Day in Role
• Analyze highly complex business requirements; generate technical specifications to design or redesign complex software components and applications
• Act as an expert technical resource for modeling, simulation and analysis efforts
• 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
Candidate Requirements/Must Have Skills:
• 5+ years of technical working experience with MS-SQL/Oracle, SSIS to develop, test, and debug ad-hoc queries, stored procedures, and data migration scripts (MOST CRITICAL REQUIREMENT)
• 2 years+ of experience with Windows & Linux OS (for infrastructure migration projects).
• Hands on experience in following the iterative and agile SDLC?
• 2 years+ of experience working with .Net
• Demonstrate understanding of ETL (Extract, Transform, Load) strategies and design, (staging environments, data transformation, slowly changing dimensions, etc…), with an ability to support and maintain the entire IT processes for the Business.
Nice-To-Have Skills:
• An asset to have technical working experience in the banking / financial services industries.
• Also, asset to have technical working experience in the use of Java/J2EE, Fircosoft Tool (Accuity) & basic knowledge of Servers and Network Connections.
Soft Skills:
• Creative, self-starting, results oriented and highly motivated individual with very good analytical skills in order to apply this knowledge to resolve business problems.
• Good attitude
Best vs Average: Contractor attitude is very important. Willingness to learn is valued more so than an abundance of previous experience/knowledge. The candidate will not need hand holding and can begin to develop based on requirements.
Degrees or certifications:
• Bachelor's degree in a technical field such as computer science, computer engineering or related field required
Candidate Review & Selection
• Structure and Format: One round with HM + tech leader
• Availability to interview: ASAP, HM can interview until the furlough period begins (Dec 22nd)