Oracle PL/SQL
1. Develop complex PL/SQL packages, procedures, functions for the application.
2. Work with the advanced features of PL/SQL like collections, nest table, ref cursors, materialize views and dynamic SQL.
3. Analyze and optimize the queries.
4. Proficient in writing complex queries and debugging the code.
5. Proficient in converting the queries from oracle to PostgreSQL.
6. Good working knowledge in oracle and PostgreSQL