Job 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