Post job

Informatica consultant vs functional consultant

The differences between informatica consultants and 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 informatica consultant and a functional consultant. Additionally, an informatica consultant has an average salary of $87,410, which is higher than the $85,317 average annual salary of a functional consultant.

The top three skills for an informatica consultant include java, informatica workflow and unix. The most important skills for a functional consultant are business process, prototyping, and ERP.

Informatica consultant vs functional consultant overview

Informatica ConsultantFunctional Consultant
Yearly salary$87,410$85,317
Hourly rate$42.02$41.02
Growth rate9%9%
Number of jobs35,37551,066
Job satisfaction--
Most common degreeBachelor's Degree, 72%Bachelor's Degree, 66%
Average age4343
Years of experience66

Informatica consultant vs functional consultant salary

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

Informatica ConsultantFunctional Consultant
Average salary$87,410$85,317
Salary rangeBetween $69,000 And $110,000Between $65,000 And $110,000
Highest paying CityRoseville, CASan Francisco, CA
Highest paying stateHawaiiCalifornia
Best paying companyAvtechWorkday
Best paying industryHealth CareManufacturing

Differences between informatica consultant and functional consultant education

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

Informatica ConsultantFunctional Consultant
Most common degreeBachelor's Degree, 72%Bachelor's Degree, 66%
Most common majorComputer ScienceComputer Science
Most common college--

Informatica consultant vs functional consultant demographics

Here are the differences between informatica consultants' and functional consultants' demographics:

Informatica ConsultantFunctional Consultant
Average age4343
Gender ratioMale, 69.4% Female, 30.6%Male, 71.9% Female, 28.1%
Race ratioBlack or African American, 8.5% Unknown, 4.9% Hispanic or Latino, 9.6% Asian, 25.4% White, 51.4% American Indian and Alaska Native, 0.2%Black or African American, 8.5% Unknown, 4.9% Hispanic or Latino, 9.6% Asian, 25.2% White, 51.7% American Indian and Alaska Native, 0.2%
LGBT Percentage8%8%

Differences between informatica consultant and functional consultant duties and responsibilities

Informatica consultant example responsibilities.

  • Manage an enterprise files transfer application across windows and Unix environments.
  • Manage documentation between vendor's collaboration site and Lilly to archive on collaboration SharePoint sites.
  • Analyze the source data, make decisions on appropriate extraction, transformation and loading strategies.
  • Involve in the extraction, transformation and loading of the source data to the target database.
  • Design physical data mart schema optimize for Teradata.
  • Conduct information and data analysis, ETL design, development and implementation and overall performance tuning.
  • Show more

Functional consultant example responsibilities.

  • Lead project to enhance batch and on-line system, using DB2, VSAM and DYL280.
  • Used TcpTrace to track and analyze the status of leads in SalesForce.
  • Analyze impacts and work with SME's, business partners to gather detail requirements and manage risks/ issues.
  • Design and maintain numerous data warehousing tools to automate the ETL process, data retrieval, integration and reporting functions.
  • Lead architecture, develop of predictive models & application develop of radiology-oncology executive dashboard and alerting services base on statistical calculations.
  • Act as back up for FI analyst, assisting and providing support for issues relate to GL, AP and AR.
  • Show more

Informatica consultant vs functional consultant skills

Common informatica consultant skills
  • Java, 13%
  • Informatica Workflow, 5%
  • Unix, 5%
  • SQL Server, 4%
  • PL/SQL, 4%
  • Informatica ETL, 4%
Common functional consultant skills
  • Business Process, 9%
  • Prototyping, 8%
  • ERP, 8%
  • CRM, 4%
  • Test Cases, 4%
  • Payroll, 3%

Browse computer and mathematical jobs