Posted 140 months ago
Netezza / Gemfire Consultant (Permanent Position)
@ system canada technologies
Toronto, Ontario
Overview
System Canada Technologies is hiring a permanent Netezza and GemFire consultant to analyze schemas and tables for security, credit lines and deal data. The work covers SQL and ETL tuning, database development, data model updates and technical design sessions with the architecture group.
Responsibilities:
- Analyze Gemfire schema and Netezza tables for security, credit and deal data
- Tune SQL and ETL code and write complex queries on large data volumes
- Develop stored procedures, PL/SQL packages, triggers and functions
- Load data between Netezza tables with NZSQL and update data models
- Design Autosys job scheduling and lead technical design sessions
Requirements summary:
- Strong experience with Netezza and GemFire
- Knowledge of DataSynapse is an advantage
- Expertise in SQL and ETL performance tuning
- Excellent PL/SQL development experience
- Strong analytical, problem-solving and communication skills
Tools & skills
Source and dates
Employer career site / ATS feed · smartrecruiters
- Employer posting date
- 2015-04-23
- First seen by our source
- 2026-10-14
- Source record updated
- 2026-10-14
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Mid level |
| Department | Data & analytics |
| Hours per week | 40 (estimated) |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
Summary and details written by AI from the posting; the employer’s posting is the authority.
system canada technologies
| Field | Value |
|---|---|
| Open jobs on Jobsy | 399 |
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.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.