Redshift Lead


West Point, PA

Industry: IT Consulting/Services


5 - 7 years

Posted 286 days ago

  by    Cynet Sytems

This job is no longer available.

We are looking for Redshift Lead for our client in West Point, PA

Job Title: Redshift Lead

Job Location: West Point, PA

Job Type: Contract ? 12 Months / Contract to Hire / Direct Hire

Job Description:

  • Have atleast 4year of extensive experience in Redshift including in depth Redshift architecture, Distribution style, sort key,sizing/resizing ,SQL & other features of Redshift
  • Experience in assessing & recommend appropriate sizing of cluster based on need of project
  • Have hands on experience in Teradata SQL and utilities(preferred)
  • Have little hands on experience working on Aqua data studio SQL as well ER Model to reverse engineer to generate DDLs from model
  • Have hands on experience on AWS Schema conversion and should be in position to refactor Redshift object definition based on need

Role & Responsibilities:

  • Interact with technical analyst to understand & propose changes to Redshift
  • Understand the migration strategy
  • Assess design, build and migration process
  • Discuss and review migration strategy
  • Understand the objects to be created in Redshift & Downstream access views
  • Changes in the redshift objects after migration
  • Helps the Test lead in creation of SIT test cases, understating the requirement & SIT execution
  • UAT support & Documentation