AWS Data Engineer
This role focuses on translating business needs into robust data models and performing reverse engineering of physical data models from databases and SQL scripts. The engineer will also design data architecture and propose integration solutions while leveraging Snowflake and advanced SQL skills.
Skills required
About this role
Role: Data Engineer
Location: Gurugram (Hybrid)
Key Role and Responsibilities:
• Understand and translate business needs into data models supporting long-term
solutions.
• Perform reverse engineering of physical data models from databases and SQL
scripts.
• Analyse data-related system integration challenges and propose appropriate
solutions.
• Assist with and support setting the data architecture direction (including data
movement approach, architecture/technology strategy, and any other data
related considerations to ensure business value).
Requirements:
• 5+ Years of experience as a Data Engineer
• Strong technical expertise in SQL Advanced SQL querying skills (joins, subqueries,
CTEs, aggregation)
• Strong knowledge of joins and common table expressions (CTEs)
• Experience in Snowflake, ETL, SQL, CI/CD
• Strong expertise in ETL process and with various data model concepts
• Knowledge of star schema and snowflake schema
• Good to know about AWS services such as S3, Athena, Glue, EMR/Spark with a
major emphasis on S3 and Glue
• Good knowledge of Python
Education: Bachelor’s degree in computer science, Software Engineering, MIS or equivalent
combination of education and experience
Key Skills: SQL, Snowflake, Python, AWS
Responsibilities
Key Role and Responsibilities:
• Understand and translate business needs into data models supporting long-term
solutions.
• Perform reverse engineering of physical data models from databases and SQL
scripts.
• Analyse data-related system integration challenges and propose appropriate
solutions.
• Assist with and support setting the data architecture direction (including data
movement approach, architecture/technology strategy, and any other data
related considerations to ensure business value).
Qualifications
Bachelor Degree
