Senior pl-sql developer vs informatica etl developer

Differences between senior pl-sql developer and informatica etl developer duties and responsibilities

Senior pl-sql developer example responsibilities.

• Manage all phases of the SDLC from analysis, design, development, testing, implementation and maintenance.
• Create shell scripts to automate the process of generating the XML's after successful verification by the business analysts.
• Develop custom interface for executing and managing SSIS packages.
• Involve in developing, testing, compiling, debugging and maintains the data using oracle, PL/SQL, UNIX, LINUX.
• Create test cases and test reports and work with QA team to validate the data and scenarios.
• Involve in debugging various defects relate to implementation of business logic.
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