• Teradata Developer

Industry Banking / Financial Services / Broking
Location Karnataka Bagalkot,Bangalore,Belgaum,Bellary,Bidar,Bijapur,Chamrajnagar,Chikmagalur,Chitradurga,Dakshin Kannad,Davangere,Dharwad,Gadag,Gulbarga,Hassan,Haveri,Kodagu,Kolar,Koppal,Mandya,Mangalore,Mysore,Raichur,Shimoga,Tumkur,Udupi,Uttar Kannad
Experience Range 3 - 10 Years
Qualification BSC

Functional Banking, Insurance & Financial Services
Job Description
About Us
“Magna Infotech, now Quess IT Staffing, is India’s largest IT staffing company with over 20 years of experience in staffing IT professionals in 300+ companies across levels and skillsets. Our 10,000+ associates deployed in 80+ cities and towns are proficient in over 500 technological skills. Our associates help enable cutting edge solutions some of the biggest names across industried. Quess IT Staffing is a division of Quess Corp Limited, India’s leading business services provider and largest domestic private sector employer. Quess Corp Limited is - ‘A Great Place to Work’ certified – a testament to our excellent culture, people, and processes.”
About Company
Roles and Responsibility
  • Job Description

    Teradata Developer

    Exp -  3 to 10years

    Np- 15days to Immediate 

    • 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.
    • Created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
    • Automated data warehousing and datamart refreshes using scheduling tool like  control - M
    • Worked on creating and managing the partitions.
    • Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
    • Acted as a liaison between the offshore and onsite teams.
    • Experience in Dimensional Modelling preferred
    • Experience in reporting tool Qliksense preferred
    • Experience in Banking domain preferred


A+| A| A-