Role: Redshift Architect
Location: Richmond, VA
Duration: 12 Months
Job Description:
- Responsible for creating and maintaining Redshift cluster
- Responsible for design, development of Redshift schema and tables
- Responsible for design, development, automation of the process to load data into AWS
- Recommend data architecture and design and document Best Practice for Redshift
- Present and defend approach using reference materials, standard methods and logic.
Skills:
- Exposure on Creating Redshift cluster; resizing cluster; snapshots and restore
- Knowledge of internal architecture of Redshift and MPP technology
- Have hands on experience on Redshift schema design, performance optimization, capacity planning
- Hands on experience with Redshift Copy commands, data types etc.
- Worked extensively in performance tuning, load distribution, defining sort keys, distribution keys, query performance
- Exposure on AWS Services EC2; EMR; SQS; SNS; Lambda; S3; Glacier a plus.
- Experience working with Amazon Web Services RDS, SNS/SQS/SWF, Pig and/or Hive is preferred
- Solid understanding of SQL and have worked extensively with SQL
- Competent working in Linux development environment
- Experience with various data structures, information management concepts and big data concepts in order to determine the appropriate implementation of the solution
- Able to design and implement automation of the process using scheduling tools like data pipeline or SWF.
- Good at documentation of the data flow, process flow, detail design
Send resume to adelina@jobs-n-jobs.com
Comments