At a Glance
- Tasks: Develop and manage databases using Teradata, focusing on data analysis and SQL writing.
- Company: Join a dynamic team in Coventry, dedicated to innovative data solutions.
- Benefits: Enjoy competitive salary, flexible working hours, and opportunities for professional growth.
- Why this job: Be part of a fast-paced environment where your skills can make a real impact.
- Qualifications: 5+ years experience in Teradata, strong SQL knowledge, and excellent problem-solving skills required.
- Other info: Must be willing to work shifts in a 24x7 operation.
The predicted salary is between 45000 - 60000 £ per year.
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 (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.
Please send your CV to us in Word format.
#J-18808-Ljbffr
Database Developer with TeraData PL SQL - Coventry employer: Jas Gujral
Contact Detail:
Jas Gujral Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Database Developer with TeraData PL SQL - Coventry
✨Tip Number 1
Familiarise yourself with Teradata's architecture and key components like Journal, RAID, and Fallback mechanisms. Being able to discuss these topics confidently during an interview will demonstrate your expertise and understanding of the environment.
✨Tip Number 2
Brush up on your SQL skills, especially focusing on join strategies and system tables such as DBQL and PDCRINFO. Prepare to showcase your knowledge through practical examples or scenarios that highlight your problem-solving abilities.
✨Tip Number 3
Understand performance tuning techniques and be ready to discuss how you've applied them in past projects. Highlighting your experience with skewness, space management, and locking will set you apart from other candidates.
✨Tip Number 4
Demonstrate your ability to work in a team and manage multiple tasks effectively. Share specific instances where you've collaborated with others or met tight deadlines, as this aligns with the fast-paced environment mentioned in the job description.
We think you need these skills to ace Database Developer with TeraData PL SQL - Coventry
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Teradata, SQL writing, and data analysis. Use specific examples that demonstrate your hands-on knowledge of the required skills, such as performance tuning and data modeling.
Craft a Strong Cover Letter: In your cover letter, express your enthusiasm for the Database Developer position. Mention your relevant experience and how it aligns with the job requirements, particularly your understanding of Teradata architecture and SQL functions.
Showcase Relevant Projects: If you have worked on projects involving Teradata PL/SQL or data warehousing, include these in your application. Describe your role, the technologies used, and the outcomes to demonstrate your capabilities.
Proofread Your Application: Before submitting, carefully proofread your CV and cover letter for any errors. A polished application reflects your attention to detail, which is crucial for a role that involves data management.
How to prepare for a job interview at Jas Gujral
✨Showcase Your Technical Skills
Make sure to highlight your hands-on experience with Teradata and PL/SQL during the interview. Be prepared to discuss specific projects where you utilised SQL functions, performance tuning techniques, and data modelling.
✨Understand the Architecture
Demonstrate a strong understanding of Teradata architecture, including concepts like Journal, RAID, and Fallback mechanisms. This knowledge will show that you are well-versed in the environment you'll be working in.
✨Prepare for Problem-Solving Questions
Expect questions that assess your analytical and problem-solving abilities. Be ready to discuss how you've tackled challenges in previous roles, particularly those related to data profiling and performance tuning.
✨Communicate Effectively
Since excellent communication skills are essential for this role, practice articulating your thoughts clearly. Be prepared to explain complex technical concepts in a way that is easy to understand, showcasing your ability to work as part of a team.