Educational requirements: Bachelor
English requirements: Competent English
Requirements for skilled employment experience for years: 3-5 years
Required residence status: Temporary visa, Permanent resident, Citizen
Accept remote work: unacceptable
The role:
• Participate in requirements analysis, familiarize with existing code base and understand current architecture to provide software solutions and/or fixing issues. • Translate data requirements to technical solutions • Write clean, scalable code/stored procedures in MS SQL. • Test and deploy applications and systems • Revise, update, refactor and debug code • Improve existing software • Develop documentation throughout the software development life cycle (SDLC) • Respond to requests from business / stakeholders and record them in timely fashion using enterprise tools. • Perform advance database queries using SQL • Resolution of assigned task in a timely fashion and escalation where necessary. • Maintain and follow appropriate standards.
Mandatory Skills Description:
• The ideal candidate will have strong track record of data analysis and writing advance SQL queries/stored procedure in complex large-scale applications and transformations. You will have exceptional technical, analytical and operational skills. • 5 years of experience as a SQL developer in Microsoft environment. • Highly advanced technical knowledge of writing complex queries/stored procedures. • Excellent understanding of data architecture and advanced data analysis skills • Ability to translate requirements to data-based solutions including fetching and merging data from various sources, complex calculation and data transformation. • Good communication skills. Must be able to understand requirements and explain technical solutions to business stakeholders and the team. • Excellent troubleshooting and analytical skills. Able to investigate, analyse and troubleshoot tasks. • Advance experience in query optimization. • Familiarity with SSI packages for integration and execution of the stored procedure.
Nice-to-Have Skills:
• Basic knowledge of click view and control M is beneficial but not mandatory. • A track record working as a developer in the Financial Service Industry and/or Treasury function or exposure to loans, interest rates, balance sheet related applications/datasets is desirable but not mandatory.
