Teradata Developer

TERADATA DEVELOPER

The candidate must have worked as Teradata developer for minimum of seven years using BTEQ 6, M-Load and T-PUMP, multi load, fast load. Good experience in aggregation and Semantic layer.

JOB REQUIREMENTS:

At least 7 years experience in Data Warehousing/BI with hands on expertise in Teradata
Critical thinking and excellent verbal and written communication skills
Strong problem-solving and analytical abilities
Strong experience in designing and developing large scale and optimized Data Warehouses using Teradata and Informatica
In-depth hands on experience in database, ETL/ELT/TELT design and development and should have excellent data analysis skills
In-depth hands on experience in developing reporting and dashboard solutions on DW platform using multiple UI and reporting tools
Experience in deploying solutions using version control systems like Subversion, Metadata Management, Enterprise data security architecture and Data Warehouse best practices
Minimum of 7+ years strong NCR Teradata and SQL, UNIX, Data Warehouse Modeling, Teradata Utilities, Aggregates and building efficient views; other SQL and UNIX experience plus Teradata certification may be substituted for years of Teradata experience.
Certification in Teradata and Teradata SQL preferred
Use Teradata utilities fastload, multiload, tpump to load data
Write BTEQ scripts to transform data
Write Fastexport scripts to export data.
Write, test and implement Teradata Fastload, Multiload and Bteq scripts, DML and DDL
Construct Korn/Bash Shell driver routines (write, test and implement Unix Scripts)
Write views based on user and/or reporting requirements
Gather system design requirements, design and write system specifications
SQL proficient
Extensive experience in Teradata stored procedures
Teradata DB server concepts such as PPI
Client Teradata technical environment:

Teradata TTU 13.10 (including TPT API 13.10, .NET 13.11)
Subversion Client
CA Erwin Data Modeller v8.2
Visio - Microsoft product