22538 - Teradata Developer - Sunnyvale CA
Previous Job
Previous
22538 - Teradata Developer - Sunnyvale CA
Ref No.: 18-37511
Location: Sunnyvale CA, California
Position Type:Contract
Start Date: 05/31/2018
Request-ID: 22538
Duration: Long Term
Location: 1020 Enterprise Way Sunnyvale CA
End Client: Microsoft Corporation
Rate: $75/hr on C2C |

Teradata Developer

Must have:
Teradata experience

Description:
- Strong Knowledge of TERADATA architecture
- Strong SQL skills
- Strong knowledge in TD performance tuning
- Good working knowledge in utilities like BTEQ, FASTEXPORT, FASTLOAD and MULTILOAD, TPT
- Solid understanding of DW and RDMS concepts
- Should have good Analytical skill
- Meeting clients and get requirements
- Should be able to create BRD
- Should be able to transform BRD to FS
- Good coordination skills with multiple stakeholder
- Very good communication skill and articulation skills
- Able to handle 3-4 members offshore team

1. Architecture - Data Warehousing, ETL (Inbound/Outbound)
2. Teradata
- Primary Index, Secondary Index, Value Ordered Secondary Index, Join Index
- Partition
- Join
- Working with - Transaction, Global Temporary Tables, Work Table
3. Data loding strategy - Semantic
- Incremental
- Complete
- History Load
4. Performance Improvement
- Stat Collection
5. Process
- Coding standard
- Version control
- Change management