Post job

Senior cognos developer vs etl developer

The differences between senior cognos developers and etl developers can be seen in a few details. Each job has different responsibilities and duties. It typically takes 2-4 years to become both a senior cognos developer and an etl developer. Additionally, a senior cognos developer has an average salary of $101,368, which is higher than the $92,419 average annual salary of an etl developer.

The top three skills for a senior cognos developer include board reports, data warehouse and sql server. The most important skills for an etl developer are sql server, data warehouse, and unix.

Senior cognos developer vs etl developer overview

Senior Cognos DeveloperETL Developer
Yearly salary$101,368$92,419
Hourly rate$48.73$44.43
Growth rate21%21%
Number of jobs80,15688,652
Job satisfaction--
Most common degreeBachelor's Degree, 73%Bachelor's Degree, 76%
Average age3939
Years of experience44

Senior cognos developer vs etl developer salary

Senior cognos developers and etl developers have different pay scales, as shown below.

Senior Cognos DeveloperETL Developer
Average salary$101,368$92,419
Salary rangeBetween $79,000 And $129,000Between $72,000 And $118,000
Highest paying CityPleasanton, CASan Francisco, CA
Highest paying stateWashingtonWashington
Best paying companyGM FinancialMeta
Best paying industryFinanceHealth Care

Differences between senior cognos developer and etl developer education

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

Senior Cognos DeveloperETL Developer
Most common degreeBachelor's Degree, 73%Bachelor's Degree, 76%
Most common majorComputer ScienceComputer Science
Most common college-Massachusetts Institute of Technology

Senior cognos developer vs etl developer demographics

Here are the differences between senior cognos developers' and etl developers' demographics:

Senior Cognos DeveloperETL Developer
Average age3939
Gender ratioMale, 70.2% Female, 29.8%Male, 68.0% Female, 32.0%
Race ratioBlack or African American, 4.7% Unknown, 4.9% Hispanic or Latino, 8.5% Asian, 30.3% White, 51.5% 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 Percentage8%8%

Differences between senior cognos developer and etl developer duties and responsibilities

Senior cognos developer example responsibilities.

  • Introduce and develop OLAP dimensional analysis and eventually lead the transition of reporting from relational to dimensional.
  • Create and design DTS packages (SSIS) used for implementing the schema for the required data mart.
  • Work along with the ETL team to understand the flow of data from OLTP system to the OLAP system.
  • Tweak the Java scripts in reports to support for Cognos10.1.
  • Involve in creating Informatica transformations, scheduling jobs and data loading.
  • Create an ODS for reporting from base tables in DB2 database.
  • Show more

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.
  • Show more

Senior cognos developer vs etl developer skills

Common senior cognos developer skills
  • Board Reports, 8%
  • Data Warehouse, 6%
  • SQL Server, 5%
  • Drill-Through, 5%
  • Cognos BI, 4%
  • Master-Detail, 3%
Common etl developer skills
  • SQL Server, 7%
  • Data Warehouse, 6%
  • Unix, 5%
  • Data Analysis, 4%
  • BI, 4%
  • Data Quality, 4%

Browse computer and mathematical jobs