Informatica consultant vs informatica etl developer

Differences between informatica consultant and informatica etl developer 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

Informatica etl developer example responsibilities.

• Support and maintain production Cognos web portal to manage the OLAP cube and folders.
• Used various transformations like expression, union, source qualifier, aggregator, router, store procedure, lookup transformations.
• Work on transformations such as source qualifier, joiner, lookup, rank, expression, aggregator and sequence generator etc.
• Work with relational databases like DB2.
• Develop mappings with XML as target and formatting the target data according to the requirement.
• Work with logical, physical, conceptual, star, snow flake schema data models.
Show more