Post job

Cognos consultant vs oracle functional consultant

The differences between cognos consultants and oracle functional consultants can be seen in a few details. Each job has different responsibilities and duties. It typically takes 4-6 years to become both a cognos consultant and an oracle functional consultant. Additionally, an oracle functional consultant has an average salary of $97,036, which is higher than the $91,980 average annual salary of a cognos consultant.

The top three skills for a cognos consultant include dashboards, data warehouse and sql server. The most important skills for an oracle functional consultant are gap analysis, test scripts, and ERP.

Cognos consultant vs oracle functional consultant overview

Cognos ConsultantOracle Functional Consultant
Yearly salary$91,980$97,036
Hourly rate$44.22$46.65
Growth rate9%9%
Number of jobs33,27746,331
Job satisfaction--
Most common degreeBachelor's Degree, 67%Bachelor's Degree, 67%
Average age4343
Years of experience66

Cognos consultant vs oracle functional consultant salary

Cognos consultants and oracle functional consultants have different pay scales, as shown below.

Cognos ConsultantOracle Functional Consultant
Average salary$91,980$97,036
Salary rangeBetween $73,000 And $115,000Between $74,000 And $126,000
Highest paying CityPortland, ORSan Francisco, CA
Highest paying stateCaliforniaCalifornia
Best paying companyThe News-ReviewJPMorgan Chase & Co.
Best paying industryFinanceHospitality

Differences between cognos consultant and oracle functional consultant education

There are a few differences between a cognos consultant and an oracle functional consultant in terms of educational background:

Cognos ConsultantOracle Functional Consultant
Most common degreeBachelor's Degree, 67%Bachelor's Degree, 67%
Most common majorComputer ScienceComputer Science
Most common collegeMassachusetts Institute of Technology-

Cognos consultant vs oracle functional consultant demographics

Here are the differences between cognos consultants' and oracle functional consultants' demographics:

Cognos ConsultantOracle Functional Consultant
Average age4343
Gender ratioMale, 72.9% Female, 27.1%Male, 67.9% Female, 32.1%
Race ratioBlack or African American, 8.4% Unknown, 4.9% Hispanic or Latino, 9.6% Asian, 25.3% White, 51.6% American Indian and Alaska Native, 0.2%Black or African American, 8.5% Unknown, 4.9% Hispanic or Latino, 9.6% Asian, 25.3% White, 51.5% American Indian and Alaska Native, 0.2%
LGBT Percentage8%8%

Differences between cognos consultant and oracle functional consultant duties and responsibilities

Cognos consultant example responsibilities.

  • Manage SSIS jobs for weekly and monthly refresh.
  • Implement QlikView desktop and publisher, manage user authentication, establish publisher tasks, streamline loading procedures and review log.
  • Implement different techniques in DMR cubes development to improve performance on OLAP databases.
  • Develop, test and maintain ETL procedures employing both ETL tools and custom PL/SQL.
  • Develop packages and collections using PL/SQL.
  • Experience in writing shell scripts in Unix.
  • Show more

Oracle functional consultant example responsibilities.

  • Lead team of developers to deliver key conversions like item, categories, BOM, ASL and sourcing rules.
  • Handle small-scale project to optimize and automate AP and FI processes, OSDB migration, fiscal year changes, and upgrades.
  • Participate in GL COA design, financial data conversions and user training in CRP1, CRP2 and UAT phases.
  • Review upgrade plans, test scripts, execute transactions, resolve issues, research patches and assist DBA with impact analysis.
  • Configure PeopleSoft to interact with BPEL.
  • Generate HTML format emails using UTL_SMTP utility.
  • Show more

Cognos consultant vs oracle functional consultant skills

Common cognos consultant skills
  • Dashboards, 11%
  • Data Warehouse, 9%
  • SQL Server, 6%
  • Drill-Through, 6%
  • Cognos BI, 5%
  • Windows XP, 5%
Common oracle functional consultant skills
  • Gap Analysis, 10%
  • Test Scripts, 9%
  • ERP, 8%
  • Business Process, 6%
  • Gl, 5%
  • Enterprise Solutions, 5%

Browse computer and mathematical jobs