Toggle navigation

  • Teradata Developer

Industry Banking / Financial Services / Broking
Location Bangalore
Experience Range 6 - 9 Years
Qualification Graduate
Not active

Functional Banking / Insurance
Job Description
About Us
“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
www.magna.in
Roles and Responsibility
  • As Teradata developer, responsible for maintaining all DBA functions (development, test, production) in operation 24×7
  • Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations
  • Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
  • Moved databases between machines
  • Installed patch sets and upgraded Teradata
  • Automated data warehousing and DataMart refreshes using Transportable table space option
  • Worked on creating and managing the partitions
  • Performed database health checks and tuned the databases using Teradata Manager
  • Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts
  • Installed Teradata drivers for the Teradata utilities
  • Refreshed the data by using fast export and fast load utilities
  • Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system
  • Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into IDW
  • Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica
  • With the in-depth 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 and Visual Explain to analyze and improve query performance
  • Working as an On-Site Teradata Lead DBA, doing DBA activities that are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment
  • Performance tuning, Monitoring and reporting Review system utilization by user
  • Acted as a liaison between the offshore and onsite teams

 

Experience and Skills required:

  • Should have 6  yrs strong experience in Informatica/Teradata development
  • Hands on experience on Java, SQL, Junit, JQuery, WebLogic server
  • Should have experience in providing technical solutions for Given functional assignment
  • Study, Understand and document current application Architectures, Implementations for the domains assigned
  • To be able to perform detailed analysis of business problems and technical environments and use this in designing the solution
  • To be able to work creatively and analytically in a problem-solving environment;

Should be able to work independently and guide other team members

 

 

A+| A| A-
Job By Location
Job By Function
Jobs By Industry
Jobs By Skills
Jobs by business vertical
Social Network