Ssis developer vs informatica etl developer

Differences between ssis developer and informatica etl developer duties and responsibilities

Ssis developer example responsibilities.

• Manage different versions of complicate code and distribute them to different teams in the organization utilizing TFS.
• Develop an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting.
• Create routines for importing data utilizing XML, CSV and comma delimitate files.
• Filter and cleanse OLTP data with complex store procedures and SSIS packages in the staging area.
• Develop a dimensional database and OLAP cube using SSAS for analysis, maintenance and good customer service.
• Involve in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
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