The Senior Extract/Transform/Load (ETL) programmer will design and develop the scripts and programs required to extract, transform, clean, and move data and metadata so it can be loaded into the data warehouse. The ETL programmer will work with the technical and business users to gather and interpret system requirements and to understand the source systems for extracts. The ETL programmer will work with the DBA and data modelers to map the source system to the data warehouse models. The ETL programmer will be responsible for designing, coding, documenting and supporting data warehouse extract processes. The successful candidate will have experience/training in testing methods including unit testing, system and integration testing. The ETL programmer will work with the other members of the team to monitor and maintain the operational procedures.
Experience and Skills:
-Implementation of load processes in a multi-terabyte Teradata data warehouse
-Use of C++. Visual Basic and Java programming languages are a plus
-Automation of load processes using Unix and Windows scripting, BTEQ, Fastload, MultiLoad, and TPump
-In-depth experience with korn shell scripting
-Use of data profiling methods to analyze data sources
-Implementation of monitoring systems to automate the detection and resolution of loading errors
-In-depth problem solving capabilities
-Knowledge of EAI tools like MQ Series and TIBCO to implement real-time data warehouse loads
-In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance
-In-depth knowledge of complex SQL using Teradata functions, UDFs, macros and stored procedures
-Experience with ETL tools like Informatica or Ascential is a plus
-Experience with business intelligence tools such as Cognos, Business Objects and Brio is a plus
-Experience with the Agile Unified Process (AUP) or Extreme Programming is a plus
