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, tune and support Netezza-based data warehouse solutions. Write NZSQL/NZLOAD and UNIX scripts, optimize queries using statistics, create views and DDL objects, assist in architecture and on-call application support, and resolve data issues for reporting and analytics.
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

  • 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.

Qualifications

  • 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.
  • At least 2 years of experience in Design and Architecture review.
  • At least 2 years of experience in application support and maintenance (including some experience on-call support).
  • Good Analytical skills.
  • High impact communication.
  • Ability to ramp up in new technologies.
  • Ability to work in a team, in diverse/ multiple stakeholder environment.
  • Experience and desire to work in a Global delivery environment.

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 substitution)
  • 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 statistics in Netezza
  • Proficient SQL skills including complex joins and aggregations
  • Experience writing UNIX scripts
  • Good understanding of Data Warehouse modeling concepts
  • Experience using built-in Netezza functions
  • Proficient writing and executing NZSQL and NZLOAD scripts
  • Responsible for writing efficient views based on reporting requirements
  • Ability to diagnose and quickly fix data issues and provide enhancements
  • Flexibility to self-learn and assist with query tuning and application performance
  • Certification in Netezza
  • At least 2 years experience in design and architecture review
  • At least 2 years experience in application support and maintenance including some on-call support
  • Good analytical skills and high-impact communication
  • Ability to work in a team with diverse/multiple stakeholders and in a global delivery environment
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