IT - Datastage Developer

Responsibilities

• Strong expertise in writing and optimizing Teradata SQL queries, TPT script etc.
• Manage Production/Development databases performance.
• Review Teradata system reports and provide performance assessment report with recommendations to optimize system.
• Investigate and quantify opportunities from performance assessment reports and
• Apply best practices in each of the areas.
• Monitor using Viewpoint tool for Teradata system performance using different portlets.
• Review poor performing queries generated from BI/ETL tools and provide best practice recommendations on how to simplify and restructure views, apply PPI or other index changes
• Closely monitor the performance of various work groups on the system and make sure data is available to business as per the SLA requirement.
• Optimal index analysis - Review Index usage on tables and recommend adding dropping indexes for optimal data acces...