Datawarehouse Lead Tech Analyst

Job Description
Minimum 7 years experience in development and maintenance of Datawarehouse applications
Minimum 5 years experience in Teradata with loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTILOAD, FASTLOAD and TPT.
Minimum 2 years experience in delivering new and complex high-quality solutions to clients in response to varying business requirements and creating and managing user accounts.
Expertise in the Teradata cost-based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc) etc. In-depth knowledge of Teradata Explain to analyze and improve query performance.
Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
Experience in Banking domain preferred
Experience in Regulatory reporting preferred
Minimum 7 years experience in development and maintenance of Datawarehouse applications
Minimum 5 years experience in Teradata with loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTILOAD, FASTLOAD and TPT.
Minimum 2 years experience in delivering new and complex high-quality solutions to clients in response to varying business requirements and creating and managing user accounts.
Expertise in the Teradata cost-based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc) etc. In-depth knowledge of Teradata Explain to analyze and improve query performance.
Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
Experience in Banking domain preferred
Experience in Regulatory reporting preferred
Posted
06/19/2022
Location
victoria, VIC, AU