Company Profile:
IBM is a global technology and innovation company headquartered in Armonk, NY. It is the largest technology and consulting employer in the world, with more than 400,000 employees serving clients in 170 countries. IBM offers a wide range of technology and consulting services; a broad portfolio of middleware for collaboration, predictive analytics, software development and systems management; and the world’s most advanced servers and supercomputers.
Job Description:
Understanding of the business requirement, translating the business requirement to data model and further to physical data structure, Transform the business logic into Stored procedures or queries based on the complexity also considering performance.
The Developer should also posses good analytical and logical thinking. The resource should also possess good communication skill.
Skills:
1. Exceptional DB2 PL/SQL development Knowledge.
2. Exceptional SQL development Knowledge.
3. Good Data Modelling capabilities.
4. Good Query tuning capabilities.
5. Good Experience in designing Views and Materialized Query Tables.
Requirements:
Good experience writing Packages, Procedures, Functions and Triggers.
Good experience writing complex queries.
Good experience in Performance tuning the complex queries and complex procedure.
Experience in Modelling Logical and Physical data model using any of the Data Modelling tool.
Good Knowledge on Normalization, De-normalization and the various De-normalization techniques.
Good Experience in Designing Views and Materialized Query Table.
Good Knowledge on Dimensional Modelling and ETL Process is plus.
Exceptional DB2 PL/SQL development Knowledge.