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:
- AWS Glue
- Amazon Redshift
- Amazon DynamoDB
- AWS Data Catalog/Crawler
- Good understanding of cloud-based data architectures and data integration.
Skills: sql,aws,data warehouse,data modelling
