Etl consultant vs etl developer

The differences between etl consultants and etl developers can be seen in a few details. Each job has different responsibilities and duties. While it typically takes 4-6 years to become an etl consultant, becoming an etl developer takes usually requires 2-4 years. Additionally, an etl developer has an average salary of $92,419, which is higher than the $89,422 average annual salary of an etl consultant.

The top three skills for an etl consultant include data flow, informatica powercenter and unix. The most important skills for an etl developer are sql server, data warehouse, and unix.

Etl consultant vs etl developer overview

	ETL Consultant	ETL Developer
Yearly salary	$89,422	$92,419
Hourly rate	$42.99	$44.43
Growth rate	9%	21%
Number of jobs	53,283	88,652
Job satisfaction	-	-
Most common degree	Bachelor's Degree, 74%	Bachelor's Degree, 76%
Average age	43	39
Years of experience	6	4

Etl consultant vs etl developer salary

Etl consultants and etl developers have different pay scales, as shown below.

	ETL Consultant	ETL Developer
Average salary	$89,422	$92,419
Salary range	Between $69,000 And $115,000	Between $72,000 And $118,000
Highest paying City	Palo Alto, CA	San Francisco, CA
Highest paying state	Hawaii	Washington
Best paying company	Q.E.D. Systems	Meta
Best paying industry	Insurance	Health Care

Differences between etl consultant and etl developer education

There are a few differences between an etl consultant and an etl developer in terms of educational background:

	ETL Consultant	ETL Developer
Most common degree	Bachelor's Degree, 74%	Bachelor's Degree, 76%
Most common major	Computer Science	Computer Science
Most common college	-	Massachusetts Institute of Technology

Etl consultant vs etl developer demographics

Here are the differences between etl consultants' and etl developers' demographics:

	ETL Consultant	ETL Developer
Average age	43	39
Gender ratio	Male, 69.5% Female, 30.5%	Male, 68.0% Female, 32.0%
Race ratio	Black or African American, 8.5% Unknown, 4.9% Hispanic or Latino, 9.6% Asian, 25.5% White, 51.3% American Indian and Alaska Native, 0.2%	Black or African American, 4.3% Unknown, 4.7% Hispanic or Latino, 8.0% Asian, 35.2% White, 47.7% American Indian and Alaska Native, 0.2%
LGBT Percentage	8%	8%

Differences between etl consultant and etl developer duties and responsibilities

Etl consultant example responsibilities.

Support and maintain production Cognos web portal to manage the OLAP cube and folders.
Experience in developing procedures, functions, packages, triggers, views and cursors for enforcing the business rules using PL/SQL.
Create packages to convert flat file to XML file.
Work with XSD and XML files generation through ETL process.
Work with the QA team on fixing defects in global and regional jobs.
Involve in writing the DB2 SQL queries make the performance in the query level.

Etl developer example responsibilities.

Support and maintain production Cognos web portal to manage the OLAP cube and folders.
Implement Perl scripts to load the financial information and to automate frequent reports for the users.
Coordinate with DBA in creating and managing table, indexes, table spaces, triggers, dB links and privileges.
Migrate the jobs from DataStage 8.1 to 8.7 and the environment from AIX to LINUX.
Export data from HDFS environment into RDBMS using Sqoop for report generation and visualization purpose.
Develop PL/SQL package for conversion of legacy notes associate with a service request using service request API.

Etl consultant vs etl developer skills

Common etl consultant skills

Data Flow, 6%
Informatica Powercenter, 6%
Unix, 5%
Extract Data, 5%
PL/SQL, 5%
Data Warehouse, 5%

Common etl developer skills

SQL Server, 7%
Data Warehouse, 6%
Unix, 5%
Data Analysis, 4%
BI, 4%
Data Quality, 4%