Job Description :
Position:  Data and ETL Engineers
Location: Remote
Duration: 9 Months 
Client: Trianz
End Client: Mass Mutual
Rate: $55 - $60/hr. on W2
Senior Data and ETL Engineers with minimum 12 years who will bring experience in
Job Description:
  • Informatica
  • Teradata
  • Python
  • Vertica
  • SQL expertise to deliver tasks with higher complexity.
  • AWS is an added advantage 
Responsibilities : 
  • 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 bteqvsql scripts to process data.
  • Perform bulk data loads from flat files to Vertica.
  • Provide 247 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)  , Components like : Logical and Physical Schemas, Databases
  • Should be experienced in Performance Tuning in Vertica which includes creation of projection, partition swapping etc
  • 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

Similar Jobs you may be interested in ..