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)
Solid knowledge of joins and common table expressions (CTEs)
Experience in Snowflake, ETL, SQL, CI/CD
Robust expertise in ETL process and with various data model concepts
Knowledge of star schema and snowflake schema
Positive 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

📌 Aws Data Engineer Pune
🏢 EXL
📍 Pune