Data Architect -(SQL, Redshift, AWS , MongoDB) - Immediate Joiner

Role : Data Architect

Exp : 11 – 15 yrs

Location : Pune – Hybrid Model -3 days in a week ( Job location: Pune ( willing to work 3 days from office)

Mode of Hire – Permanent /FTE

Job Summary:

An expert Data Architect, who has worked on Redshift/warehousing concepts. Need extensive experience on reporting and performance tuning

Job Description:

Technical stack: SQL, Redshift, EMR, S3, AWS , MongoDB/AWS Document DB, MYSQL, Athena, Data Warehouse

Key Points:
• Be able to create an efficient physical database design from a logical data model and application specifications.
• Must possess in-depth SQL knowledge, understand SQL code
• Proficient in tuning SQL queries to improve the database performance and availability.
• Familiar with NoSQL database such as MongoDB or AWS Document DB.
• Have experience with Linux operating system and MySQL.
• Have experience in AWS services like AWS EC2, RDS, Redshift, Athena, Cloudwatch, etc.
• Have expertise in managing AWS Redshift access privileges and creating roles, users, groups.
• Have expertise in loading/unloading data from Amazon Redshift.
• Proficient in maintaining and tuning AWS Redshift data warehouse to improve the cluster performance and availability.
• Ability to use PowerBI and create basic dashboards.
• Familiarity with database version control tools such as Flyway.