SQL Developer
We are looking for a SQL Developer! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: SQL Developer
Term: Contract – 10 months with extension
Location: Toronto – Hybrid
Industry: Banking
Job ID number: C1401
Brief Description on Duties:
Typical Day in Role
- Working with BA and project managers and essentially implementing the relationships data base objects
- Take technical descriptions and create procedures, functions, manuals, etc.
- Work with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies
- Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions
- Design, implement, automate and maintain large scale enterprise data ETL processes
- Modify existing databases and database management systems and/or direct programmers and analysts to make changes
- Test programs or databases, correct errors and make necessary modifications
Candidate Requirements/Must Have Skills:
- 8+ years of experience of SQL development – preferably within a bank or similar FI
- 3+ years of experience with Oracle RDBMS and Oracle SQL*Plus
- Recent experience with all of ServiceNow, JIRA, and Confluence is required
Nice-To-Have Skills:
- Experience with UNIX shell scripting
- Backend development (Python, C#, C++, Java, all acceptable) experience is highly preferred
- AML/ATF experience is an asset
- Spanish speaking is an asset, but not critical to success
Soft Skills
- Strong communication skills both written and verbal
- This is a very technical role, communication is not the most important aspect
- Candidate must be a team player, that does not need to be micromanaged – wants someone who can get up and hit the ground running everyone morning without necessarily being told what to do
- Ability to manage assigned tasks and expectations without direct instruction or oversight
- Fast, adaptable learner who can hit the ground running
- Ability to work well under pressure while demonstrating strong professionalism
- Must be able to collaborate closely with a team at times, while also being capable of holding themselves accountable to meet individual deadlines without hand holding
Best vs Average: Top two must-have skills are central to this role. Top profiles will have previous AML and/or Scotiabank experience, and a familiarity with internal processes. Good fits for this role are coming from roles such as: Database developers (non-administrative), Oracle developers, etc. and have a strong capacity to write database code.
Degrees or certifications:
- Bachelor’s degree or equivalent in a technical field such as computer science, computer engineering or related field required
- Any Oracle Database certifications are preferred
Job Features
Job Category | SQL Developer |