AWS Data Engineer

Job description

Job Description: 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