DB2 SQL Developer

- 5-7 years of hands-on experience in DB2 or Oracle Databases.

- Strong background in database programming using SQL/PLSQL i.e., stored procedures, functions, triggers, and packages is required.

- Good understanding of database concepts i.e., normalizations/de-normalizations, schemas, table spaces, temporary tables, views, indexes, sequences, partitioning etc. is required.

- SQL Tuning techniques to prevent performance degradation and understanding on how to use Explain Plan/Query Analyzer/Optimization Tool is required.

- Knowledge in developing and maintaining ETL processes and report using any visualization tool.

- Work with star and snowflake schemas at physical and logical level based on the data models.