Oracle senior developer vs informatica etl developer

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

Oracle senior developer example responsibilities.

• Create and manage new BackOffice and FrontOffice processes, running in OLTP base environment.
• Coordinate with the team of java developers to accomplish complex financial calculations.
• Develop PL/SQL packages, procedures, functions, SQL queries to assist in JAVA coding according to application requirements.
• Work on loading data into the database using PL/SQL and SQL loader calling UNIX scripts to download and manipulate files.
• Develop SSRS reports and SSIS packages for an internal system design for a self-insure health care company.
• Work in the Linux environment to compile code and place into client directory.
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