Netezza / Gemfire Consultant (Permanent Position)

{
  "content_hash": "f872b5d8c277cc3542e52a22f8d57eed5ed18525bcbaa668b3eea0f26ef09efe",
  "source_hash": "52589fbc30d08fbc8368a55d6ce72a5393a42a8f0e1318807b6fd45d87d844e4",
  "last_changed_at": "2026-05-31T17:41:13.571Z",
  "active_status": "active"
}

{
  "language": "en",
  "location": {
    "raw": "Toronto, ON, Canada",
    "city": "Toronto",
    "region": "ON",
    "country": "Canada",
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-06T20:26:03.165Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "Toronto, ON, Canada",
      "city": "Toronto",
      "region": "ON",
      "country": "Canada",
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": [
      "Canada"
    ]
  },
  "remote_policy": null,
  "salary_period": null,
  "workplace_type": null,
  "salary_currency": null
}

{}

{
  "id": "82465208",
  "ref": "https://api.smartrecruiters.com/v1/companies/systemcanadatechnologies/postings/82465208",
  "name": "Netezza / Gemfire Consultant (Permanent Position)",
  "uuid": "ae08078e-1729-4731-921b-cf5dc57868b2",
  "detail": {
    "id": "82465208",
    "name": "Netezza / Gemfire Consultant (Permanent Position)",
    "uuid": "ae08078e-1729-4731-921b-cf5dc57868b2",
    "jobAd": {
      "sections": {
        "jobDescription": {
          "text": "<p><span>1.        Strong experience in netezza and Gemfire. Knowledge of data synapse would be an added advantage   </span><br /></p><p>2.        Analyze Gemfire schema and Netezza instance tables for Security, Credit lines and Deal info. </p><p>3.        Expertise in performance tuning of SQL and ETL code and writing efficient and complex queries on huge volumes of data </p><p>4.        Excellent development experience in creating stored procedures, PL/SQL packages, triggers, functions, cursor management and exception handling </p><p>5.        Excellent experience in loading data between netezza tables using NZSQL utility </p><p>6.        Data Model update in Netezza and Gemfire for new changes </p><p>7.        Designed and proposed Autosys job scheduling </p><p>8.        Conducting technical design session with architecture group </p><p>9.        Exceptional analytical and problem solving skills. Team Player with the ability to communicate effectively at all levels of the development process </p><p>10.        Excellent ability to work independently as well as in a team. </p>",
          "title": "Job Description"
        },
        "qualifications": {
          "text": "",
          "title": "Qualifications"
        },
        "companyDescription": {
          "text": "<p>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.</p><p></p><p>Visit us at: http://www.SystemCanada.com</p><p></p><p><b>System Canada is an equal opportunity employer.</b></p>",
          "title": "Company Description"
        },
        "additionalInformation": {
          "text": "<p>All your information will be kept confidential according to EEO guidelines.</p>",
          "title": "Additional Information"
        }
      }
    },
    "jobId": "14d0ef38-b0f4-4449-938f-89dd096e12c2",
    "active": true,
    "company": {
      "name": "system canada technologies",
      "identifier": "systemCanadaTechnologies"
    },
    "creator": {
      "name": "",
      "avatarUrl": ""
    },
    "jobAdId": "cb9e0e08-afe0-4a94-bc9c-64f3cc695e31",
    "applyUrl": "https://jobs.smartrecruiters.com/systemCanadaTechnologies/82465208-netezza-gemfire-consultant-permanent-position-?oga=true",
    "function": {
      "id": "information_technology",
      "label": "Information Technology"
    },
    "industry": {
      "id": "computer_software",
      "label": "Computer Software"
    },
    "language": {
      "code": "en",
      "label": "English",
      "labelNative": "English (US)"
    },
    "location": {
      "city": "Toronto",
      "hybrid": false,
      "region": "ON",
      "remote": false,
      "address": "Toronto, ON, CA",
      "country": "ca",
      "latitude": "43.653226",
      "longitude": "-79.38318429999998",
      "fullLocation": "Toronto, ON, Canada"
    },
    "refNumber": "REF699V",
    "postingUrl": "https://jobs.smartrecruiters.com/systemCanadaTechnologies/82465208-netezza-gemfire-consultant-permanent-position-",
    "visibility": "PUBLIC",
    "customField": [
      {
        "fieldId": "58b7e539e4b09a6d37a0d04b",
        "valueId": "default",
        "fieldLabel": "Brands",
        "valueLabel": "system canada technologies"
      },
      {
        "fieldId": "COUNTRY",
        "valueId": "ca",
        "fieldLabel": "Country/Region",
        "valueLabel": "Canada"
      }
    ],
    "referralUrl": "https://jobs.smartrecruiters.com/external-referrals/company/systemCanadaTechnologies/publication/ae08078e-1729-4731-921b-cf5dc57868b2?dcr_ci=systemCanadaTechnologies",
    "defaultJobAd": true,
    "releasedDate": "2015-04-23T16:38:59.000Z",
    "experienceLevel": {
      "id": "not_applicable",
      "label": "Not Applicable"
    }
  },
  "company": {
    "name": "system canada technologies",
    "identifier": "systemCanadaTechnologies"
  },
  "jobAdId": "cb9e0e08-afe0-4a94-bc9c-64f3cc695e31",
  "function": {
    "id": "information_technology",
    "label": "Information Technology"
  },
  "industry": {
    "id": "computer_software",
    "label": "Computer Software"
  },
  "language": {
    "code": "en",
    "label": "English",
    "labelNative": "English (US)"
  },
  "location": {
    "city": "Toronto",
    "hybrid": false,
    "region": "ON",
    "remote": false,
    "address": "Toronto, ON, CA",
    "country": "ca",
    "latitude": "43.653226",
    "longitude": "-79.38318429999998",
    "fullLocation": "Toronto, ON, Canada"
  },
  "refNumber": "REF699V",
  "department": {},
  "visibility": "PUBLIC",
  "customField": [
    {
      "fieldId": "58b7e539e4b09a6d37a0d04b",
      "valueId": "default",
      "fieldLabel": "Brands",
      "valueLabel": "system canada technologies"
    },
    {
      "fieldId": "COUNTRY",
      "valueId": "ca",
      "fieldLabel": "Country/Region",
      "valueLabel": "Canada"
    }
  ],
  "defaultJobAd": true,
  "releasedDate": "2015-04-23T16:38:59.000Z",
  "detail_errors": [],
  "experienceLevel": {
    "id": "not_applicable",
    "label": "Not Applicable"
  },
  "typeOfEmployment": {}
}