Teradata Developer
Stem Xpert
Apply to this job
Position : Teradata Developer
Location: Montreal, Canada
Duration: Long term
Salary: No constraint for the right candidate. (Preferably -$100,000/annum)
Local candidate highly preferred.
Canadian Citizen or a Permanent Resident of Canada
- Overall 10 years' experience, aability to work independently (consulting role) with users to understand requirements
- Must have project experience in implementing solutions in Teradata environment
- Minimum of 5- 6 years strong experience in Client Teradata
- Good exposure in SQL and UNIX environment
- Thorough in Data Warehouse concepts and Modeling
- Expert experience in Teradata Utilities, Aggregates and building efficient views
1. Use Teradata utilities fastload, multiload, tpump to load data.
2. Write BTEQ scripts to transform data.
3. Write Fastexport scripts to export data.
4. Write, test and implement Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
5. Construct Korn shell driver routines (write, test and implement UNIX scripts).
6. Write views based on user and/or reporting requirements.
7. Gather system design requirements, design and write system specifications.
8. SQL proficient.
Summary
Develop and implement data solutions using Teradata, SQL, UNIX, and data warehouse concepts.
Job title
Teradata Developer
Experience level
10+ years
Industry
software
Location requirements
Montreal, Canada; local candidates preferred; remote not specified.
Salary
No constraint for the right candidate. (Preferably -$100,000/annum)
Management role
No
Required skills
Preferred skills
Specializations
Structured locations inferred from the posting.
Montreal, QC, Canada