skillindiajobs
Hyderabad Jobs
Banglore Jobs
Chennai Jobs
Delhi Jobs
Ahmedabad Jobs
Mumbai Jobs
Pune Jobs
Vijayawada Jobs
Gurgaon Jobs
Noida Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

Teradata (20-04903) - KA - Bangalore

2.00 to 0.00 Years   Bangalore   03 Dec, 2020
Job LocationBangalore
EducationNot Mentioned
SalaryNot Disclosed
IndustryIT - Software
Functional AreaDBA / Datawarehousing,General / Other Software
EmploymentTypeFull-time

Job Description

  • 5 years experience in development and maintenance of Data warehouse applications
  • 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.
  • 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 Big Data technologies like HDFS, Hadoop, Hive, Spark etc.
  • 3 years of experience in Big Data platform implementation, including 2 years of hands-on experience in implementation and performance tuning Hadoop/Spark implementations
  • Hands-on experience of building and optimizing high-volume, structured and unstructured data processing pipeline
  • Experience in building complex views, stored procedure
  • Worked on creating and managing the partitions.
  • Experience in Version upgrade and disaster recovery preferred
  • Experience in Dimensional Modelling preferred
  • Experience in writing complex SQL queries
,

Keyskills :
source system analysisbig dataquery writinglegacy systemsdata processingphysical designdisaster recoveryunstructured dataperformance tuningsqlhivebteqsparkhadoopdesignwritingbusiness

Teradata (20-04903) - KA - Bangalore Related Jobs

© 2020 Skillindia All Rights Reserved