Title: DB2 SQL Developer
JD:-
- 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.