Job Description
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.
💡 Quick Summary
Seeking a career-building opportunity? The Data Architect -(SQL, Redshift, AWS , MongoDB) - Immediate Joiner position is now open for candidates interested in the IT Engineer & Developer Jobs sector. This role in Pune offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in IT Engineer & Developer Jobs is a plus.
