Teradata Developer

Back To Jobs Apply Now

Teradata Developer

Roles and Responsibilities:
  • Design and develop optimized data warehouses using complex Teradata SQL and stored procedures.
  • Heavily experienced in Teradata, SQL, related database utilities, PL/SQL (stored procedures), and Unix Shell scripting.
Skills:
  • 2+ years of experience in developing optimized Data Warehouses using complex Teradata SQL as well as stored procedures
  • 2+ years of experience developing efficient views and aggregates for Teradata Data Warehouses.
  • Excellent Programming experience in Teradata SQL, as well as Stored Procedures
  • Performance tuning of SQL Queries
  • In-depth hands on experience in database, ETL design and development
  • Unix shell scripting experience a plus
  • Strong problem-solving, testing, and troubleshooting abilities
  • Should also be Business savvy and be able to take conceptual Business processes and create coding
  • Excellent communication skills
  • This BI/DW team is using SQL Assistant for Teradata utilities.
  • Writing stored procedures to extract as well as access data both. Teradata stored procedures make up 95% of the ETL code base.
  • The Teradata stored procs dev. needs 2 years of stored proc experience, at least a year of which is Teradata.
    • Proficiency with Informatica (it’s only used to load files to a stage table and then all logic is done in stored procs) and the UC4/Appworx scheduling tool are preferred, but not required