aws redshift (developer / data architect).

JD:-

We are looking for AWS Redshift (Developer / Data Architect) with 3-5 years of experience.

Experience with parallel query optimization and execution, large scale data analytics, replicate data storage.

Requirements

Desired Knowledge and Skills:

•Experience with most of the cloud products such as Amazon AWS.

•Experience as developer in multiple cloud technologies including AWS EC2, S3, VPC, VPN, Amazon API Gateway, AWS ECS, AWS Glue, EMR, AWS Lambda, AWS Aurora, AWS RDS, AWS Route 53, ElasticSearch, Redis, Elasticache.

•Good knowledge on AWS environment and Service knowledge with S3 storage understanding.

•Good knowledge on Big Data environment and Service knowledge of Sqoop, MapR and Spark.

•Must have hands on experience of Amazon Redshift Architecture.

•AWS Redshift experience for DB design

•AWS Pipeline knowledge to develop ETL for data movement to Redshift, experience to map the source to target rules and fields.

•Strong in writing complex queries with nested joins and derived tables.

•Candidate should have good knowledge of designing data warehouse schema.

Other Skills / Responsibilities:

•Translating functional and technical requirement into detailed architecture and design

•Coding and testing complex system components

•Participating in code and design reviews to maintain out high development standards

•Able to perform technical root cause analysis and outline corrective action for given problems

•Excellent verbal and written communication skills, demonstrating the ability to communicate technology concepts to non-technology personnel

•Promptly escalate issues, which affect product delivery and quality that are beyond scope of influence and report same to reporting manager.