Strong knowledge in Oracle-SQL and Oracle-PL/SQL.
Strong working experience in Oracle-SQL and Oracle-PL/SQL in either OLTP or Data Warehousing Applications.
Ability to write and design complex SQL-Queries, Views, Procedures, Functions and Packages.
Good knowledge on Data Warehousing and ETL concepts and ability to work on huge volume of data.
Good understanding on Oracle Architecture for performance enhancement of jobs and transactions.
Willingness to learn new ETL and Reporting tools.
Good to have skills:
Data Modelling experience in any Data Modelling tools like ERWIN or Oracle SQL Developer Data Modeller.
Any scripting experience like Shell, Perl or Python.
Release Management Experience.
Experience in any scheduling tools like Control-M.