Vertica Developer - Bi/dw/etl

Soft tech Career Info system Pvt. Ltd
  • Pune
  • 10-15 lakh
  • 2-7 years
  • Views
  • 28 Sep 2016

  • IT/ Information Technology

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

Job Posted By

O.P. Chawla