Required Skills

BTEQ SQL Assistant TPUMP ODBC MLOAD Fastload fast export

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 3rd Nov 2023

JOB DETAIL

Need at least 7 years Teradata Database Administration experience and experience with significant experience with all Teradata Tools and Utilities (TTU) eg BTEQ, SQL Assistant, TPUMP, ODBC, MLOAD, Fastload, fast export
Experienced in performance optimization techniques and complex SQL tuning.
Demonstrated knowledge of Performance Data Collection and Reporting (PDCR) and Database Query Logging (DBQL)
Experienced in DSA and Quantum I3 BAR technologies
● Ability to write complex Teradata SQL queries, stored procedures, triggers, functions
● Advanced data analysis, problem identification and correction skills
● Experience connecting different BI tools to Teradata like OBIEE, SAS, Spotfire, PowerBI
● Experience integrating with ETL tools like AbInitio
● Experience integrating with AWS technologies
● Experience with using NOS and knowledge of cloudlake architecture and clearscape analytics.
● Ability to understand, manage and fix complex problems and to work with different teams and other technology groups collaboratively
● Understand, design and document support policies, procedures and strategies
● Understands, implements and maintains multi-tier database security
● Knowledge of Data Engineering principles and the ability to apply them to complex environments

Company Information