Netezza / Gemfire Consultant (Permanent Position)

Reposted 26 Days Ago
Be an Early Applicant
Toronto, ON, CAN
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Consultant responsible for Netezza and GemFire development and administration: analyze schemas, update data models, tune SQL/ETL for large volumes, build PL/SQL stored procedures/packages, load data with NZSQL, design Autosys scheduling, and lead technical design sessions with architects.
Summary Generated by Built In
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.

Skills Required

  • Strong experience in Netezza
  • Strong experience in GemFire
  • Knowledge of Data Synapse
  • Performance tuning of SQL and ETL code on large volumes
  • Ability to write efficient and complex SQL queries on huge data sets
  • Development experience creating stored procedures, PL/SQL packages, triggers, functions
  • Cursor management and exception handling experience
  • Experience loading data between Netezza tables using NZSQL utility
  • Experience updating data models in Netezza and GemFire
  • Experience designing or proposing AutoSys job scheduling
  • Ability to conduct technical design sessions with architecture groups
  • Strong analytical and problem solving skills; effective communication
  • Ability to work independently and in a team
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
Year Founded: 1999

What We Do

System Canada Technologies is a leading technology solutions provider specializing in software development, IT consulting, and systems integration. Dedicated to delivering innovative and efficient services across various sectors, the company utilizes a customer-centric approach to tailor bespoke software applications to meet unique client needs. Their mission is to empower organizations through technology, enhancing operational efficiency and driving business growth through professional expertise.

Similar Jobs

Xero Logo Xero

Senior Machine Learning Engineer

Cloud • Fintech • Information Technology • Machine Learning • Software
Remote or Hybrid
Ontario, ON, CAN
4500 Employees
185K-225K Annually

Morningstar Logo Morningstar

Canadian Structured Finance Ratings, Analyst – Toronto

Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Hybrid
Toronto, ON, CAN
11500 Employees

Morningstar Logo Morningstar

Data Research Analyst

Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Hybrid
Toronto, ON, CAN
11500 Employees
47K-70K Annually

MongoDB Logo MongoDB

Customer Success Manager

Big Data • Cloud • Software • Database
Easy Apply
Hybrid
Toronto, ON, CAN
5550 Employees
130K-180K Annually

Similar Companies Hiring

Kepler  Thumbnail
Artificial Intelligence • Fintech • Software
New York, New York
9 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees
Revel.io Thumbnail
Aerospace • Hardware • Robotics • Software
US
50 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account