Ssrs developer vs informatica etl developer

Differences between ssrs developer and informatica etl developer duties and responsibilities

Ssrs developer example responsibilities.

• Involve in DBA responsibilities such as managing users and permissions, creating audit triggers, and overlook the daily back up.
• Create facts, dimensions, data model, star schema representation for the data mart of OLTP and OLAP databases.
• Work with XML configuration files for deploying SSIS packages from development to production environment.
• Design and implement OLAP database utilizing star schema structure.
• Develop and support nightly batch processes for application data updates and imports on the Linux environment.
• Create drill through reports so that end users can see the TFS page of the particular work item.
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