"**AWS Redshift Developer****Preferred Qualifications****AWS Redshift Developer****LOCATION: BOSTON, MA****NOTE:** **We are unable to provide visa sponsorship for this role at this time. No candidates requiring visa sponsorship will be considered.****Our Team**We are building and transforming an application on Asset management, Trading and brokerage & Securities Services/Custodial Services for one of the top tier Investment bank and we are looking for resources with strong AWS Data migration.**Your Opportunity**You will be responsible for applying your extensive knowledge as a Software development, designing and help us in our vision to become a reality. You will bring in ability to understand business requirements/process flows/ and come up with code development that would help us achieve our goal.**Our Ideal Candidate**We are looking for a strong AWS data resources who thrives on research and development projects. Be a strong technical hand who work efficiently to make sure we are building the right code and services using the right coding principles. The candidate should be able help in the digital transformation journey for the top tier investment bank.**Your Responsibilities**+ Experience with most of the cloud products such as Amazon AWS+ Strong technical skills in Netezza, Python, Oracle+ Good working experience in migrating large databases to Redshift.+ AWS Redshift experience for DB design+ 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 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,+ Responsible for helping to create a knowledge base for further reference by the production support team.+ Initial Cloud Infra Setup as per requirement, if required in case of the complex Solutions.+ Knowledge on hybrid public cloud design concepts+ An understanding of application hosting, integration and resilience principles**Qualification & Experience:**+ BE / B.Tech [CS / EC / IT].+ 4-7 Years of experience+ Minimum 4 years experience in Cloud Architecture Designing and Infra setup. Must have independent hands-on experience of designing and implementing solutions for cloud projects.+ AWS Certified Solution Architect Professional or equivalent or AWS Certified Solutions Architect with 2 Yrs. exp post certification.+ Excellent oral and written communication skills.+ Cloud Specific Security/Privacy Certification is desired.**_At Oracle, we dont just value differenceswe celebrate them. Were committed to creating a workplace where all kinds of people work together. We believe innovation starts with diversity and inclusion._**https://www.oracle.com/corporate/careers/culture/diversity.html**Detailed Description and Job Requirements**Intermediate consulting position operating independently with some assistance and guidance to provide quality work products to a project team or customer that comply with Oracle methodologies and practices. Performs standard duties and tasks with some variation to implement Oracle products and technology to meet customer specifications.Standard assignments are accomplished without assistance by exercising independent judgment, within defined policies and processes, to deliver functional and technical solutions on moderately complex customer engagements.2-5 years of overall experience in relevant functional or technical roles. Undergraduate degree or equivalent experience. Product or technical expertise relevant to practice focus. Ability to communicate effectively and build rapport with team members and clients. Ability to travel as needed.**Oracle is an Affirmative Action-Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, protected veterans status, age, or any other characteristic protected by law.****Job:** Consulting**Location:** US-Massachusetts**Job Type:** Regular Employee Hire**Organization:** OFSS"