Previous Job
Redshift Architect
Ref No.: 17-29020
Location: Modesto, California
Job Description:-

Must Have
In depth knowledge of key AWS services like EC2, S3,Redshift Database, Data Pipeline etc.
Ability to run and build Spark Code on Amazon EMR.
Experience in provisioning and spinning up AWS Clusters
Should be able to design a logical ELT Data Lake Architecture on AWS showing how various components interact with each other.
Should have basic understanding of core Data Warehousing and Business Intelligence Concepts.
Should be able to explain Facts, Dimensions, OLAP cubes, ODS, Data Marts, Data lakes etc.
Proven experience assessing clients workloads and technology landscape for Cloud suitability,
Develop business case
Cloud adoption roadmap
Experience in defining new architectures and ability to drive project from architecture standpoint.
Ability to quickly establish credibility and trustworthiness with key stakeholders in client organization.
Excellent verbal, written and presentation skills.

Good to have
Experience in building scalable production systems (load balancers, memcached, master/slave architectures)
Certification on AWS architecture desirable.
Experience on Redshift database
Writing SQL queries including advanced SQL concepts like windowing functions (rank, dense rank etc.). Good at bash scripting.
Understanding of MPP distributed databases like Redshift, Netezza or Teradata.
Designing the overall Virtual Private Cloud VPC environment including server instance, storage instances, subnets, availability zones, etc
Designing the AWS network architecture including VPN connectivity between regions and subnets