RedShift Architect

Job Description

We are looking for AWS Redshift (Developer / Data Architect) with 3-5 years of experience. A Professional with expertise and passion for building large scale distributed systems. Experience with parallel query optimization and execution, large scale data analytics, replicate data storage.

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, Elastic Container Service, AWS Lambda, AWS Aurora, AWS RDS, AWS Route 53, ElasticSearch, Redis, Elasticache.

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

  • 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 Oracle database.

  • 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

  • Maintain high team morale.

  • Adhere to company and project standards and guidelines.

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

  • Pay high attention to detail in all work.

  • Quality, on time delivery of agreed deliverables.

Educational Qualification:

  • Bachelor's degree in Computer Science or related field.