Job Description :
AWS Redshift Schenectady, New York Contract 5+ year of leadership experience Deep knowledge of AWS cloud platform and services - should have worked on AWS for over 2 years. Experience as developer in multiple cloud technologies including AWS Redshift, EC2, S3, VPC, VPN Good knowledge on AWS environment and Service knowledge with S3 storage understanding. Must have hands on experience of Amazon Redshift Architecture. AWS Redshift experience for DB design/Migration AWS Pipeline knowledge to develop ETL for data movement to Redshift, experience to map the source to target rules and fields. AWS glue, AWS Lamda or similar tool experience preferred. Strong in writing complex queries with nested joins and derived tables. Candidate should have good knowledge of Greenplum/Postgres database. Candidate should have good knowledge of designing data warehouse schema. Hands-on experience in scripting languages like Python Able to perform technical root cause analysis and outline corrective action for given problems Provide consistent database maintenance, optimization and best practices inputs to existing Redshift and SQL databases, data lake, SQL engines, and applications. Proficient SQL/Performance tuning skills Excellent Communication and customer management skills