Vertica Developer

 (4-6+ Yrs experience desired, Individual Contribution Role)

•     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

•     Write vsql scripts to process data.

•     Perform bulk data loads from flat files to Vertica.

•     Hands on experience and proficient in data processing using Scala.

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

Technical Skills and Competencies in Vertica & Scala :-

•     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

•     Hands-on experience in data processing using Scala SQL \ Python.

•     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, and/or Oracle, SQL

Behavioral Competencies:

•     Proactive, Quick Learner, Problem Solver & Decision Maker.

•      Good analytical & communication skills

Flexibility to work across time zones and diverse cultures