Login | Register

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

Job Type: Contract
Positions to fill: 1
Start Date: Apr 12, 2021
Job End Date: Feb 28, 2022
Pay Rate: Hourly: Negotiable
Job ID: 106095
Location: Toronto
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.
3. Minimum 3 years’ experience with PowerShell scripting.
4. Minimum 1 Project working with integration platforms such as Kafka, ElasticSearch, MQ.
5. 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.
7. 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