Vertica Developer

Job description

Exp: 2 to 4 years PR: 15 LPA Work location: Pune(can consider Relocation) 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 & 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 Hi, We have multiple openings for different location, for different clients. If you are interesting in plz find the attached details. Closing Block Full Name (As per PAN CARD): Self Mobile number: Alternate Number: Email Address: Total Experience: Relevant Experience: Highest Qualification (Degree): Current Employer name (Payroll): Current Designation: Current CTC (Annual) Expected CTC (Annual) Official Notice Period (As per Offer Letter): Can join in (Days): Any Interviews / Offers in Pipeline: Current Location: Work / Requirement Location: Date of Birth: PAN card Number: Interview Timings: Squircle IT Consulting Services is a leading IT solutions and services company established with a specific mission of providing comprehensive, top of the line solutions around ERP and BI. Since its inception in November, 2007, SQUIRCLE has emerged as a key player in ERP and BI space. SQUIRCLE brings together the best Technology and Domain expertise in PeopleSoft to offer a full spectrum of services ranging from Implementation, Business Consulting to Support.