Informatica consultant vs technical consultant

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

Technical consultant example responsibilities.

• Develop several Unix scripts to automate routine operating system and application maintenance tasks.
• Lead design, development and implementation of business intelligence and ETL solutions for client organizations.
• Collaborate with developers, technical leads and management to develop technical standards for PL/SQL coding and documentation.
• Create and manage several SharePoint team sites to host, communicate and collaborate about project information and documentation.
• Provide emergency support to internal/external customers requiring the ability to effectively manage multiple tasks and rapidly troubleshoot complex applications.
• Extract, clean and validate from XML file into database using SSIS task (XML source).
Show more