Bachelor’s degree in Computer Science, Information Systems, MCA or related field. v 4+ years of demonstrable development experience in Teradata DB 14v.
Should have worked on Teradata tools and utilities : TPT, FastLoad, FastExport, Multiload, BTEQ, DBQL, SQL Assistant, Teradata Manager etc.
Should have thorough understanding of Teradata Architecture. v Should have expertise working on queries and complex joins, tune the queries.
Understand requirements and convert them to Teradata scripts using complex SQLs. v Understanding of work load management on Teradata systems to minimize impact of mixed workloads, optimization of BTEQ / SQL Queries in a complex environment v Help establish processes, procedures, and best practices for writing SQLs.
Working knowledge of Unix and Shell scripting ROLE AND RESPONSIBILITIES v Should be able to write complex SQL queries.
Should drive / lead design activities such as in estimations, develop frameworks, prepare design documents, design reviews v Performed database health checks and tuned the databases using Teradata Manager.
Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. v Work with team, and assist in delivering the solution.
Review SQLs and assist in delivering the solution. v Provide support during testing and deployment phases. v Interact with Product Owners, Architects to analyze the requirement and design robust, scalable and secure features.
Evaluate the required performance of the application under live conditions and make sure the code and technical design can perform as expected.
Follow best practices (continuous integration, Refactoring, code standards etc).