Redshift Lead

Confidential Company  •  West Point, PA

5 - 7 years experience  •  IT Consulting/Services

Salary depends on experience
Posted on 03/03/18 by Cynet Sytems
Confidential Company
West Point, PA
5 - 7 years experience
IT Consulting/Services
Salary depends on experience
Posted on 03/03/18 Cynet Sytems

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

Not the right job?
Join Ladders to find it.
With a free Ladders account, you can find the best jobs for you and be found by over 20,0000 recruiters.