Netezza / Gemfire Consultant (Permanent Position)

System Canada; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading technology company in Toronto is seeking a candidate with strong experience in Netezza and Gemfire. Responsibilities include analyzing schemas, performance tuning, and creating stored procedures. The ideal candidate should possess exceptional analytical skills and be a team player. This role offers an opportunity to work independently and engage with the architecture group on technical design sessions.

Qualifications

• Strong experience in Netezza and Gemfire.
• Expertise in performance tuning of SQL and ETL code.
• Excellent development experience in creating stored procedures.
• Excellent experience in loading data between Netezza tables.

Responsibilities

• Analyze Gemfire schema and Netezza instance tables.
• Conduct technical design sessions with architecture group.
• Design and propose Autosys job scheduling.

Job description

Company Description

System Canada 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 programs.

Visit us at: http://www.SystemCanada.com

System Canada is an equal opportunity employer.

Job Description

1. Strong experience in netezza and Gemfire. Knowledge of data synapse would be an added advantage
2. Analyze Gemfire schema and Netezza instance tables for Security, Credit lines and Deal info.
3. Expertise in performance tuning of SQL and ETL code and writing efficient and complex queries on huge volumes of data
4. Excellent development experience in creating stored procedures, PL / SQL packages, triggers, functions, cursor management and exception handling
5. Excellent experience in loading data between netezza tables using NZSQL utility
6. Data Model update in Netezza and Gemfire for new changes
7. Designed and proposed Autosys job scheduling
8. Conducting technical design session with architecture group
9. Exceptional analytical and problem solving skills. Team Player with the ability to communicate effectively at all levels of the development process
10. Excellent ability to work independently as well as in a team.

Additional Information

All your information will be kept confidential according to EEO guidelines.