22529 - InfosysX - Vertica Technical Consultant- Sunnyvale CA
Previous Job
Previous
22529 - InfosysX - Vertica Technical Consultant- Sunnyvale CA
Ref No.: 18-39546
Location: Sunnyvale, California
Position Type:Right to Hire
Start Date: 06/07/2018
 Title: Vertica Technical Consultant
Project: InfosysX
Job Code: 22529
Duration: 3-6 Months Contract to Hire (CTH)
Location: Sunnyvale CA
Client: Infosys/Apple
Visa Accept: USC/GC/TN Visa/GC-EAD/L2-EAD Only
Rate: $70-85/hr on C2C (All Inc)

 
Must Have Skills:
  • Vertica
  • Teradata
  • Oracle
  • Unix
  • Python
 
Job Description:
  • Strong knowledge in PL/SQL and DBMS concepts. Should have few years of hands-on experience in databases like Oracle or Teradata.
  • Should have good knowledge and experience in scripting using Unix shell or Python.
  • Should be strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies
  • Should have 2-3 years of experience on Vertica database as a developer in various projects and good work experience and knowledge on Vertica DB and architecture.
  • Knowledge on Projections, Super-Projections, Buddy-Projections and Pre-Join Projections in Vertica
  • Understanding & knowledge on High Availability, Replication and K-Safety in Vertica.
  • Understanding on segmentation, compression techniques and encoding, load balancing techniques in Vertica
  • Creation of schemas, data bases, users, nodes and grants on tables, users, databases
  • Performance tuning the queries in Vertica
  • Work closely with business stakeholders, understand the requirements, address problems with most optimal solution
  • Should be able to do multitasking in a highly dynamic work environment to efficiently contribute to project.
  • Take ownership in systematically designing and executing activities and processes to ensure required support is provided to the client
  • Proactively brainstorm and come up with new ideas to improve processes and improve client satisfaction
  • Volunteer to develop the overall subject matter expertise of our team by conducting internal knowledge sharing sessions etc.
  • Being an active member to learn and share expertise
  • Should have good communication skills