Job Description :
1. Experience in Data warehousing ETL development projects in Teradata
2. Expertise working as a Teradata developer and strong skills in Teradata Stored Procedures, SQL queries, Teradata Macros
3. Solid Experience of creating Teradata Stored Procedures, Functions, Triggers, Views and Exception handling for retrieving manipulating
4. Knowledgeable about composing lengthy and intricate SQL queries & performance tuning
5. Expert in building views macros tables joins functions stored procedures in Teradata database
6. Very good knowledge of different indexes PI SI JI PPI Join Strategies Data Protection
7. Practical experience utilizing tools to query such as Teradata SQL Assistant
8. Extensive working experience in Teradata utilities viz TPUMP BTEQ FastExport FastLoad MultiLoad TPUMP
9. Skillful with monitoring performance analysis and SQL query tuning using EXPLAIN PLAN Collect Statistics Teradata Viewpoint
10. 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
11. Practical experience in Informatica Powercenter and performance tuning of the Workflows & Mappings
12. Basic knowledge in Unix commands and building shell scripts
13. Excellent communication and client handling skills and ready to work in offshore-onsite model