SQL Developer - Redshift

Responsibilities : - Design, develop, and refine data warehouse solutions utilizing Amazon Redshift and SQL-based technologies to meet business intelligence and analytics demands. - Create and manage database schemas, tables, views, stored procedures, and ETL processes essential for data transformation and storage in Redshift clusters. - Craft intricate SQL queries, scripts, and optimizations for efficient extraction, transformation, and analysis of large datasets stored within Redshift databases. - Execute performance tuning activities, query optimization techniques, and indexing strategies to enhance the scalability and efficiency of Redshift environments. - Collaborate closely with data engineers, data scientists, and business stakeholders to comprehend data necessities and implement appropriate data models and solutions. - Troubleshoot data warehouse issues, address data integrity challenges, and offer technical support and guidance to end-users. - Stay abreast of advancements in AWS Redshift technology, features, and best practices, contributing to the ongoing enhancement of data warehouse solutions. Requirements : - Bachelor's or Master's degree in Computer Science, Information Technology, or a related field. - Proven track record as a database developer or data engineer, showcasing proficiency in Redshift and SQL development. - Strong grasp of data warehouse principles, dimensional modeling, and ETL processes. - Hands-on experience with AWS services, including Redshift, S3, Glue, and Lambda. - Expertise in SQL programming, including query optimization and performance tuning techniques. - Exceptional problem-solving skills, analytical thinking, and communication abilities. Skills : - Redshift Development : Proficient in designing, developing, and optimizing data warehouse solutions using Amazon Redshift. - SQL Programming : Skilled in crafting complex SQL queries, scripts, and optimizations for comprehensive data analysis and manipulation. - ETL Processes : Experienced in implementing efficient ETL processes for seamless data extraction, transformation, and loading into Redshift databases. - Collaboration : Capable of working collaboratively with cross-functional teams to effectively fulfill data requirements. Preferred : - Certification in AWS, such as AWS Certified Solutions Architect or AWS Certified Data Analytics Specialty, demonstrating advanced proficiency in AWS services. - Familiarity with other cloud-based data warehousing platforms like Google BigQuery or Snowflake, broadening the candidate's skill set (ref:hirist.tech)

Location: Mumbai, IN

Posted Date: 4/24/2024