Interested to Buy Any Domain ? << Click Here >> for more details...
can anyone please tell what are the roles and
responsibilities of a teradata developer in detail???
- 1 Answers
- 5080 Views
- I also Faced
- E-Mail Answers
Answer Posted / naga
As Teradata developer, responsible for maintaining all
DBA functions (development, test, production) in operation 24×7.
Performance tuning, including collecting statistics,
analyzing explains & determining which tables needed
statistics. Increased performance by 35-40% in some situations.
Multiload, BTEQ, created & modified databases, performed
capacity planning, allocated space, granted rights for all
objects within databases, etc
Moved databases between machines.
Installed patch sets and upgraded Teradata.
Automated data warehousing and datamart refreshes using
Transportable table space option.
Worked on creating and managing the partitions.
Performed database health checks and tuned the databases
using Teradata Manager.
Deliver new and complex high quality solutions to
clients in response to varying business requirements and
Creating and managing user accounts.
Installed Teradata drivers for the teradata utilities.
Refreshed the data by using fastexport and fastload
utilities.
Used Teradata Administrator and Teradata Manager Tools
for monitoring and control the system.
Creating and modifying MULTI LOADS for Informatica using
UNIX and Loading data into IDW.
Loading data from various data sources and legacy
systems into Teradata production and development warehouse
using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
With the in-depth expertise in the Teradata cost based
query optimizer, identified potential bottlenecks with
queries from the aspects of query writing, skewed
redistributions, join order, optimizer statistics, physical
design considerations (PI and USI and NUSI and JI etc) etc.
In-depth knowledge of Teradata Explain and Visual Explain to
analyze and improve query performance.
Working as an On-Site Teradata Lead DBA, doing DBA
activities that are Implementation of data and table-level
security, setting up access rights and space rights for
Teradata environment. Performance tuning, Monitoring and
reporting Review system utilization by user.
Acted as a liaison between the offshore and onsite teams.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is database bounce?
Explain file manager?
Differentiate between delete and truncate table?
How does database replication work?
How do you pass parameter in stored procedure?
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
what is rcp,if rcp disabled what happen?
What is odm in database?
How to produce such kind of file?
What is aws documentdb?
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
Why do we need distributed database?
Can we use redis as database?
What is ole db used for?
please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks
