Post job

Etl consultant vs oracle functional consultant

The differences between etl 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 an etl consultant and an oracle functional consultant. Additionally, an oracle functional consultant has an average salary of $97,036, 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 oracle functional consultant are gap analysis, test scripts, and ERP.

Etl consultant vs oracle functional consultant overview

ETL ConsultantOracle Functional Consultant
Yearly salary$89,422$97,036
Hourly rate$42.99$46.65
Growth rate9%9%
Number of jobs53,28346,331
Job satisfaction--
Most common degreeBachelor's Degree, 74%Bachelor's Degree, 67%
Average age4343
Years of experience66

Etl consultant vs oracle functional consultant salary

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

ETL ConsultantOracle Functional Consultant
Average salary$89,422$97,036
Salary rangeBetween $69,000 And $115,000Between $74,000 And $126,000
Highest paying CityPalo Alto, CASan Francisco, CA
Highest paying stateHawaiiCalifornia
Best paying companyQ.E.D. SystemsJPMorgan Chase & Co.
Best paying industryInsuranceHospitality

Differences between etl consultant and oracle functional consultant education

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

ETL ConsultantOracle Functional Consultant
Most common degreeBachelor's Degree, 74%Bachelor's Degree, 67%
Most common majorComputer ScienceComputer Science
Most common college--

Etl consultant vs oracle functional consultant demographics

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

ETL ConsultantOracle Functional Consultant
Average age4343
Gender ratioMale, 69.5% Female, 30.5%Male, 67.9% Female, 32.1%
Race ratioBlack 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, 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 etl consultant and oracle functional consultant 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.
  • 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

Etl consultant vs oracle functional consultant skills

Common etl consultant skills
  • Data Flow, 6%
  • Informatica Powercenter, 6%
  • Unix, 5%
  • Extract Data, 5%
  • PL/SQL, 5%
  • Data Warehouse, 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