IBM Netezza

Reposted 19 Days Ago
Be an Early Applicant
Charlotte, NC, USA
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Design, develop, and maintain Netezza data warehouse solutions: write NZSQL/NZLOAD and complex SQL/UNIX scripts, tune queries and performance, create efficient views, resolve data issues, and support full data warehouse SDLC.
Summary Generated by Built In
Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

Qualifications


Basic

· Bachelor’s degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education.

· Minimum of 4+ years of work experience in the Information Technology Field.

· Minimum of 4+ years of hands on Netezza experience.

· Experience in full software development lifecycle of the Data Warehousing Project.

· Strong knowledge of Netezza Architecture: Nodes, S-Blades, FPGA, Disk Enclosures.

· Efficient usage of Netezza DDL Statements – Derived Tables, EXTERNAL Tables, Materialized Views.

· Hands on Knowledge on Netezza Concepts – Data Distribution, Zone-Maps.

· Understand the Concept of Locking Mechanisms in Netezza.

· Experience on Query Tuning mechanisms using proper usage of Statistics in Netezza.

· Efficient in Writing SQL’s with complex joins, aggregations, UNIX Scripts.

· Good understanding of Data Warehouse Modeling concepts.

· Experience in using the built in Netezza Functions.

· Efficient in writing NZSQL and NZLOAD Scripts and executing the scripts.

· Responsible for writing efficient views based on user and reporting requirements.

· Must be able to provide Solutions or Enhancements to fix the data issues quickly when reported by the clients or users.

· Flexibility to Self-learn and understand the system, further assist with query tuning and application performance.

Preferred

· At least 4 years of experience in software development life cycle stages.

· Certification in Netezza.

· At least 4 years of experience in Project life cycle activities on development and maintenance projects.

Qualifications

Qualifications


Basic

· Bachelor’s degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education.

· Minimum of 4+ years of work experience in the Information Technology Field.

· Minimum of 4+ years of hands on Netezza experience.

· Experience in full software development lifecycle of the Data Warehousing Project.

· Strong knowledge of Netezza Architecture: Nodes, S-Blades, FPGA, Disk Enclosures.

· Efficient usage of Netezza DDL Statements – Derived Tables, EXTERNAL Tables, Materialized Views.

· Hands on Knowledge on Netezza Concepts – Data Distribution, Zone-Maps.

· Understand the Concept of Locking Mechanisms in Netezza.

· Experience on Query Tuning mechanisms using proper usage of Statistics in Netezza.

· Efficient in Writing SQL’s with complex joins, aggregations, UNIX Scripts.

· Good understanding of Data Warehouse Modeling concepts.

· Experience in using the built in Netezza Functions.

· Efficient in writing NZSQL and NZLOAD Scripts and executing the scripts.

· Responsible for writing efficient views based on user and reporting requirements.

· Must be able to provide Solutions or Enhancements to fix the data issues quickly when reported by the clients or users.

· Flexibility to Self-learn and understand the system, further assist with query tuning and application performance.

Preferred

· At least 4 years of experience in software development life cycle stages.

· Certification in Netezza.

· At least 4 years of experience in Project life cycle activities on development and maintenance projects.

Additional Information

** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Note:-

  1. This is a Full-Time Permanent job opportunity for you.
  2. Only US Citizen, Green Card Holder, TN Visa, GC-EADH4-EAD & L2-EAD can apply.
  3. No OPT-EAD & H1B Consultants please.
  4. Please mention your Visa Status in your email or resume.

Skills Required

  • Bachelor's degree or foreign equivalent (or equivalent work experience)
  • Minimum 4+ years of work experience in Information Technology
  • Minimum 4+ years of hands-on Netezza experience
  • Experience in full software development lifecycle of Data Warehousing projects
  • Strong knowledge of Netezza architecture (Nodes, S-Blades, FPGA, Disk Enclosures)
  • Efficient usage of Netezza DDL statements (Derived Tables, External Tables, Materialized Views)
  • Hands-on knowledge of Netezza concepts (Data Distribution, Zone-Maps)
  • Understanding of locking mechanisms in Netezza
  • Experience with query tuning using proper usage of statistics in Netezza
  • Proficient writing complex SQL (joins, aggregations) and UNIX scripts
  • Good understanding of data warehouse modeling concepts
  • Experience using built-in Netezza functions
  • Ability to write and execute NZSQL and NZLOAD scripts
  • Responsible for writing efficient views based on user and reporting requirements
  • Ability to provide solutions or enhancements to quickly fix reported data issues
  • Flexibility to self-learn and assist with query tuning and application performance
  • Certification in Netezza
  • At least 4 years experience in software development lifecycle stages
  • At least 4 years experience in project lifecycle activities on development and maintenance projects
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
87 Employees
Year Founded: 2007

What We Do

SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.

Similar Jobs

SonSoft Inc. Logo SonSoft Inc.

IBM Netezza

Information Technology • Professional Services • Software • Consulting
In-Office
Charlotte, NC, USA
87 Employees

SonSoft Inc. Logo SonSoft Inc.

IBM Netezza

Information Technology • Professional Services • Software • Consulting
In-Office
Charlotte, NC, USA
87 Employees

SonSoft Inc. Logo SonSoft Inc.

IBM Netezza

Information Technology • Professional Services • Software • Consulting
In-Office
Charlotte, NC, USA
87 Employees

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account