Teradata Developer

6 days ago

Suite, Canada Stem Xpert Full time $80,000 - $100,000 per year
Company Description

 

Job Description

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.

Additional Information

  • ETL Developer

    6 hours ago

    Suite, Canada system canada technologies Full time $80,000 - $120,000 per year

    Company Description SCT resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to our offerings. We learn continuously, both on the job and through formal training...