Feeds

So you want to be a Teradata specialist?

Good living for some

Top 10 endpoint backup mistakes

Many aspiring IT professionals look for career safety with mass-market technology. However, there’s also a secure career in specialist technology, as long as your chosen vendor doesn’t become complacent. So, as an example, we asked a Teradata specialist about the possibilities of a career with his specialist technology. Similar points could no doubt be made about other technologies.

David Norfolk for Reg Developer: Teradata development sounds awfully like database development. Isn't that "old hat" these days (see comments to the article here)?

Huw Lewis from Teradata: Teradata projects are database development projects. Teradata is simply a database, after all, albeit one specifically designed for Data Warehousing. Holding all your data in a single, integrated data model allows you to answer your business questions. And holding it in a normalised model (normalised to third normal form) allows you to answer any question about your business, even those you haven't yet thought about.

Reg Developer: OK, I can see that – it is how I was taught, many years ago, to design databases. So, what are the challenges in designing a Teradata Warehouse today?

Lewis: The principal challenge... is merging the data from disparate source systems into a single data model. The single data model may involve customer matching and merging and is usually non-trivial. Inevitably, data quality issues are a major inhibitor that needs to be overcome.

Reg Developer: So, how long could this take? I've heard it reported that addressing data quality issues has been the end of many data integration projects.

Lewis: In terms of the data model, it isn't necessary to spend months designing a Teradata system, we would tend to recommend a short initial implementation project to load up some data and allow the business users to see the benefit they get. These initial projects can be as short as 30 days [and then lead to bigger projects].

Reg Developer: OK, so why Teradata? Surely, career opportunities with Teradata are limited?

Lewis: As the data warehousing vision has evolved over time, so Teradata has changed to allow this vision to be implemented. Teradata has continually improved performance with every release of hardware and software. Additional Teradata enhancements mean that even the implementation of a focused OLTP-type system (say, direct access from a customer service representative while in contact with a customer) on Teradata is [now] perfectly feasible.

In addition, Teradata's linear scalability allows a customer to start small, and grow big, by adding hardware building-blocks as and when necessary, without losing performance. As a company's vision and data requirements grow, so Teradata can grow to meet its needs, and provide the extra functionality and control. It's only when you put all your data into a single place that you can truly discover its worth.

I've seen business questions being answered that have saved, or made, millions of dollars, as a result of a Teradata implementation, and that has been true across many industries, from Finance, though Retail and Telcos to Travel and Transportation [and now Gaming]. And our Professional Services revenue comes from a mixture of developments for new customers as well as taking on projects for existing customers, many of whom we have worked with for years, but who continue to enhance and grow their warehouses. We are busier than ever.

Reg Developer: Well, if there's a demand, what sort of projects do you get involved in? Is it all just tuning access code or do you get to write business-focused applications?

Lewis: Teradata projects can range from small implementations in existing customers, through migrations off existing warehouses onto Teradata from a technology that is not delivering the expected business benefit (after all, most companies have a data warehouse that they perceive as providing some benefit, and don't want to lose all their investment), to the implementation of a completely new Enterprise Data Warehouse in a brand-new customer.

There are usually two focuses to projects, getting the data from source systems onto the Teradata platform and into a flexible physical model; plus the presentation of this information to the end business user, usually via a Business Intelligence tool. Additionally, the power of Teradata allows a company to empower willing business users to allow them to 'explore' their data themselves. Some of the most important business benefits out of data warehouses come via the business users themselves mining the data directly.

Inevitably, over time, some code may become inefficient, as volumes increase, so we do also undertake tuning exercises, usually based on the outputs from customers monitoring their systems. And let's not forget data quality. A data warehouse is the perfect place to highlight, and measure, data quality issues with existing source systems. We often consult with companies on how to improve data quality.

Reg Developer: So, if someone is starting out in IT, would you recommend them to specialise in something like Teradata and why?

Lewis: Personally, I have been working with the Teradata technology for 15 years, so have seen the way it has developed, both in terms of hardware and software. I started as a Database Administrator for an existing Teradata customer, having previously worked as a DBA on DB2, but now undertake lead design roles on large projects within the UK. The improvements in performance and reliability on the hardware has been astonishing, compared to the early days when Teradata ran on a proprietary Operating System on proprietary hardware.

Software developments have been equally spectacular, with many US patents granted to techniques used within the Teradata database implementation. I am convinced that Teradata will be the leader in the Data Warehouse market for many years to come, so would recommend anyone to specialise. As a Teradata specialist, you tend to learn about most aspects of a development, from analysis and data modelling, to design, code, test and implementation, with an element of Database Administration thrown in. It gives you a good grounding in most aspects of IT.

I suppose the only downside for some of the younger-generation IT professionals out there, is that Teradata tends to have a foothold in the larger organisations, so you are unlikely to work in an IT department of only 10 people and use Teradata.

Reg Developer: Thank you.

A new approach to endpoint data protection

More from The Register

next story
Amazon says Hachette should lower ebook prices, pay authors more
Oh yeah ... and a 30% cut for Amazon to seal the deal
Philip K Dick 'Nazi alternate reality' story to be made into TV series
Amazon Studios, Ridley Scott firm to produce The Man in the High Castle
Nintend-OH NO! Sorry, Mario – your profits are in another castle
Red-hatted mascot, red-colored logo, red-stained finance books
Sonos AXES support for Apple's iOS4 and 5
Want to use your iThing? You can't - it's too old
Joe Average isn't worth $10 a year to Mark Zuckerberg
The Social Network deflates the PC resurgence with mobile-only usage prediction
Chips are down at Broadcom: Thousands of workers laid off
Cellphone baseband device biz shuttered
Feel free to BONK on the TUBE, says Transport for London
Plus: Almost NOBODY uses pay-by-bonk on buses - Visa
Twitch rich as Google flicks $1bn hitch switch, claims snitch
Gameplay streaming biz and search king refuse to deny fresh gobble rumors
Stick a 4K in them: Super high-res TVs are DONE
4,000 pixels is niche now... Don't say we didn't warn you
prev story

Whitepapers

7 Elements of Radically Simple OS Migration
Avoid the typical headaches of OS migration during your next project by learning about 7 elements of radically simple OS migration.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Consolidation: The Foundation for IT Business Transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.
Solving today's distributed Big Data backup challenges
Enable IT efficiency and allow a firm to access and reuse corporate information for competitive advantage, ultimately changing business outcomes.
A new approach to endpoint data protection
What is the best way to ensure comprehensive visibility, management, and control of information on both company-owned and employee-owned devices?