Database Developer with TeraData PL SQL - Coventry
Onyx-Conseil
Coventry
GBP 40,000 - 60,000
Job description
Job Description
Database Developer with TeraData - Coventry
Our Client is looking to recruit a Tera Data Developer with at least 5 years hands-on experience in data analysis, data modeling & SQL writing in Teradata Environment.
Responsibilities:
Must have strong knowledge in Teradata Architecture (Must have knowledge on Journal, RAID, CLIQUE, FALLBACK mechanism).
Good understanding and working knowledge of ALL SQL functions, Join strategies (HASH, MARGE etc.).
Understanding and working knowledge of all System tables such as DBQL, PDCRINFO etc.
Hands-on knowledge on Teradata PL/SQL, Store Procedure, Ref Cursor etc.
Very good hands-on knowledge on Teradata SQL, BTEQ, Fastload, Multiload, TPUMP, TPT skill.
Complete understanding of Performance Tuning technique, working with SKEWNESS, SPACE MANAGING, LOCKING.
Understanding of Software Development Life Cycle (SDLC) & Data Warehousing Concepts.
Knowledge on Data Profiling activities.
Knowledge on Teradata Viewpoint portlets, alert mechanism etc.
Excellent analytical and problem-solving abilities, with quick adaptation to new technologies, methodologies, and systems.
Good individual contributor as well as a team player with ability to build strong partner confidence.
Excellent communication skills and judgment, ability to manage multiple tasks, and work towards a deadline in a fast-paced, aggressive development schedule.
Ability to work in any Shift (24x7).
Skills:
Tera Data, DWBi Concepts, Data Modeling, Development, SQL & analytics.
Salary:
Salary for this role is negotiable but will be in the range £45K to £60K.