Job Summary :

We are seeking an experienced AWS Data Engineer with 5+ years of expertise in designing, developing, and maintaining scalable data solutions.

The ideal candidate should have strong SQL programming skills, hands-on experience with AWS data services, data warehousing, ETL development, data modeling, and building robust data pipelines.

Key Responsibilities :

- Design, develop, and optimize scalable data pipelines for batch and real-time data processing.

- Develop and maintain ETL processes for data extraction, transformation, and loading.

- Write complex SQL queries using Window Functions, CTEs, Aggregate Functions, Joins, and Query Optimization techniques.

- Design and implement data warehouse solutions to support reporting and analytics.

- Perform data modeling and data due diligence to ensure data quality and integrity.

- Build and manage cloud-native data solutions using AWS services.

- Optimize database performance and troubleshoot data-related issues.

- Collaborate with business stakeholders, analysts, and development teams to deliver high-quality data solutions.

- Ensure adherence to data governance, security, and best practices.

Mandatory Skills :

- 5+ years of experience in Data Engineering.

- Strong SQL coding skills (Window Functions, Aggregate Functions, CTEs, Joins, Query Optimization).

- Hands-on experience with Data Warehousing and ETL development.

- Experience in Data Modeling and Data Due Diligence.

- Strong experience in designing and building Data Pipelines.

- Hands-on experience with AWS data services such as :

1. AWS Glue.

2. Amazon Redshift.

3. Amazon DynamoDB.

4. AWS Data Catalog/Crawler.

- Good understanding of cloud-based data architectures and data integration.

Skills :

- SQL, AWS, data warehouse, data modelling.