Ref No.: 18-30293
Location: Milpitas, California
Position Type:Full Time/Contract
Start Date: 05/02/2018
Teradata Data engineer / Tech Lead Sound Knowledge of BI and Data Warehousing
Knowledge of Teradata architecture
Ability to play a Techno Functional role (business analyst experience and project management exposure would be a plus)
Experience in designing and developing ETL data pipelines
Proficient in writing complex SQLs, expertise in performance tuning of SQLs
Hands on experience in database and table design
Excellent knowledge of data loading tool stack TPT, FastLoad, MLoad, TPump
Working experience with huge volumes of data would be an advantage
Expected to lead offshore database engineers
Understanding of data analytics principles and reporting tools would be an advantage
1. Are you willing to take up a 100% hands on job?
2. SQL programming skills - should be able to write complex SQLs (self rating 7 out of 10 or above)
3. Teradata programming - Are you comfortable with advanced analytical functions?
4. Do you uderstand Teradata architecture?
5. Have you written stored procedures in teradata?
6. we require you to be proficient in one fo the progamming languages? Python or Java
7. Can you do performance tuning of queries for large tables (500 Million to 1Billion rows etc)