AWS Redshift Engineer

Viaprom Technologies; Mumbai; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Viaprom Technologies Pvt Ltd is seeking an AWS Redshift Engineer to design and implement scalable data warehousing solutions in AWS Redshift, driving data modeling and ETL processes.

The ideal candidate will collaborate with cross-functional teams, optimize query performance, and ensure data quality and security. Strong SQL skills, familiarity with SSIS or similar ETL tools, and understanding of Agile workflows are essential.

Qualifications

• Strong understanding of data modeling and DB design.
• Experience with ETL tools (SSIS or similar).
• Proficient in writing complex queries and tuning performance.
• Excellent problem-solving and attention to detail.
• Ability to collaborate with cross-functional teams and communicate with stakeholders.
• Familiarity with Agile and Git for version control.

Responsibilities

• Design, develop, and maintain large-scale data warehouses using AWS Redshift.
• Collaborate with cross-functional teams to identify business requirements and design data models.
• Develop and implement ETL processes to load data into the warehouse.
• Optimize query performance and troubleshoot data quality issues.
• Ensure security and scalability standards.
• Participate in code reviews and improve code quality.

Skills

Data modeling

ETL processes

SQL performance

Team collaboration

Git version control

Agile development

Problem solving

Tools

SSIS

Job description

We are looking for a skilled AWS Redshift Engineer to join our team at Viaprom Technologies Pvt Ltd. The ideal candidate will have experience in designing and implementing data warehousing solutions using AWS Redshift.

Roles and Responsibility

• Design, develop, and maintain large-scale data warehouses using AWS Redshift.
• Collaborate with cross-functional teams to identify business requirements and design data models.
• Develop and implement ETL processes to extract, transform, and load data from various sources into the target warehouse.
• Optimize query performance and troubleshoot issues related to data quality and integrity.
• Ensure compliance with security and scalability standards.
• Participate in code reviews and contribute to improving overall code quality.

Job Requirements

• Strong understanding of data modeling concepts and database design principles.
• Experience with ETL tools such as SQL Server Integration Services (SSIS) or similar technologies.
• Proficiency in writing complex queries and optimizing database performance.
• Excellent problem-solving skills and attention to detail.
• Ability to work collaboratively in a team environment and communicate effectively with stakeholders.
• Familiarity with agile development methodologies and version control systems like Git.