Teradata architect

Company: Infosys
Location: Irving
Posted on: January 17, 2020

Job Description:

Qualifications Basic --- Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education. --- At least 7 years of experience with Information Technology. Preferred --- At least 6 years of experience in software development life cycle --- At least 6 years of experience in project life cycle activities on development and maintenance projects --- At least 6 years of experience in defining new architectures and driving an independent project from an architectural stand point --- At least 4 years of hands on architecture, design, development and administration experience on Teradata. Worked extensively with Teradata utilities - Fastload, Multiload, Tpump and Teradata Parallel Transporter (TPT) to load huge amounts of data from flat files into Teradata database. --- Extensively used Fastexport to export data out of Teradata tables. --- Created BTEQ scripts to invoke various load utilities, transform the data and query against Teradata database. --- Created proper PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS. --- Worked with various user groups and developers to define TASM Workloads, developed TASM exceptions, implemented filters and throttles as needed --- Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database. --- Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant and Query man. --- Excellent experience with Scheduled and ran ActiveBatch job streams and jobs requested by Applications support. Created streams and jobs for day and night batch runs.

Keywords: Infosys, Irving , Teradata architect, Professions , Irving, Texas