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

Location
3 months to
18 Sep 2014
Same period 2013 Same period 2012
Extract, Transform and Load (ETL)
Rank 78 45 -
Rank change year-on-year
-33 -
Permanent jobs citing ETL 1 12 0
As % of all permanent IT jobs located in Portsmouth 0.26% 3.03% -
As % of the Processes & Methodologies category 0.31% 4.01% -
Number of salaries quoted 1 8 0
Average salary £31,000 £40,000 -
Average salary % change year-on-year
-22.50% -
UK excluding London average salary £45,000 £45,000 £42,000
% change year-on-year
- +7.14%
ETL
Hampshire

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised in the Portsmouth region.

Processes & Methodologies Category
Portsmouth
Permanent IT job ads with a match in the
Processes & Methodologies category
323 299 235
As % of all permanent IT jobs located in Portsmouth 83.25% 75.51% 68.31%
Number of salaries quoted 238 270 201
Average salary £40,000 £40,000 £40,000
90% offered a salary of more than £25,000 £23,500 £30,000
10% offered a salary of more than £50,000 £50,000 £60,000
UK excluding London average salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

ETL
Jobs Demand Trend in Portsmouth

This chart provides a 3-month moving total of permanent IT jobs citing ETL across the Portsmouth region as a proportion of the total demand within the Processes & Methodologies category.

ETL Jobs Demand Trend in Portsmouth

ETL
Salary Trend in Portsmouth

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing ETL across the Portsmouth region.

ETL Salary Trend in Portsmouth

ETL
Top 30 Related IT Skills in Portsmouth

For the 6 months to 18 September 2014, IT jobs across the Portsmouth region citing ETL 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 ETL.

1 4 (100.00%) Business Intelligence
2 3 (75.00%) Oracle EBS
2 3 (75.00%) Data Warehouse
2 3 (75.00%) Oracle
2 3 (75.00%) SQL Server
3 2 (50.00%) Data Modelling
3 2 (50.00%) SQL
3 2 (50.00%) Star Schema
3 2 (50.00%) Data Mart
3 2 (50.00%) SQL Server Integration Services
3 2 (50.00%) Cognos Business Intelligence
3 2 (50.00%) Release Management
3 2 (50.00%) Dimensional Modelling
3 2 (50.00%) Performance Tuning
3 2 (50.00%) Cognos Query Studio
3 2 (50.00%) Cognos Analysis Studio
3 2 (50.00%) Cognos Report Studio
3 2 (50.00%) Cognos Framework Manager
3 2 (50.00%) Cognos Metric Studio
3 2 (50.00%) Cognos Transformer
3 2 (50.00%) Cognos
4 1 (25.00%) Oracle BI Publisher
4 1 (25.00%) Oracle Payables
4 1 (25.00%) Oracle Receivables
4 1 (25.00%) Oracle E-Business Tax
4 1 (25.00%) Oracle Internet Expenses
4 1 (25.00%) Oracle BI EE
4 1 (25.00%) SQL Server 2008
4 1 (25.00%) Oracle General Ledger
4 1 (25.00%) Oracle EBS R12

ETL
Top Related IT Skills in Portsmouth by Category

For the 6 months to 18 September 2014, IT jobs across the Portsmouth region citing ETL 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 ETL. Up to 20 skills are shown per category.

Application Platforms
1 1 (25.00%) Oracle Workflow
Business Applications
1 3 (75.00%) Oracle EBS
2 2 (50.00%) Cognos Business Intelligence
3 1 (25.00%) Oracle Payables
3 1 (25.00%) Oracle Receivables
3 1 (25.00%) Oracle E-Business Tax
3 1 (25.00%) Oracle Internet Expenses
3 1 (25.00%) Oracle General Ledger
3 1 (25.00%) Oracle EBS R12
3 1 (25.00%) Oracle iProcurement
3 1 (25.00%) Oracle Applications
3 1 (25.00%) Oracle Financials
3 1 (25.00%) Oracle 11i
Database & Business Intelligence
1 3 (75.00%) Data Warehouse
1 3 (75.00%) SQL Server
2 2 (50.00%) Star Schema
2 2 (50.00%) Data Mart
2 2 (50.00%) SQL Server Integration Services
2 2 (50.00%) Cognos Query Studio
2 2 (50.00%) Cognos Analysis Studio
2 2 (50.00%) Cognos Report Studio
2 2 (50.00%) Cognos Framework Manager
2 2 (50.00%) Cognos Metric Studio
2 2 (50.00%) Cognos Transformer
3 1 (25.00%) Oracle BI Publisher
3 1 (25.00%) Oracle BI EE
3 1 (25.00%) SQL Server 2008
3 1 (25.00%) SQL Server 2012
3 1 (25.00%) Oracle Database
3 1 (25.00%) QlikView
3 1 (25.00%) Oracle Database 11g
3 1 (25.00%) SQL Server Reporting Services
3 1 (25.00%) Oracle Discoverer
Development Applications
1 1 (25.00%) JDeveloper
1 1 (25.00%) Toad
1 1 (25.00%) Oracle Forms
General
1 1 (25.00%) Finance
Job Titles
1 4 (100.00%) Developer
2 2 (50.00%) Cognos Developer
3 1 (25.00%) Oracle Developer
3 1 (25.00%) SQL Developer
3 1 (25.00%) SQL Server Developer
3 1 (25.00%) Oracle Financials Developer
3 1 (25.00%) Server Specialist
Libraries, Frameworks & Software Standards
1 1 (25.00%) Apache Flex
1 1 (25.00%) XML
Operating Systems
1 1 (25.00%) UNIX
Processes & Methodologies
1 4 (100.00%) Business Intelligence
2 2 (50.00%) Data Modelling
2 2 (50.00%) Release Management
2 2 (50.00%) Dimensional Modelling
2 2 (50.00%) Performance Tuning
3 1 (25.00%) Analytics
3 1 (25.00%) Master Data Management
3 1 (25.00%) Workflow
3 1 (25.00%) Data Management
Programming Languages
1 2 (50.00%) SQL
2 1 (25.00%) Shell Script
2 1 (25.00%) T-SQL
2 1 (25.00%) Java
2 1 (25.00%) PL/SQL
Quality Assurance & Compliance
1 1 (25.00%) Data Quality
1 1 (25.00%) SLA
Vendors
1 3 (75.00%) Oracle
2 2 (50.00%) Cognos
3 1 (25.00%) Microsoft