Geekly Articles each Day
📜 ⬆️ ⬇️

C ++, FIX, Oracle and PL / SQL: what an IT specialist needs to know to get a job in finance + real job opportunities

image

Nowadays, most exchanges have long been working in electronic format, and transactions are not made with the help of traders shouting from a special hole, but in a couple of clicks via the Internet. To organize bidding and participate in them, advanced software, hardware is used, sophisticated algorithms and original approaches to data analysis and processing are developed.

Also in the field of finance, usually quite good salaries. All this leads to the fact that this industry has become attractive to many IT-specialists. Let’s talk about what kind of specialists are in demand today, what kind of knowledge you need to have in order to get a job here, what kind of projects they can offer you.
')
Bonus: links to real jobs!

Common programming languages


Let's start with aspects related directly to products for exchange trading. Most of the infrastructure of exchanges and brokerage companies is created using the C ++ language. The creator of the language, Bjarne Stroustrup, is still working at Morgan Stanley Investment Bank as Director of Technology.



The tool he created is used to create a wide variety of software - from libraries for calculating price models of derivatives to data processing modules

In addition to C ++, C # and Java are widespread - with their help they often implement certain parts of trading applications or front-end services of financial companies (for example, GUIs of trading terminals).

Scripting languages ​​such as Python, MATLAB and R are also used to describe trading strategies and prototyping models. Scripting languages ​​are also popular, which can even be built into trading terminals, such as TradeScript, with which trading robots can be written directly inside the SMARTx terminal.



A simple TradeScript strategy recorded in the trading terminal window

Developers with knowledge of these languages ​​will always find interesting projects in the field of finance.

In addition, according to surveys, there is a demand for Python developers - this language is indispensable for creating analytical tools and quantum models. In addition, you can find projects that use data processing technologies like Hadoop, Cassandra and Scala.

Data transfer protocols


Developers of financial applications will not be able to do just a well-known technology stack, they will have to face the specifics of the industry. The most basic thing that will have to be mastered is financial data transfer protocols.

We wrote about those that are used on the Russian market, a series of articles ( one , two , three , four ). It is important to say that some of these protocols are international standards, but there are proprietary protocols that are used by specific exchanges and companies. Therefore, if you plan to move to work abroad in the future, then you will most likely have to get acquainted with new protocols like ITCH and OUCH with the American Nasdaq.

Not only trading applications


Each company has its own requirements, but some trends in this direction can also be formulated. Specialists in working with infrastructure will not have to seriously rebuild when moving into the field of finance. For example, developers of back-office systems need to be able to work with popular DBMSs - Oracle and the PL / SQL language are popular in the Russian market, and MS-SQL is also often used.

Job example :


Developer Back Office

Duties:


  • Development and support of integration solutions for the back office system;
  • Development of reports for the back office;
  • Participation in other integration projects of the IT department;
  • Application migration to APEX.

Requirements:


  • Higher technical education;
  • Work experience not less than 5 years;
  • Good knowledge of PL / SQL;
  • Experience in query optimization;
  • Oracle administration skills;
  • Experience in developing applications using Oracle SQL, PL / SQL, Oracle APEX
  • Web Services Development Experience;
  • Knowledge and development experience in MS-SQL will be a plus;
  • English is sufficient for reading documentation, conversational will be a plus;
  • Knowledge of the subject area of ​​trading and securities accounting will be a big plus.

Send letters and resume to job@iticapital.ru .

A separate area is the development of databases that are actively used in finance. Here, the plus is knowledge of specialized platforms, for example backQORT. Necessary and knowledge of SQL, T-SQL and the ability to work with MS SQL Server. Since much is “tied” to this product, knowledge of MS SQL Server Reporting Service, MS SQL Server Integration Services is usually a plus.

Job example :


Oracle Developer (PL / SQL, Oracle APEX)

Duties:


  • Development and support of the functionality of the back office system of the organization;
  • Development of reports for the back office;
  • Participation in integration projects of the IT department;
  • Application migration to APEX;

Requirements:


  • Higher technical education;
  • Work experience not less than 5 years;
  • Experience in developing applications using PL / SQL and good knowledge of PL / SQL;
  • Experience in query optimization;
  • Oracle administration skills;
  • Development skills in Oracle APEX;
  • English is sufficient for reading documentation, conversational will be a plus;
  • Knowledge of the subject area of ​​trading and securities accounting will be a big plus;

Send letters and resume to job@iticapital.ru .

A separate and rather large layer of projects is the development of mobile applications for online trading. ITI Capital has its own mobile applications - earlier we talked about the evolution of the interfaces of these terminals from the beginning of the 2000s to the present day.

What projects can you work on


The easiest way to understand what projects can be encountered in the field of finance, considering real examples. For example, we at ITI Capital are developing our own trading system MATRIX , the SMARTx terminal - a separate area of ​​work is associated with optimizing its performance - is developing an API for our infrastructure called SMARTcom .

image

SMARTcom API Documentation Screenshot

Conclusion


In the field of finance, specialists in various fields are in demand. Here you can find work both in junior positions and become a leading expert in some interesting project.

To summarize, then developers to work in financial companies will require knowledge of OOP and standard algorithms. The development of client-server financial systems also goes hand in hand with multi-threaded programming. Developers who know not only C ++, but also lower-level languages, up to assembler, are greatly appreciated.

Systems for the financial sector are based on databases, therefore, specialists who know SQL and Oracle well are in demand. You need to be able to work with storage procedures, deal with indexes, and various types of locks.

Do not forget about the technological knowledge that applies specifically to the financial sector - before you look for work in a financial company (in a broker or on the stock exchange), you should study the existing data transfer protocols and related technologies.

Bonus: more IT vacancies from ITI Capital (only for Habr audience)


Head of Service Desk (Head of Technical Support)

Duties:


  • Organization work of the 1st and 2nd lines of the global HelpDesk IT (London and Moscow);
  • Implementation of the Service Desk system;
  • Construction, control and automation of key IT processes using international practices of ITIL and MoF;
  • Service Desk Management
  • KPI development within the service model
  • SLA development as part of a service model
  • Interchangeability with the IT manager of the London office for the support of office workers in the UK

Requirements:


  • Higher technical education;
  • Work experience not less than 10 years;
  • Fluency in English;
  • Experience in managing the technical support department;
  • Experience in an international investment company;
  • Experience in project management;
  • Experience in conducting IT trainings for company management
  • Experience in organizing IT support during various events organized by the company (for example, conferences for investors, a meeting of shareholders and so on).
  • The experience of replacing a regional IT manager in an English-language office
  • ITIL knowledge
  • Knowledge of Microsoft Windows
  • MacOS knowledge
  • Service Desk Implementation Experience
  • Experience in implementing IT resource management systems
  • Experience in implementing and supporting corporate portal systems and electronic application systems.


IT Security Officer
  • Review and development of security framework, information security policies, processes / procedures and guidelines on an ongoing basis.
  • Administer compliance with these policies / procedures through ongoing security reviews and audits, not limited to log analysis and security assessment of IT systems
  • Review and approve PAM (Privilege Access Management) requests
  • Develop strategies to respond to and recover from security breaches
  • Ensure IT and security compliance with local regulatory requirements and laws
  • Identify IT security risks including IT business application and infrastructure projects
  • Conduct security assessments for business application and infrastructure projects
  • Undertake new security projects to improve the security controls, efficiency and ease of use
  • Assist in Conducting periodic network scans, penetration testing, simulating attacks on systems to find exploitable weaknesses
  • Investigate security breaches
  • Support IT audits at global and branch level.
  • Be the point of contact to assist and advise customers for IT security-related matters

Key competencies & qualifications


  • Ideal candidate profile would be Bachelor's degree in information technology / Computer Engineering / Computer Science or related discipline
  • In depth knowledge of Network firewalls, VPN & Security products
  • In depth knowledge in anti-virus software, intrusion detection, firewalls and content filtering
  • Knowledge of risk assessment tools, technologies and methods
  • Experience of vulnerability and penetration testing
  • Professional Certifications: CISSP / CISM / CISA / MCSP / CCSK / CCSP is preferred
  • Strong analytical and critical thinking skills and meticulous attitude.
  • Able to work independently or in a team with minimal supervision
  • Extensive experience in working collaboratively across global teams and to lead others through problem solving challenges.
  • Strong communication skills, both verbal and written are essential.
  • Previous working experience with financial organization in a similar capacity is desirable


Send letters with a story about yourself to job@iticapital.ru . Thanks for attention!

Source: https://habr.com/ru/post/461535/

More articles:


All Articles