Feeds

So you want to be a Teradata specialist?

Good living for some

Security for virtualized datacentres

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.

Security and trust: The backbone of doing business over the internet

More from The Register

next story
Phones 4u slips into administration after EE cuts ties with Brit mobe retailer
More than 5,500 jobs could be axed if rescue mission fails
JINGS! Microsoft Bing called Scots indyref RIGHT!
Redmond sporran metrics get one in the ten ring
Driving with an Apple Watch could land you with a £100 FINE
Bad news for tech-addicted fanbois behind the wheel
Murdoch to Europe: Inflict MORE PAIN on Google, please
'Platform for piracy' must be punished, or it'll kill us in FIVE YEARS
Phones 4u website DIES as wounded mobe retailer struggles to stay above water
Founder blames 'ruthless network partners' for implosion
Sony says year's losses will be FOUR TIMES DEEPER than thought
Losses of more than $2 BILLION loom over troubled Japanese corp
Radio hams can encrypt, in emergencies, says Ofcom
Consultation promises new spectrum and hints at relaxed licence conditions
Why Oracle CEO Larry Ellison had to go ... Except he hasn't
Silicon Valley's veteran seadog in piratical Putin impression
Big Content Australia just blew a big hole in its credibility
AHEDA's research on average content prices did not expose methodology, so appears less than rigourous
prev story

Whitepapers

Secure remote control for conventional and virtual desktops
Balancing user privacy and privileged access, in accordance with compliance frameworks and legislation. Evaluating any potential remote control choice.
WIN a very cool portable ZX Spectrum
Win a one-off portable Spectrum built by legendary hardware hacker Ben Heck
Storage capacity and performance optimization at Mizuno USA
Mizuno USA turn to Tegile storage technology to solve both their SAN and backup issues.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
The next step in data security
With recent increased privacy concerns and computers becoming more powerful, the chance of hackers being able to crack smaller-sized RSA keys increases.