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.
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.
- 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.
- 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.
** 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:-
- This is a Full-Time Permanent job opportunity for you.
- Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.
- No OPT-EAD & H1B Consultants please.
- Please mention your Visa Status in your email or resume.
Similar Jobs
Information Technology • Professional Services • Software • Consulting
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.
Top Skills:
Data DistributionDerived TablesExternal TablesFpgaIbm NetezzaMaterialized ViewsNetezza DdlNodesNzloadNzsqlQuery TuningS-BladesSQLStatisticsUnixZone-Maps
Information Technology • Professional Services • Software • Consulting
Design, develop, and support Netezza-based data warehouse solutions: write NZSQL/NZLOAD scripts, tune queries, use Netezza DDL and functions, model data, and provide application support and performance optimization across the SDLC.
Top Skills:
Data Warehouse ModelingData WarehousingExternal TablesFpgaMaterialized ViewsNetezzaNetezza DdlNzloadNzsqlSQLUnixZone-Maps
Information Technology • Professional Services • Software • Consulting
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.
Top Skills:
Derived TablesExternal TablesFpgaMaterialized ViewsNetezzaNzloadNzsqlSQLUnixZone-Maps
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
