Microstrategy developer vs informatica etl developer

Differences between microstrategy developer and informatica etl developer duties and responsibilities

Microstrategy developer example responsibilities.

• Develop UNIX shell scripts to automate repetitive database processes.
• Maintain and manage the LINUX server platform for effective operations of the OBIEE and ODI applications.
• Involve in creating users, groups, assigning rights to users or groups, scheduling reports, managing servers using CMC.
• Used PL/SQL procedures in different places.
• Work with creating of views in TeraData.
• Design, implement and tune interfaces and batch jobs using PL/SQL.
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