This job board retrieves part of its jobs from: Emploi Étudiant | Toronto Jobs | Work From Home

Tech jobs every day in Canada!

To post a job, login or create an account |  Post a Job

   Canadian Tech jobs   

Website updated every day with fresh jobs in the IT industry

previous arrow
next arrow


Sr ETL Developer – w/e in Sql Server, powershell scripting, Kafka/Elastic Search and data schemas – 19204

S.i. Systems

This is a Contract position in Revelstoke, BC posted April 30, 2021.

Sr ETL Developer
– w/e in Sql Server, powershell scripting, Kafka/Elastic Search and data schemas
– 19204 Contract Duration: 8 months Location: WFH (Downtown Torontom when BCP Lifted) Business Line: The GWRT Securities Group is looking for a Real Time Event Driven ETL Developer Project: The group is working on multiple initiatives supporting Real time trade booking integrations to centralize the book platforms used for Upstream trading.

Candidate Value Proposition: The successful candidate will have an opportunity to leave a lasting impact on the banks real time processing while utilizing new technology in an Agile environment.

Typical Day in Role:
• Provide expert-level technical solutions and support to a vendor integrated product.

• Committed full-stack developer that is capable of delivering code with high degree of quality and speed; design and maintain test suites to ensure high quality.

• Investigate and troubleshoot with great thoroughness to provide accurate and quick feedback or workaround to the business.

• Self-disciplined developer that can provide strong architect design meeting all functional, non-functional and security requirements;
• Research and explore proof of concepts for ideas to grow the value of the product;
• Own technology excellence with hands-on approach to keep current on the application technology stack;
• Collaborate with various teams from technical and business background to optimize the product to magnify the utilization;
• Acknowledge and follow agile mindset and scrum framework with the strong team mindset.

• Matured team member that can provide guidance to peers, and ensure knowledge is well organized inside the team.

Must have skills: 1.

ETL Development 2.

5 years’ experience with designing, administering, tuning and troubleshooting SQL Servers.


Minimum 3 years’ experience with PowerShell scripting .


Minimum 1 Project working with integration platforms such as Kafka, ElasticSearch, MQ.


5 years’ experience using data schemas in XML, JSON, (AVRO, CSV, added bonuses) 6.

Experience using 1 or more collaboration tools such as JIRA (used for submitting tickets), Confluence (knowledge sharing) , or similar Azure DevOps tools.


3 years’ experience in FinTech , Canadian banking or other capital markets knowledge.

Nice to have skills:
– Unix Shell scripting.

– Testing tools like NUnit and Selenium.

– end to end development with testing including NUnit / Selenium
– having ability to learn and desire to learn quickly
– Docker and in developing/deploying/testing/running applications in a Cloud environment.

Experience with source control tools such as Git, BitBucket, SVN.

– Knowledge of building secured applications conforming to enterprise architecture standards like SFTP, TLS, certificate, authentication, authorization etc.

– nice to have Soft skills:
• Strong verbal and written communication skills with the ability and confidence to interpret and explain complex technology concepts in simple terms to any level business user, director, or VP.

– Windows environment
• Strong analytic skills in both technology and business areas.

– will be speaking with traders
– will have direct contact with will need to be able to communicate with business
– specifically for concepts, ideas and patterns (a lot of shared design sessions take place)
– will need to be able to justify Interview Process: 1 Interview (conducted through Microsoft Teams)
– combination of technical behavioral questions (will likely share screen for some potential coding questions related to process and approach)
– IV will include small panel (Hiring manager, lead developer/ architect senior developers, potentially BAs) Additional Notes:

– 60-70% of time will use PowerShell for windows-based scripting
– Strong troubleshooting skills in production support.

– 20% of role
– Kafka/Elastic Search
– Hadoop used for integration
– Over service bus layer is critical with JSON
– Imperative resource understands capital markets domain and products / asset classes
– so they can work with traders as needed
– Team operates in classic in Agile / Scrum Approach
– heavy focus on CI
– DevOps methodologies
– key metrics including deployment frequencies, lead times (affiliated to sprints)
– Resume preferences: not looking for laundry list of experience but rather what they do (what are they proud of
– projects
– how did they automate
– how did they save from a time/ efficiency perspective) o Looking at what they did
– what they did, how they did it, what was the result (CAR Model)
– how did you improve the project
– ETL Developer with exp.

with .NET
– take away
– (knowledge of data models, schemas, data structures will be important to be successful)
– no new data models
– but understands to work with them
– and understands the performance of data models (example: will have to understand what this means when you join to many tables in query)

– Looking to hire: Confirmations Space within Capital Markets.

Small Agile, lean team that work closely together.

– Platform
– is a real time platform supporting trade booking (Data Integration Layor)
– purpose is to generate legal documents (interface between trade bookings legal documentations) Vendor based platform (WSI
– Exceptor) -focuses on integration of vendor platform into functionality
– very data centric
– with an AI component (focus on data correctness)

– developer will be building out the scalable pattern to be extended to other source systems (could be for different products including Murex

– 80-90% pure project development
– cross functional team (support multiple areas
– will also be testing codes
– 100% integration (50% of time is focused on automation testing)10-20% will be supporting solution (team will need to understand the functionality);
– Minimum 1 project building web-based applications in both the front and back end: HTML, CSS, JavaScript, Angular, TypeScript.

– 20% of role will support back end applications