Senior etl tester vs informatica etl developer

Differences between senior etl tester and informatica etl developer duties and responsibilities

Senior etl tester example responsibilities.

• Manage departmental inventory and troubleshoot testing, reporting and inventory issues.
• Create and execute test cases base on test strategy and test plans base on business requirement documents and ETL design documents.
• Define data requirements and elements used in XML transactions.
• Work on WESCOM which is a web application build on Java.
• Compare query result sets from different database systems using UNIX diff command.
• Verify data integrity by back-end testing of the application by writing SQL queries.
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