AWS Datawarehouse Architect Jobs in Hyderabad,India - 25118205

Job Description:

OSI Digital, Inc, (formerly OSI Consulting, Inc) provides purpose-built business and technology solutions that optimize performance to enable data-driven outcomes for our customers OSI accelerates digital transformation by offering integrated solutions that capture, secure, integrate, analyze and optimize data Our services include the design, development and implementation of new solutions as well as the ongoing management, enhancement and support of our customers existing business systems

OSI Digital was founded in 1993, in California and has since expanded to a team of over 1,400 employees worldwide We have offices in the US, Canada, India, Philippines, Dubai and Australia Our main o shore delivery center of excellence is located at our state-of-the-art campus in Hyderabad, India, with additional locations in Chennai, Delhi and Bangalore For over 25 years, we have supported a diverse portfolio of customers across various industries, including Software & Business Services, Financial Services, Life Sciences & Healthcare, Manufacturing, Energy, Retail and Agriculture

Our client base ranges from start-ups to Fortune 500 corporations, including Exelon, GE, Hyundai, Toyota, Gilead, Allergan, Yamaha, Gap and Skechers OSI Digital has developed strong partner alliances with the worlds leading technology providers such as Tableau, Salesforce, Oracle, Microsoft, GE, Amazon Web Services, Dell Boomi and Red Hat



Job Title AWS Datawarehouse Architect

Location Irvine, CA

Position Type Contract or Full Time

Job Summary

The Ideal candidate will have deep understanding and experience developing data warehouse using AWS services such as data lake, Python, Spark, R, AWS Redshift, AWS Glue, Lambda, Data Pipeline, Data migration services Should have in-depth hands-on experience with the following AWS services - EMR, Glue, RDS, Redshift, Redshift Spectrum, Lambda, Data Pipeline

Skills

Experience developing data warehouses using RedShift
Implementing and Managing ETL solutions and automating operational processes
Experience with Redshift Datawarehouse, S3 data lake, Firehose Data Prep & Lambda Data Prep
Optimizing and tuning the Redshift environment, enabling queries to perform faster for Analytic tools, such as Dashboards
Migration of on-premise database structures to AWS Redshift data warehouse
AWS Data Pipeline to configure data loads from S3 into Redshift
Using JSON schema to define table and column mapping from S3 data to Redshift
Writing scripts and indexing strategy for migration to Confidential Redshift from SQL Server
A minimum of 3 - 5 years of experience in building data warehouses, ETL both on-premise as well as cloud
Strong SQL background and should be familiar with the AWS Redshift environment
2 years of hands-on experience with Cloud platform AWS Redshift
Extensive knowledge in designing and configuring AWS services for Data warehouse data migration from on-premise to cloud
Python experience that will be a plus
Good Communication skills
Be a self-starter and be motivated to provide a solid product quality and customer experience
Possess effective skills for analyzing, evaluating and troubleshooting

Profile Summary:

Key Skills: