The table below looks at the statistics for OLTP skills in IT jobs advertised for the City of London region. Included is a guide to the average salaries offered in IT jobs that have cited OLTP over the 3 months to 3 September 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
3 Sep 2015
Same period 2014 Same period 2013
Online Transaction Processing (OLTP)
Rank 263 288 310
Rank change year-on-year
+25 +22
Permanent jobs citing OLTP 33 36 13
As % of all permanent IT jobs located in the City of London 0.35% 0.31% 0.11%
As % of the Database & Business Intelligence category 1.24% 1.07% 0.38%
Number of salaries quoted 29 28 5
Average salary £67,500 £56,000 £55,000
Average salary % change year-on-year
+20.53% +1.81%
90% offered a salary of more than £42,000 £37,000 £41,900
10% offered a salary of more than £69,300 £69,000 £68,500
UK excluding London average salary £47,500 £45,000 £50,000
% change year-on-year
+5.55% -10.00%
OLTP
London

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the City of London region.

Database & Business Intelligence Category
City of London
Permanent IT job ads with a match in the
Database & Business Intelligence category
2663 3372 3429
As % of all permanent IT jobs located in the City of London 28.08% 28.74% 28.69%
Number of salaries quoted 2276 2949 3079
Average salary £57,500 £55,000 £55,000
Average salary % change year-on-year
+4.54% -
90% offered a salary of more than £40,000 £37,500 £37,500
10% offered a salary of more than £80,000 £72,500 £75,000
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

OLTP
Jobs Demand Trend in the City of London

This chart provides a 3-month moving total of permanent IT jobs citing OLTP across the City of London region as a proportion of the total demand within the Database & Business Intelligence category.

OLTP Jobs Demand Trend in the City of London

OLTP
Salary Trend in the City of London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLTP across the City of London region.

OLTP Salary Trend in the City of London

OLTP
Salary Histogram in the City of London

This chart provides a salary histogram for IT jobs citing OLTP across the City of London region over the 3 months to 3 September 2015.

OLTP Salary Histogram in the City of London

OLTP
Top 30 Related IT Skills in the City of London

For the 6 months to 3 September 2015, IT jobs across the City of London region citing OLTP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLTP.

1 35 (72.92%) Business Intelligence
2 32 (66.67%) SQL
3 28 (58.33%) Data Warehouse
4 27 (56.25%) ETL
4 27 (56.25%) SQL Server Integration Services
5 26 (54.17%) Banking
6 25 (52.08%) Finance
7 24 (50.00%) OLAP
8 21 (43.75%) SQL Server
9 19 (39.58%) Oracle
9 19 (39.58%) C
10 18 (37.50%) SDLC
11 17 (35.42%) PL/SQL
11 17 (35.42%) Oracle Database
12 15 (31.25%) Agile Software Development
13 14 (29.17%) Cognos Business Intelligence
13 14 (29.17%) Cognos Event Studio
13 14 (29.17%) Cognos Metric Studio
13 14 (29.17%) Mentoring
13 14 (29.17%) Cognos
13 14 (29.17%) Cognos Analysis Studio
14 13 (27.08%) Linux
14 13 (27.08%) Oracle Database 11g
14 13 (27.08%) SQL Server Reporting Services
15 10 (20.83%) Oracle OLAP
15 10 (20.83%) Performance Tuning
16 9 (18.75%) Oracle Database 12c
16 9 (18.75%) SQL Server Analysis Services
16 9 (18.75%) Data Architecture
16 9 (18.75%) Waterfall

OLTP
Top Related IT Skills in the City of London by Category

For the 6 months to 3 September 2015, IT jobs across the City of London region citing OLTP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLTP. Up to 20 skills are shown per category.

Application Platforms
1 2 (4.17%) Tomcat
Applications
1 3 (6.25%) MS Excel
Business Applications
1 14 (29.17%) Cognos Business Intelligence
2 8 (16.67%) Oracle Applications
Cloud Services
1 1 (2.08%) Amazon AWS
Communications & Networking
1 2 (4.17%) Internet
1 2 (4.17%) SSH
Database & Business Intelligence
1 28 (58.33%) Data Warehouse
2 27 (56.25%) SQL Server Integration Services
3 24 (50.00%) OLAP
4 21 (43.75%) SQL Server
5 17 (35.42%) Oracle Database
6 14 (29.17%) Cognos Analysis Studio
6 14 (29.17%) Cognos Event Studio
6 14 (29.17%) Cognos Metric Studio
7 13 (27.08%) Oracle Database 11g
7 13 (27.08%) SQL Server Reporting Services
8 10 (20.83%) Oracle OLAP
9 9 (18.75%) Data Mining
9 9 (18.75%) SQL Server Analysis Services
9 9 (18.75%) Oracle Database 12c
10 8 (16.67%) Cognos Query Studio
10 8 (16.67%) Cognos Report Studio
11 6 (12.50%) SQL Server 2008
12 5 (10.42%) Oracle BI EE
13 4 (8.33%) Relational Database
13 4 (8.33%) PowerCenter
Development Applications
1 7 (14.58%) Git (software)
2 5 (10.42%) Team Foundation Server
2 5 (10.42%) Subversion
3 2 (4.17%) Maven
3 2 (4.17%) JIRA
3 2 (4.17%) Jenkins
4 1 (2.08%) Oracle Forms
General
1 26 (54.17%) Banking
2 25 (52.08%) Finance
3 8 (16.67%) Back Office
4 5 (10.42%) Legal
5 4 (8.33%) Marketing
6 3 (6.25%) Financial Institution
7 2 (4.17%) Retail
7 2 (4.17%) Billing
8 1 (2.08%) Law
Job Titles
1 33 (68.75%) Developer
2 15 (31.25%) Business Intelligence Developer
3 12 (25.00%) Lead Developer
4 10 (20.83%) Oracle Developer
5 9 (18.75%) Cognos Developer
5 9 (18.75%) Cognos BI Developer
6 8 (16.67%) SQL Developer
7 7 (14.58%) Senior Developer
7 7 (14.58%) Senior Oracle Developer
8 4 (8.33%) Support Analyst
8 4 (8.33%) Applications Support
8 4 (8.33%) Analyst
8 4 (8.33%) DBA
9 3 (6.25%) Team Leader
9 3 (6.25%) Applications Support Analyst
9 3 (6.25%) Administrator
10 2 (4.17%) Technical Architect
10 2 (4.17%) Architect
10 2 (4.17%) Data Warehouse Developer
10 2 (4.17%) Java Technical Architect
Libraries, Frameworks & Software Standards
1 8 (16.67%) XML
2 4 (8.33%) XSLT
3 2 (4.17%) JMS
3 2 (4.17%) JavaBeans
3 2 (4.17%) JAXB
3 2 (4.17%) SAX
3 2 (4.17%) JMX
3 2 (4.17%) Spring
3 2 (4.17%) XSD
3 2 (4.17%) DOM
3 2 (4.17%) XSL
3 2 (4.17%) .NET
3 2 (4.17%) J2EE
3 2 (4.17%) JSP
3 2 (4.17%) SOAP
3 2 (4.17%) Struts
3 2 (4.17%) Web Services
Miscellaneous
1 5 (10.42%) Analytical Skills
2 4 (8.33%) Data Integration
2 4 (8.33%) Replication
3 3 (6.25%) Blackberry
4 2 (4.17%) Computer Science
5 1 (2.08%) Management Information System
5 1 (2.08%) Data Structures
Operating Systems
1 13 (27.08%) Linux
2 9 (18.75%) Windows
3 5 (10.42%) UNIX
4 1 (2.08%) Red Hat Enterprise Linux
Processes & Methodologies
1 35 (72.92%) Business Intelligence
2 27 (56.25%) ETL
3 18 (37.50%) SDLC
4 15 (31.25%) Agile Software Development
5 14 (29.17%) Mentoring
6 10 (20.83%) Performance Tuning
7 9 (18.75%) Change Control
7 9 (18.75%) Data Architecture
7 9 (18.75%) Waterfall
7 9 (18.75%) Data Modelling
8 8 (16.67%) Database Security
9 4 (8.33%) User Acceptance Testing
10 3 (6.25%) Disaster Recovery
10 3 (6.25%) Data Analysis
11 2 (4.17%) Logistics
11 2 (4.17%) Software Engineering
11 2 (4.17%) Problem Management
11 2 (4.17%) Migration
11 2 (4.17%) Stakeholder Management
11 2 (4.17%) SOA
Programming Languages
1 32 (66.67%) SQL
2 19 (39.58%) C
3 17 (35.42%) PL/SQL
4 9 (18.75%) T-SQL
5 5 (10.42%) Java
6 2 (4.17%) JavaScript
6 2 (4.17%) C#
6 2 (4.17%) Python
6 2 (4.17%) Shell Script
6 2 (4.17%) Jython
6 2 (4.17%) XPath
7 1 (2.08%) VBA
Qualifications
1 8 (16.67%) OCP
1 8 (16.67%) Oracle Certification
2 3 (6.25%) IBM Certification
2 3 (6.25%) Degree
3 2 (4.17%) ITIL Certification
Quality Assurance & Compliance
1 4 (8.33%) QA
System Software
1 2 (4.17%) VMware Infrastructure
Systems Management
1 5 (10.42%) Control-M
Vendors
1 19 (39.58%) Oracle
2 14 (29.17%) Cognos
3 9 (18.75%) IBM
4 7 (14.58%) Microsoft
5 6 (12.50%) Informatica
6 5 (10.42%) Bloomberg
7 2 (4.17%) VMware
7 2 (4.17%) Siebel
7 2 (4.17%) WorldPay
8 1 (2.08%) Actian
8 1 (2.08%) ParAccel
8 1 (2.08%) Red Hat
8 1 (2.08%) Salesforce.com
City, London
BrightTALK Ltd
Salary: Competitive salary + strong benefits package
Posted: 20 hours ago
City of London
Deerfoot IT
Salary: £65000 - £72000 per annum + Banking bonus
Posted: 8 days ago
City of London
Hays IT - Uk Posting account
Salary: £65000.00 - £70000.00 per annum + package
Posted: 8 days ago