31 Oct
|
Vouchagram India
|
New Delhi
31 Oct
Vouchagram India
New Delhi
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 solid 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 effective 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.
📌 Aws Redshift Data Engineer New Delhi
🏢 Vouchagram India
📍 New Delhi