Oracle senior developer vs etl developer

Differences between oracle senior developer and 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

Etl developer example responsibilities.

• Support and maintain production Cognos web portal to manage the OLAP cube and folders.
• Implement Perl scripts to load the financial information and to automate frequent reports for the users.
• Coordinate with DBA in creating and managing table, indexes, table spaces, triggers, dB links and privileges.
• Migrate the jobs from DataStage 8.1 to 8.7 and the environment from AIX to LINUX.
• Export data from HDFS environment into RDBMS using Sqoop for report generation and visualization purpose.
• Develop PL/SQL package for conversion of legacy notes associate with a service request using service request API.
Show more