AWS Data Engineer
EXL · IT Services & Consulting
- Pune, Maharashtra, India
- Hybrid
- Posted today
- Data & AI
About the job
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
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).
Bachelor Degree