Database Developer with TeraData PL SQL

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.

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

With 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

Should have knowledge on Data Profiling activities

Should have knowledge on Teradata Viewpoint portlets, alert mechanism etc

With excellent analytical and problem-solving abilities, with quick adaptation to new technologies, methodologies, and system

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 (24×7)

Tera Data, DWBi Concepts, Data Modeling, Development, SQL & analytics.

Salary for this role is negotiable but will be in the range £45K to £60K.