Etl lead vs datastage developer

The differences between etl leads and datastage 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 lead, becoming a datastage developer takes usually requires 2-4 years. Additionally, an etl lead has an average salary of $106,442, which is higher than the $89,821 average annual salary of a datastage developer.

The top three skills for an etl lead include sql server, architecture and data warehouse. The most important skills for a datastage developer are sql server, database, and unix.

Etl lead vs datastage developer overview

	ETL Lead	Datastage Developer
Yearly salary	$106,442	$89,821
Hourly rate	$51.17	$43.18
Growth rate	9%	21%
Number of jobs	31,461	80,648
Job satisfaction	-	-
Most common degree	Bachelor's Degree, 71%	Bachelor's Degree, 77%
Average age	43	39
Years of experience	6	4

Etl lead vs datastage developer salary

Etl leads and datastage developers have different pay scales, as shown below.

	ETL Lead	Datastage Developer
Average salary	$106,442	$89,821
Salary range	Between $83,000 And $135,000	Between $70,000 And $114,000
Highest paying City	San Francisco, CA	San Francisco, CA
Highest paying state	Washington	California
Best paying company	NerdWallet	Macy's
Best paying industry	Health Care	Health Care

Differences between etl lead and datastage developer education

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

	ETL Lead	Datastage Developer
Most common degree	Bachelor's Degree, 71%	Bachelor's Degree, 77%
Most common major	Computer Science	Computer Science
Most common college	Massachusetts Institute of Technology	-

Etl lead vs datastage developer demographics

Here are the differences between etl leads' and datastage developers' demographics:

	ETL Lead	Datastage Developer
Average age	43	39
Gender ratio	Male, 74.2% Female, 25.8%	Male, 70.5% Female, 29.5%
Race ratio	Black or African American, 8.2% Unknown, 4.9% Hispanic or Latino, 9.6% Asian, 25.6% White, 51.4% American Indian and Alaska Native, 0.2%	Black or African American, 4.5% Unknown, 4.8% Hispanic or Latino, 8.2% Asian, 34.2% White, 48.1% American Indian and Alaska Native, 0.2%
LGBT Percentage	8%	8%

Differences between etl lead and datastage developer duties and responsibilities

Etl lead example responsibilities.

Manage the issues raise from QA and assign work items to the team and take up critical work items.
Lead defect review meetings with business team leads as well as QA lead and prioritize development tasks around project milestones.
Involve in writing UNIX shell scripts and automate the sessions running processes and also write UNIX Perl scripts for business needs.
Provide technical leadership and manage all aspects of the SDLC process-requirement analysis, design, development, testing, and support/maintenance.
Administrate SharePoint database access; manage classified documents and applications.
Involve in writing TeraData scripts.

Datastage developer example responsibilities.

Create and manage multiple development and test database environments, often work as a backup DBA.
Experience using peek stage by the means of outsourcing data to the job log which leads to debugging of jobs.
Manage continuous integration, configure the servers using Jenkins.
Involve in SQL & PL/SQL programming for procedures, functions, packages to extract data from various source systems.
Identify business rules for data migration and perform data administration through data models and metadata.
Involve in implementation of UNIX shell scripts to copy files among different servers and to invoke PL/SQL scripts, DataStage jobs.

Etl lead vs datastage developer skills

Common etl lead skills

SQL Server, 6%
Architecture, 5%
Data Warehouse, 5%
Unix, 5%
Data Quality, 4%
Informatica Powercenter, 4%

Common datastage developer skills

SQL Server, 8%
Database, 8%
Unix, 7%
Data Warehouse, 5%
Datastage ETL, 5%
Aggregator, 3%