Job Description :
1. Experience of 8-12 years in Datawarehousing ETL development projects
2. Expertise working as a Teradata developer and strong skills in SQL queries, Teradata Macros, stored procedures
3. Knowledgeable about composing lengthy and intricate SQL queries & performance tuning
4. Expert in building views macros tables joins functions stored procedures in Teradata database
5. Very good knowledge of different indexes PI SI JI PPI Join Strategies Data Protection
6. Practical experience utilizing tools to query such as Teradata SQL Assistant
7. Extensive working experience in Teradata utilities viz TPUMP BTEQ FastExport FastLoad MultiLoad TPUMP
8. Skillful with monitoring performance analysis and SQL query tuning using EXPLAIN PLAN Collect Statistics Teradata Viewpoint
9. Very familiar with the Software Development Life Cycle SDLC Proficient in analyzing and translating business requirements to technical requirements and modeling the Logical and Physical Data Model
10. Practical experience in Informatica Powercenter and performance tuning of the Workflows & Mappings
11. Basic knowledge in Unix command and building scripts
12. Excellent communication and client handling skills and ready to work in offshore-onsite model"