Aws Data Engineer

EXL Service; Maharashtra; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

EXL Service is seeking a Data Engineer in Gurugram for a hybrid role. You will translate business needs into scalable data models, reverse engineer data structures from databases and SQL scripts, and tackle data integration challenges to enhance the data architecture.

Strong SQL, Snowflake, Python, and AWS skills are essential. The role requires 5+ years as a Data Engineer with hands-on ETL and data modeling experience.

Qualifications

• Bachelor's degree in CS/SE or MIS or equivalent.
• 5+ years of experience as a Data Engineer.
• Strong SQL, Snowflake, Python and AWS knowledge.
• Experience with ETL processes and data modeling.

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 (data movement, architecture/tech strategy, and related considerations).

Skills

SQL

Snowflake

Python

AWS

Education

Bachelor's degree in CS/SE/MIS or equivalent

Tools

ETL

CI/CD

S3

Athena

Glue

EMR/Spark

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