Datawarehouse Analyst, AWS Redshift

Candidate should have :

Experience with Redshift Datawarehouse, S3 data lake, Firehose Data Prep & Lambda Data Prep.

Experience in Migration of on-premise database structures to AWS Redshift data warehouse

Optimizing and tuning the Redshift environment, enabling queries to perform faster for Analytic tools, such as Dashboards.

Ability in Writing scripts and indexing strategy for migration to Confidential Redshift from SQL Server

Experience in Using JSON schema to define table and column mapping from S3 data to Redshift

Ability in Implementing and Managing ETL solutions and automating operational processes.

Experience developing data warehouses using RedShift.

Knowledge in AWS Data Pipeline to configure data loads from S3 into Redshift