Post job

Senior cognos developer vs senior etl developer

The differences between senior cognos developers and senior 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 a senior etl developer. Additionally, a senior etl developer has an average salary of $104,281, which is higher than the $101,368 average annual salary of a senior cognos developer.

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

Senior cognos developer vs senior etl developer overview

Senior Cognos DeveloperSenior ETL Developer
Yearly salary$101,368$104,281
Hourly rate$48.73$50.14
Growth rate21%21%
Number of jobs80,156102,293
Job satisfaction--
Most common degreeBachelor's Degree, 73%Bachelor's Degree, 74%
Average age3939
Years of experience44

Senior cognos developer vs senior etl developer salary

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

Senior Cognos DeveloperSenior ETL Developer
Average salary$101,368$104,281
Salary rangeBetween $79,000 And $129,000Between $81,000 And $133,000
Highest paying CityPleasanton, CASan Francisco, CA
Highest paying stateWashingtonWashington
Best paying companyGM FinancialeBay
Best paying industryFinanceHospitality

Differences between senior cognos developer and senior etl developer education

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

Senior Cognos DeveloperSenior ETL Developer
Most common degreeBachelor's Degree, 73%Bachelor's Degree, 74%
Most common majorComputer ScienceComputer Science
Most common college--

Senior cognos developer vs senior etl developer demographics

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

Senior Cognos DeveloperSenior ETL Developer
Average age3939
Gender ratioMale, 70.2% Female, 29.8%Male, 68.9% Female, 31.1%
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.8% Hispanic or Latino, 8.0% Asian, 35.0% White, 47.8% American Indian and Alaska Native, 0.2%
LGBT Percentage8%8%

Differences between senior cognos developer and senior 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

Senior etl developer example responsibilities.

  • Develop custom interface for executing and managing SSIS packages.
  • Create UNIX scripts to create data files and FTP it to windows/ TM1/ Linux servers for reporting.
  • Extract data from various relational databases, application systems, flat files, XML documents, and load into data warehouse.
  • Develop PL/SQL store procedures to incorporate complex business rules.
  • Experience in big data, cloud and hadoop distribute file systems HDFS.
  • Close worked and help other team members for Hadoop projects for any issues.
  • Show more

Senior cognos developer vs senior 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 senior etl developer skills
  • Data Warehouse, 6%
  • Unix, 6%
  • SQL Server, 5%
  • Informatica Powercenter, 5%
  • PL/SQL, 5%
  • Informatica Workflow, 4%

Browse computer and mathematical jobs