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