Database Developer with TeraData PL SQL - Coventry

Jas Gujral; Coventry; On-site; GBP 45,000 - 60,000; Full time

Job summary

Jas Gujral in Coventry is seeking a Database Developer with Teradata to design, implement and optimize data flows in a Teradata environment. The role requires hands-on experience and a strong analytic mindset.

You will work across data analysis, data modeling, SQL development, and performance tuning, including access to Teradata utilities such as BTEQ and TPT, while following SDLC and data warehousing best practices.

Qualifications

• 5+ years hands-on experience in data analysis, data modeling & SQL in Teradata.
• Strong knowledge of Teradata architecture: Journal, RAID, CLIQUE, FALLBACK.
• Proficient with Teradata SQL, BTEQ, FastLoad, Multiload, TPUMP, TPT.
• Experience with SDLC and data warehousing concepts.
• Ability to work in 24x7 shift and deliver under deadlines.
• Excellent communication and team collaboration.

Skills

Teradata

SQL

PL/SQL

BTEQ

Fastload

Multiload

TPUMP

TPT

Data Warehousing

SDLC

Data Profiling

Tools

Journal

RAID

CLIQUE

FALLBACK

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.

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

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

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