Avansa IT Solutions LLC. is looking for Software Engineers to work on Teradata ETL tools and utilities to create DDL structures, optimize query performance, and develop reusable scripts for new projects and enhancements.
Requirements
- Work on Teradata ETL tools & utilities such as BTEQ, MLOAD, FASTLOAD, TPT, FASTEXPORT & Macros.
- Create DDL structures for tbls & views bsd on mapng docs for new projs & enhncmnts.
- Work w/ db admins for idntfyng low performng queries & work on tuning & reducing impact CPU on these queries.
- Create reusable scripts which can be u/multiple initiatives & imprv productivity.
- Work on mocking up data in dvlmnt envrmnt to suprt unit testing scenarios.
Responsibilities
- Work on Teradata ETL tools & utilities such as BTEQ, MLOAD, FASTLOAD, TPT, FASTEXPORT & Macros.
- Create DDL structures for tbls & views bsd on mapng docs for new projs & enhncmnts.
- Work w/ db admins for idntfyng low performng queries & work on tuning & reducing impact CPU on these queries.
- Create reusable scripts which can be u/multiple initiatives & imprv productivity.
- Work on mocking up data in dvlmnt envrmnt to suprt unit testing scenarios.
Other
- Bachelors in Sci, Tech, or Engg (any) w/5yrs exp in job offd or rltd occup is reqd.
- various unanticipated locations throughout the U.S
