Vertica Developer

Soft tech Career Info system Pvt. Ltd
  • Pune
  • 10-12 lakh
  • 2-4 years
  • Views
  • 28 Dec 2016

  • Software Design & Development

  • IT/ Technology - Software/ Services
Job Description

 Provide technical solution for data warehousing and/or BI and similar systems.
· Ability  to understand high level technical solution & develop solution/code using Vertica technology
· Ability to do low level designing
· Ability  to do activities from ETL Development to Deployment. Should be able to Code, Unit Test & Deploy
· Effectively handle multiple work assignments, while consistently deliver high quality work
· Develop Informatica mappings and mapplets to implement the business rules as per table specification documents.
· Create Informatica Sessions and Workflows.
· Write bteq/vsql scripts to process data.
· Perform bulk data loads from flat files to Vertica.
· Tune performance of Informatica sessions, identify and resolve performance bottleneck issues in source/target Informatica mapping.
· Prepare deployment guide with all the code that has to be migrated to QA/Production environment.
· Coordination with System Testing team to migrate the code to QA System Testing.
· Work with System Testing and UAT teams to analyze and resolve opened defects.
· Provide 24/7 support during the warranty period to projects after deployment to Production.

Technical Skills and Competencies in Vertica :-

· Should have good knowledge of Vertica and cluster Architecture (WOS,ROS,HA)
· Should have good knowledge of Vertica Components like : Logical and Physical Schemas, Databases
· Should be an expert in using complex Vertica SQL ,Flex tables etc
· Should be experienced in Performance Tuning in Vertica which includes creation of projection, partition swapping etc
Hands-on implementation of E2E Vertica components
· Should have good knowledge of BI and Data Warehousing and ETL and data modelling.
· Should have good knowledge of Informatica, Teradata and/or Oracle, SQL, Unix
 Behavioral Competencies
· Proactive, Quick Learner, Problem Solver & Decision Maker.
· Good analytical & communication skills

Competencies/Skill sets for this job

Develop Solution Data Modelling Designing Etl Development

Job Posted By

O.P. Chawla