AWS Redshift Data Engineer

Mployee.me; Delhi; On-site; INR 180,000 - 300,000; Full time

Job summary

Mployee.me in Delhi is seeking an experienced AWS Redshift Data Engineer to design, build, and optimize scalable data pipelines and cloud data warehouse solutions.

You will work with Redshift, SQL, ETL/ELT processes, and AWS services to deliver reliable data for analytics and BI teams while focusing on performance, security, and cost efficiency.

The role is office-based in Delhi and requires hands-on expertise and collaboration with cross-functional teams.

Qualifications

• Hands-on experience with Amazon Redshift and complex SQL queries.
• Experience building scalable data pipelines and cloud data warehouse solutions.
• Knowledge of performance tuning and AWS data services.

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, 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.

Skills

AWS Redshift

SQL

ETL/ELT

Python

Tools

AWS Glue

S3

Job description

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.