Company Description

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.

Location : Pune

Shift : 1:00 PM – 10:00 PM

PR : 14 LPA

NOTE::Do not share simple ETL/INFORMATICA Developer Profiles here, need vertica exp as well.

Vertica Developer having Informatica experience

DOJ:- ASAP or less than 15 days

: 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 valuable 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

Additional Information

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

📌 Vertica Developer ::Pune.
🏢 SQUIRCLE IT CONSULTING SERVICES
📍 Pune