Ekfrazo Technologies - Data Architect - SQL/Amazon Athena (11-15 yrs)

Role : Data Architect.

Exp : 11 - 15 yrs.

Location : Pune - Hybrid Model -2 -3 days in a week.

Job Summary :

- An expert SQL Developer DBA, 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.