Hiring for Vertica Developer - Bi/dw/etl in Pune, for Exp. 4 - 8 yrs at Premium.

  • Esteemed client of Orion TrueTech Services India
  • Pune, Maharashtra, India
  • Sep 13, 2017
Full time IT / Telecommunication Jobs

Job Description

Job Description:Developer (2-4 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 &amp amp amp 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 &amp amp amp 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 &amp amp amp Decision Maker. - Good analytical &amp amp amp communication skills