System Canada Technologies Logo

System Canada Technologies

Netezza / Gemfire Consultant (Permanent Position)

Reposted 15 Days Ago
Be an Early Applicant
In-Office
Toronto, ON, CAN
Mid level
In-Office
Toronto, ON, CAN
Mid level
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.
The summary above was generated by AI
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.

Similar Jobs

2 Hours Ago
Remote or Hybrid
Toronto, ON, CAN
Senior level
Senior level
eCommerce • Fashion • Retail • Sales • Wearables • Design
Lead regional retail training and customer experience initiatives, deliver and implement sales, service, and clienteling programs, monitor KPIs, coach store teams and managers, support onboarding and digital tool adoption (Coach Journey, Client Compass), and drive consistent brand service standards across the market.
Top Skills: Client CompassCoach JourneyExcelMS OfficePowerPointWord
4 Hours Ago
In-Office or Remote
CA
Mid level
Mid level
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Build and operate ingestion, reconciliation, and reporting systems that reconcile card-network and partner settlement files against internal transactions. Deliver end-to-end features for traceability, accounting journals, tax and regulatory reporting, and compliance tooling while ensuring reliability, scalability, and data privacy.
Top Skills: Ai ToolsAirflowAWSBigQueryCi/CdDelta LakeGoHadoopIso-8583JavaKafkaKubernetesObservabilityPysparkPythonSnowflakeSparkSQLTemporalTerraform
4 Hours Ago
In-Office or Remote
CA
Senior level
Senior level
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Lead development and implementation of AI legal and compliance frameworks. Conduct cross-functional AI reviews, maintain governance docs (model cards, impact assessments), partner with engineering on transparency and fairness requirements, build incident response and monitoring processes, and scale AI legal review workflows.
Top Skills: Ai/MlAlgorithmic Impact AssessmentGenerative AiLlmsModel CardsModel Monitoring

What you need to know about the Toronto Tech Scene

Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account