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, DDLs, views, and UNIX scripts. Perform query tuning using statistics, resolve data issues, apply Netezza architecture and distribution concepts, and support full SDLC for development and maintenance projects.
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 relevant work experience)
  • Minimum 4+ years of work experience in Information Technology
  • Minimum 4+ years of hands-on IBM Netezza experience
  • Experience in full software development lifecycle of Data Warehousing projects
  • Strong knowledge of Netezza architecture (Nodes, S-Blades, FPGA, Disk Enclosures)
  • Proficient use 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 in Netezza using statistics
  • Proficient writing of complex SQL (joins, aggregations) and UNIX scripts
  • Understanding of Data Warehouse modeling concepts
  • Experience using built-in Netezza functions
  • Ability to write and execute NZSQL and NZLOAD scripts
  • Responsible for designing efficient views based on user and reporting requirements
  • Ability to provide solutions/enhancements to quickly fix reported data issues
  • Flexibility to self-learn and assist with query tuning and application performance
  • Authorized to work in the U.S. (US Citizen, Green Card, TN, GC-EAD, H4-EAD, L2-EAD); employer unable to sponsor
  • Netezza certification
  • At least 4 years experience in software development life cycle stages (preferred)
  • At least 4 years experience in project lifecycle activities on development and maintenance projects (preferred)
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