Senior AWS Redshift Developer

"**Senior AWS Redshift Developer****Preferred Qualifications****Senior 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 of software development, designing and helping us in our vision to become a reality. You will bring your 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 resource who thrives on research and development projects. You will be a strong technical hand who works efficiently to make sure we are building the right code and services while 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 database design+ Experience as developer in multiple cloud technologies including **AWS** EC2 **, S3** , VPC, VPN, and 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 Netezza 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]+ 8-12 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.+ Nice to have AWS Certified Solution Architect Professional or equivalent or AWS Certified Solutions Architect with 2 years of experience 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**An experienced consulting professional who has a broad understanding of solutions, industry best practices, multiple business processes or technology designs within a product/technology family. Operates independently to provide quality work products to an engagement. Performs varied and complex duties and tasks that need independent judgment, in order to implement Oracle products and technology to meet customer needs. Applies Oracle methodology, company procedures, and leading practices.Operates independently to provide quality work products to an engagement. Performs varied and complex duties and tasks that need independent judgment, in order to implement Oracle products and technology to meet customer needs. Applies Oracle methodology, company procedures, and leading practices. Demonstrates expertise to deliver functional and technical solutions on moderately complex customer engagements. May lead the solution design and implementation aspects of engagement(s) ensuring high quality, integrated software solutions within constraints of time and budget. May act as the team lead on projects, providing coaching, guidance and feedback to develop skills of team members. Effectively consults with management of customer organizations. Participates in business development activities. Develops and leads detailed solutions for moderately complex projects.6-8 years of experience relevant to this position including 3-4 years consulting experience preferred. Undergraduate degree or equivalent experience preferred. Product or technical expertise relevant to practice focus. Ability to communicate effectively. Ability to 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"