AWS Redshift Data Engineer

Job Title: AWS Redshift Data Engineer

Working Mode:- (Work from Office only)

Experience: 36 years (customizable)

Primary Skills: AWS Redshift, SQL, ETL/ELT, AWS Glue, S3, Python

Role Type: Data Engineering / Cloud Data Warehouse

Job Summary

We are looking for an experienced AWS Redshift Data Engineer with strong SQL skills and expertise in building, optimizing, and maintaining scalable data pipelines and cloud data warehouse solutions. The candidate should have hands-on experience with Amazon Redshift, complex SQL queries, ETL/ELT processes, performance tuning, and AWS data services.

Key Responsibilities

• Design, develop, and maintain data warehouse solutions using Amazon Redshift.
• Write complex SQL queries involving joins, subqueries, CTEs, window functions, and aggregations.
• Develop optimized SQL scripts, stored procedures, views, and data transformation logic.
• Build and maintain ETL/ELT pipelines using AWS Glue, S3, and other AWS services.
• Perform data ingestion from multiple sources into Amazon Redshift.
• Optimize query performance using EXPLAIN, distribution styles, sort keys, and workload management.
• Implement incremental data loads, CDC (Change Data Capture), and data reconciliation.
• Develop data quality checks and troubleshoot data pipeline failures.
• Work with large datasets and implement efficient data partitioning and storage strategies.
• Collaborate with analytics, BI, and business teams to deliver reliable data solutions.
• Monitor Redshift performance, query execution, storage utilization, and operational costs.
• Implement data security using IAM roles, encryption, and appropriate access controls.