Data Warehouse System Architecture with Amazon Web Services (AWS)

SailoTech 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.

Position: Data Warehouse System Architecture with Amazon Web Services (AWS)

Location – mid-town, NY

Duration: 6 Months

Job 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 Architec

All your information will be kept confidential according to EEO guidelines.