Exp : 4+ years
Must Have :
- Strong experience in designing and developing large scale and optimized Data Warehouses using Teradata
- In-depth hands on experience in database, ETL/ELT design and development and should have excellent data analysis skills
- Experience in deploying solutions using version control systems – Metadata Management, Enterprise data security architecture and Data Warehouse best practices
- Use Teradata utilities TPT, fastload, multiload, tpump to load data.
- Write BTEQ scripts and stored procedures to transform data.
- Write Fastexport scripts to export data. Write, test and implement Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
- Construct Korn shell driver routines (write, test and implement UNIX scripts).
- Write views based on user and/or reporting requirements.
- SQL proficient candidates preferred Certification in Teradata and Teradata SQL preferred.