Skill: bi , storage , database development , sql , postgresql , software engineer , problem solving; Exp: 5-8 years; YASH DWH team is looking for RedShift Developer with experience in BI & DWH projects. The shortlisted candidate should have strong communication, interpersonal, analytical and problem solving skills. Should have an ability to effectively communicate technical concepts within the team, and is able to work individually or as part of a team to achieve project goals. Primary Skills Overall 5 yrs Database Development & 2 yrs exp in Redshift Exposure to Redshift architecture & development is must Strong in writing complex queries. Exp in Query Optimization & Performance tuning (Redshift/PostgreSQL) Exp in S3 bucket, EC2, RedShift DB Good Knowledge on EMR, Data Pipeline. Strong Experience in SQL. Expert knowledge of relational and dimensional data concepts Strong analytical skills, above average written and verbal communication skills and strong decision making capabilities Self-motivated, ability to work independently with minimal direction and be team oriented with ability to communicate to a wide variety of audiences Desirable Skills Exposure to Redshift architecture & development is must. Roles and Responsibilities Design and create tables in redshifts by defining proper distribution key, sort key and compression technique Loading/Unloading data to and from Amazon Redshift Experience in creating S3 buckets in the AWS environment to store files, Need to create snapshots to take backups of the volumes Need to work in Amazon Simple Storage Service(S3) for Amazon Redshift data load. Creating Query queues for avoiding query execution delay for better performance. Working with System catalog tables for troubleshooting and query optimization Apply best practices Interact with Business users and understand their requirements Technical expertise regarding data models and database design Creating and maintain technical design documentation.
Function: IT Software : Software Products & Services