"We are Looking for Teradata Administrator, Noida.
Job Type :- Contract to Hire
Location :- Noida
Year of Experience : 4- 12 Years
Designation : Teradata Administrator
This position is for a Teradata administrator, who is responsible for administration of large scale (500Gb - 2TB in size) analytical & transactional data structures
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.
- Included within those responsibilities are the areas of data access and delivery technologies.
- Performance monitoring and tuning including SQL optimization and tuning
- Shell and Batch scripting
- Software installs and upgrades
- Hands on experience on performance tuning of complex SQLs
- In-depth knowledge of Teradata utilities such as Multi load, Fastexport, BTEQ, Fastload and TPump
- Solid understanding of Teradata client tools such as SQL Assistant, Performance Monitor, Teradata Manager and Teradata Administrator
- Hands on experience in using MS SQL Server, Oracle and DB2 databases
Salary: Not Disclosed by Recruiter
Industry: Recruitment / Staffing
Functional Area: IT Software - DBA, Datawarehousing
Role Category: Admin/Maintenance/Security/Datawarehousing
Employment Type: Permanent Job, Full Time