Ssrs developer vs informatica developer

Differences between ssrs developer and informatica 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 developer example responsibilities.

• Develop standalone java projects to automate many of business processes.
• Design and develop the ETL strategy to load data into targets reading from flat files and various DB2 source tables.
• Develop mappings using transformation such as source qualifier, expression, sorter, aggregator, filter, router and sequence generator.
• Verify target definitions base on star schema design and develop transformation logic for loading data into target data warehouse.
• Develop a standalone java project to upload documents from legacy system to a file server.
• Monitor health of Unix and Linux servers using to and make sure cache is reflecting latest data.
Show more