Company DescriptionSailoTech is an Enterprise Business Software (ERP, CRM, SCM, BI) consulting company with primary focus on mid-size organizations across industries. It helps its clients manage every aspect of their ERP Initiative, from strategic planning to everyday operations.Job DescriptionPosition: Data Warehouse System Architecture with Amazon Web Services (AWS)Location – mid-town, NYDuration: 6 MonthsJob Description:Candidate should be able to exhibit the following expertise· Own the development of Redshift Data Model as part of a CMT client based out of NY.· Design, Develop and Test Integration of RedShift with S3 Storage, ETL & Reporting technologies· Best Practices on RedShift Data Mart designs· Work with key business representatives, data owners, end users, application designers and data architects to model current and new data.· Familiarization on concepts like Distribution styles, Distribution keys and Sort keys· Compression level considerations and knowhow· Able to articulate how security is applied in Redshift· · Complete familiarity with Redshift underlying architecture in terms of Leader Nodes, Compute Nodes, slices and how data is distributed, how a request for a table data is resolved. The candidate should also know Microsoft BI.Preferred certification: AWS ArchitecAdditional InformationAll your information will be kept confidential according to EEO guidelines.